Computer Science Class 12 Chapter 2 Basic Concepts and Terminology Test Paper
Computer Science Class 12 Chapter 2 Basic Concepts and Terminology Test Paper
Q.1: Tick the correct Option.
1. A key that is used strictly for data retrieval purposes:
(a) primary key
(b)secondary key✅
(c) composite key
(d) alternate key
2. Which of the following is also known as control key?
(a) Sort key✅
(b) Composite key
(c) Primary key
(d) Foreign key
3. CREATE command is used to create
(a) Table✅
(b) Query
(c) Field
(d) Botha & b
4. A relation is analogous to a :
(a) File
(b) Field
(c) Record
(d)All✅
5. Which one is powerful database language?
(a) DBMS
(b) SQL✅
(c) File system
(d) Botha & b
Q.2: Give answer to any eight short questions of the following.
1. Define database administrator.
2. Define the term relation.
3. What is entity?
4. Enlist properties of a relation.
5. Define view and its purpose.
6. What is data base administrator?
7. Writhe the name of types of keys.
8. How the tables are formed in DBMS
Q3: Give answer to any two questions of the following.
(a) What is uses of indexes in FMS and DBMS
(b) Write down the properties of relations in detail.