Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

Database MCQ’s

Table of Contents

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

 

 

Fazal Rehman Shamil Click Here to Know More
Instructor, Researcher, Blogger, SEO Expert, Poet and Publisher of International Journal Of Software, Technology & Science ISSN : 2616 - 5325
Dear Professors and Resarchers!You are welome to Cite these tutorials in your research or slides etc. Please don't forget to mention the reference of website. Copy Paste of text is strcitly forbidden. Images can be reuse because images are protected with watermark.

Leave a Reply

Your email address will not be published. Required fields are marked *