Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which is a bottom-up approach to database design that design by examining therelationship between attributes:
a. Functional dependency
b. Database modeling
c. Normalization
d. Decomposition
Q. In decomposition technique of splitting a relation into_____ relation:
a. ONE or MORE
b. TWO or MORE
c. THREE or MORE
d. FOUR or MORE
Q. Consequently R.Boyce-Codd jointly launched powerful definition for the third normalform called______:
a. Boyce-Codd normal form
b. First normal form
c. Second normal form
d. All of these
Q. BCNF stands for:
a. Basic -Codd normal form
b. Build -Codd normal form
c. Boyce-Codd normal form
d. None of these
Q. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
a. 1NF
b. 2NF
c. 3NF
d. All of these
Q. PJNF stands form:
a. Practically –join normal form
b. Project –join normal form
c. Pages –join normal form
d. programming –join normal form
Q. The DBMS utility, ____________ allows to reconstruct the correct state of database fromthe backup and history of transactions.
a. Backup
b. Recovery
c. Monitoring
d. Data loading
Q. In the ........... normal form, a composite attribute is converted to individual attributes.
a. First
b. Second
c. Third
d. Fourth
Q. In RDBMS, Data is presented as a collection of ............
a. Table
b. Attributes
c. Relations
d. Entities
Q. To select all column from the table the syntax is:
a. Select all from table_name
b. Select * from table_name
c. Select from table_name
d. Non of the above
Q. For using a specific database …………… command is used.
a. use database
b. databasename use
c. Both A &B
d. None of them