Exercise : Database Management System MCQ Questions and Answers
Question 1
Transaction X holds a shared lock R. if transaction Y requests for a shared lock on R :
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Immediately Granted
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Which of the following is at highest level in the hierarchy of data organization?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Database
Description :
No answer description available for this question. Let us discuss.
Question 3
Match : a.Foreign keys i.Domain constraint b.Private key ii.Referential integrity c.Event control action model iii.Encryption d.Data security iv. Trigger
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. a b c d ii i iv iii
Description :
No answer description available for this question. Let us discuss.
Question 4
Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. All of the these
Description :
All of the these
We should roll back those transactions that will incur the minimum cost.
Question 5
______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Referential Integrity Constraints
Description :
No answer description available for this question. Let us discuss.
Question 6
Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Schema, Instance
Description :
Schema, Instance
Instance is a instance of time and schema is a representation.
Question 7
Literals in java must be preceded by which of these?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Both L and I
Description :
Data type long literals are appended by an upper or lowercase L.
Question 8
Report generators are used to
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Answer queries
Description :
No answer description available for this question. Let us discuss.
Question 9
Which of following is the problem of file management system? (a) Lack of data independence(b) Data redundancy(c) Update (d) all Periodically adding, changing, & Deleting file records is called file
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Renewing
Description :
No answer description available for this question. Let us discuss.
Question 10
Which of the following statements creates a new table temp instructor that has the same schema as instructor.
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Create table temp_instructor like instructor;
Description :
No answer description available for this question. Let us discuss.