Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which algebra is widely used in DBMS?
a. relational algebra
b. arithmetic algebra
c. both
d. none
Q. Which of the following is an unary operation?
a. selection operation
b. generalized selection
c. primitive operation
d. projection operation
Q. Which SQL Query is use to remove a table and all its data from the database?
a. create table
b. alter table
c. drop table
d. none of these
Q. In precedence of set operators the expression is evaluated from:
a. left to left
b. left to right
c. right to right
d. right to left
Q. In DBMS FD stands for _______
a. facilitate data
b. functional data
c. facilitate dependency
d. functional dependency
Q. How many types of keys in Database Design?
a. candidate key
b. primary key
c. foreign key
d. all of these
Q. Which of the following is based on Multi Valued Dependency?
a. first
b. second
c. third
d. fourth
Q. Which of the following is the structure of the Database?
a. table
b. schema
c. relation
d. none of these
Q. The minimal set of super key is called
a. primary key
b. secondary key
c. candidate key
d. foreign key
Q. A relation that has no partial dependencies is in which normal form
a. first
b. second
c. third
d. bcnf
Q. A functional dependency between two or more non-key attributes is called
a. transitive dependency
b. partial transitive dependency
c. functional dependency
d. partial functional dependency
Q. A logical description of some portion of database that is required by a user to perform task is called as
a. system view
b. user view
c. logical view
d. data view
Q. ______________ is a classical approach to database design?
a. left – right approach
b. right – left approach
c. top – down approach
d. bottom – up approach
Q. _____________ refers to the correctness and completeness of the data in a database?
a. data security
b. data integrity
c. data constraint
d. data independence
Q. A table that displays data redundancies yields ____________ anomalies
a. insertion
b. deletion
c. update
d. all of the above