Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. The DROP TABLE statement:
a. Deletes the table structure only
b. Deletes the table structure along with the table data
c. works whether or not referential integrity constraints would be violated
d. is not an SQL statement
Q. Which of the following is NOT a type of SQL constraint?
a. PRIMARY KEY
b. FOREIGN KEY
c. ALTERNATE KEY
d. UNIQUE
Q. The following are functions of a DBMS except ________
a. creating and processing forms
b. processing data
c. creating databases
d. administrating databases
Q. What SQL structure is used to limit column values of a table?
a. The LIMIT constraint
b. The CHECK constraint
c. The VALUE constraint
d. None of the above is correct.
Q. The different classes of relations created by the technique for preventing modification anomaliesare called:
a. Normal forms.
b. Referential integrity constraints.
c. Functional dependencies.
d. None of the above
Q. A relation is in this form if it is in BCNF and has no multivalued dependencies:
a. Second normal form.
b. Third normal form
c. Fourth normal form.
d. Domain/key normal form.
Q. The primary key is selected from the:
a. Composite keys
b. Candidate keys
c. Foreign keys
d. Determinants
Q. Which of the following is a group of one or more attributes that uniquely identifies a row?
a. Key
b. Tuple
c. Determinant
d. Relation
Q. When the values in one or more attributes being used as a foreign key must exist in another set ofone or more attributes in another table, we have created a(n):
a. Transitive dependency
b. Insertion anomaly.
c. Referential integrity constraint.
d. Normal form
Q. A relation is considered a:
a. Column
b. One dimensional table
c. Two dimensional table
d. Three dimensional table
Q. In the relational model, relationships between relations or tables are created by using:
a. Candidate keys
b. Foreign keys
c. Composite Keys
d. Determinants
Q. A functional dependency is a relationship between or among:
a. Tables
b. Rows
c. Relations
d. Attributes