Database MCQ’s

Database MCQ’s

1. Table with similar records is

A. Record

B. Field

C. File

D. None

Answer - Click Here:
C

2. SQL is a

A. Software

B. Structured language

C. Unstructured language

D. Object oriented language

Answer - Click Here:
B

3. Retrival  and storage of data is

A. Managing output

B. Data manipulation

C. Data capturing

D. All of these

Answer - Click Here:
A

4. Process of merging relations is …

A. View relations

B. View data models

C. View integration

D. None of these

Answer - Click Here:
C

5. In  E-R diagram, an oval is for

A. Relationship

B. Entity

C. Attribute

D. Process

Answer - Click Here:
A

6. Example of one-to-many relationship in E-R diagram

A. Father-son

B. Teacher-student

C. Country-capital

D. Mother-daughter

Answer - Click Here:
A &D

7. We can create an index on

A. Foreign key

B. Secondary key

C. Primary key

D. All of above

Answer - Click Here:
D

8. The relationship between data objects is …

A. Data table

B. Data flow Diagram

C. Data modelling

D. None of these

Answer - Click Here:
C

9. We can represent optional relationship by

A. O

B. />

C. </

D. ^

Answer - Click Here:
A

10. Modality is also related to …

A. Mandatory

B. Cardinality

C. Optional

D. Logical

Answer - Click Here:
B &C

11.  Basic data distribution strategy is …

A. Replicated

B. Centralized

C. Partitioned

D. All of the above

Answer - Click Here:
D

12. Physically arranging records on secondary storage devices of a file is …

A. File organization

B. Integrity constraints

C. Indexes

D. Data distribution strategy

Answer - Click Here:
A