Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following is not a restriction for a table to be a relation?
a. The cells of the table must contain a single value.
b. All of the entries in any column must be of the same kind.
c. The columns must be ordered.
d. No two rows in a table may be identical.
Q. For some relations, changing the data can have undesirable consequences called:
a. Referential integrity constraints.
b. Modification anomalies.
c. Normal forms.
d. Transitive dependencies.
Q. One solution to the multivalued dependency constraint problem is to:
a. split the relation into two relations, each with a single theme
b. Change the theme.
c. Create a new theme.
d. add a composite key
Q. FD stands for:
a. Functional dependency
b. Facilitate dependency
c. Functional data
d. Facilitate data
Q. In which model of database data is stored in tables:
a. Network model
b. Relational model
c. Hierarchical model
d. None of these
Q. How many types of keys in relation database design:
a. Primary key
b. Candidate key
c. Foreign key
d. All of these
Q. Which key is referencing a primary key in a table:
a. Primary key
b. Candidate key
c. Foreign key
d. All of these
Q. Which rules are defined in relational models they from as an essential part of any relationdatabase:
a. Integrity rules
b. Database
c. Record
d. Memory
Q. Which are the types of integrity rule:
a. Entity integrity
b. Referential integrity
c. Both
d. None
Q. ______states that primary keys should not be null:
a. Entity integrity
b. Referential integrity
c. Both
d. None
Q. Which command creates database objects like tables, views and indexes:
a. Create command
b. Update command
c. Both
d. None
Q. Which command enables alteration the data stored in existing records:
a. Create command
b. Update command
c. Deletion command
d. All of these
Q. Which are the dependencies types:
a. Full functional dependency
b. Partial dependency
c. Trivial functional dependency
d. All of these
Q. FDs are the types of constraints that are based on______:
a. Key
b. Key revisited
c. Superset key
d. None of these