Tag: DBMS Mcq

(A) ROOM_ID, BUILD_ID ? ROOM_SCH
(B) ROOM_ID + BUILD_ID ? ROOM_SCH
(C) ROOM_ID, ROOM_SCH ? BUILD_ID
(D) ROOM_ID, BUILD_ID ? ROOM_SCH

(A) primary key
(B) data anomaly
(C) dependency
(D) transitive relationship

(A) An attribute or combination of attributes that allows the user to search for non-unique data
(B) An attribute or combination of attributes that is calculated from existing data
(C) An attribute or combination of attributes that establishes relationships between tables
(D) An attribute or combination of attributes that could be, but is not, used as a PK

(A) Inclusion of derived attributes is a standard procedure and does not require justification
(B) Derived attributes should be used when they add to design elegance
(C) Query speed is enhanced by not computing derived attributes
(D) Poor design is the only excuse for the inclusion of derived attributes

(A) A data storage facility dedicated to using the existing data to generate information
(B) Frequent and complex transactions characterize its use
(C) The most common type of database in use today
(D) Generally used in environments with large inventories, thus the term warehouse

(A) A RDBMS uses metadata while a DBMS does not
(B) A DBMS is used for data warehousing
(C) Because a relational database is more complicated than a conventional database, the RDBMS requires much more computing power than the conventional DBMS requires
(D) Because a conventional database is less complicated than a relational database, the DBMS is used more often for transactional databases

(A) It ensures and enforces data integrity at all levels
(B) It maintains an environment in which security is created and enforced
(C) It manages the metadata in the data dictionary
(D) All of the above are services of a DBMS

(A) DML
(B) DDL
(C) DCL
(D) DQL