Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part21 : 1 to 5

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

1.Which of the following models is concerned with what is represented in the database, rather than how it is represented?

Conceptual model

View model

Physical model

External model

Implementation model.

2.A foreign key must

Be numeric

Be unique

Be defined in all tables within the database

Match the field value of a primary key in a related table

Contain only one attribute.

3.DBMS periodically suspends all processing and synchronizes its files and journals through the use of #330.DBMS periodically suspends all processing and synchronizes its files and journals through the use of

Checkpoint facility

Backup facility

Recovery manager

Database change log

Shadow Paging.

4.Which of the following specifies that an entity can be a member of only one subtype at a time?

Removal

Exclusion

Disjoint

Inclusion

Overlapping.

5.Which of the following options depicts the organization of data in a relational database?