Page 334 - Trackpad 402_Class-X_Final
P. 334
Previous Years' Questions
1. Which of the following is not an example of DBMS? [2023]
a. PostgreSQL b. SQLite
c. FoxPro d. Impress
2. 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
3. Which one of the following is an example of RDBMS? [2022]
a. MongoDB b. Windows registry
c. Publisher d. Oracle
4. 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
5. 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
6. Explain the term Sorting. [2022]
7. Explain any two types or relationship that can be created in tables.
8. What is difference between Form and Report? [2022]
9. Identify any two Column name/Attribute and their data types from a given table: PLAYER [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
10. statement is used to add one or more records to a database. [2020]
11. statement retrieves zero or more rows from one or more database tables. [2020]
12. Explain two types of languages used for creating and manipulating the data in databases. [2020]
13. Explain any three data types in OpenOffice Base. [2020]
14. Explain the following with respect to Databases: [2020]
a. Forms b. Reports
c. Table d. Primary key?
e. Categorise the following commands as DDL and DML :
SELECT, ALTER, INSERT, DROP
15. What is RDBMS? [2019]
16. What is database server ? Explain Primary key and Foreign key. [2019]
17. What do DBMS and RDBMS stand for? Explain in short. [2017]
18. What do you mean by primary key and foreign key? [2017]
334 Trackpad Information Technology-X

