2nd Year NotesComputer class 12th

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.

Related Articles

Back to top button
error: Content is protected !!
Enable Notifications OK No thanks