Computer : : Database Management System Questions & Answers
- The process of reading a database schema and producing a data model from that schema is known as
A. Data modeling
B. Reverse engineering
C. Database design
D. None of above
- Which of the following modifications may not succeed?
A. Changing a column data type from char to date
B. Changing a column data type from numeric to char
C. Both of the above actions should succeed
D. Neither of the above actions will succeed
- To drop a column that is used as a foreign key, first
A. drop the primary key
B. drop the table containing the foreign key
C. drop the foreign key constraint
D. All of above
- Which is not true of a correlated subquery?
A. EXISTS/NOT EXISTS is a form of a correlated subquery
B. The processing of the SELECT statements is nested
C. They can be used to verify functional dependencies
D. They are very similar to a regular subquery
- Which of the following is a technique for hiding the internal implementation details of an object?
A. Encapsulation
B. Polymorphism
C. Inheritance
D. None of above