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.