Page 384 - TP_IT_V1.0_C10_flipbpookl
P. 384
10. Which of the following is not an example of DBMS? [2023]
a. PostgreSQL b. SQLite
c. FoxPro d. Impress
11. Which of the following is expanded form of SQL? [2023]
a. Systematic Query Language b. Structure Query Language
c. Software Query Language d. Structural Query Language
12. Which one of the following is an example of RDBMS? [2022]
a. MongoDB b. Windows registry
c. Publisher d. Oracle
13. The has evolved since the 1960s to ease increasing difficulties in designing, building and maintaining
complex information systems. [2022]
a. Knowledge concept b. Formula concept
c. Database concept d. Forms concept
14. Malini wants to store a huge amount of information about her zone in a database. Should not be repeated in her file. Her
friend Gargi explained her various benefits of storing data in RDBMS. It helps in preventing/controlling duplication of data.
Which of the following terms is used to refer to duplication data? [2022]
a Data sharing b. Data privacy
c. Data redundancy d. Data integrity
15. Explain the term Sorting. [2022]
16. Explain any two types or relationship that can be created in tables.
17. What is difference between Form and Report? [2022]
18. Identify any two Column name/Attribute and their data types from a given table: [2022]
Table : PLAYER
DOB PNAME RUNS GENDER DOB
P1Ol SACHIN 13000 M 10/04/2001
P102 KAPIL 7000 M 12/02/1998
P103 SAURABH 12000 M 13/04/2001
P104 VIRAT 12500 M 17/03/2005
19. Consider the following table: [2022]
Table : STUDENT
ADMNO NAME GRADE DOB MARKS HOUSE GENDER
1001 RUPAL 9 10/04/2006 76 GREEN M
1002 RASHMI 9 08/12/2005 87 RED F
1003 ARNAV 10 25/05/2004 81 GREEN M
1004 SUMONA 9 23/08/2005 68 RED F
1005 ARUN 9 16/07/2005 72 GREEN M
1006 TIA 9 22/09/2005 91 BLUE F
1007 ROSHAN 10 26/08/2004 89 BLUE M
Write SQL Commands:
a. To display the details of all students of Green House.
b. To increase the marks by 5 whose ADMNO is 1005.
382 Trackpad Information Technology (Ver. 1.0)-X

