Database Management Questions & Answers: part1



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

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

1.The relationship between DEPARTMENT and EMPLOYEE is a

One-to-one relationship
One-to-many relationship
Many-to-many relationship
Many-to-one relationship
None of the above.

2.Which of the following is the process of selecting the data storage and data access characteristics of the database?

Logical database design
Physical database design
Testing and performance tuning
Evaluation and selecting
External database design.

3.Which of the following does refer to the size of the data item chosen as the unit of protection by a concurrency control program?

Granularity
Lock
Starvation
Timestamp
Time based.

4.Which of the following is an attribute that can uniquely identify a row in a table?

Secondary key
Candidate key
Foreign key
Alternate key
None of the above.

5.Ensuring isolation property is the responsibility of the

Recovery-management component of the DBMS
Concurrency-control component of the DBMS
Transaction-management component of the DBMS
Buffer management component in DBMS
Query processor in DBMS.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha