(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
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
A __ is established when the value of one attribute is dependent on the value of another attribute?
(A) primary key
(B) data anomaly
(C) dependency
(D) transitive relationship
Select the statement that best defines a candidate key?
(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
Which of the following justifies the inclusion of derived attributes in a database?
(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
Which of the following statements best describes a data warehouse?
(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
What is the difference between a DBMS and an RDBMS?
(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
Which of the following is a service provided by a DBMS?
(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
REATE TABLE and CREATE index belongs to which type of SQL commands?
(A) DML
(B) DDL
(C) DCL
(D) DQL