Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. To eliminate duplicate rows ……………… is used
a. NODUPLICATE
b. ELIMINATE
c. DISTINCT
d. None of these
Q. State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
a. i-true, ii-false
b. i-false, ii-true
c. i-true, ii-true
d. i-false, ii-false
Q. DCL stands for
a. Data Control Language
b. Data Console Language
c. Data Console Level
d. Data Control Level
Q. …………………… is the process of organizing data into related tables.
a. Normalization
b. Generalization
c. Specialization
d. None of the above
Q. A ………………. does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.
a. Weak entity
b. Strong entity
c. Non attributes entity
d. Dependent entity
Q. …………….. is the complex search criteria in the where clause.
a. Substring
b. Drop Table
c. Predict
d. Predicate
Q. ………………… is preferred method for enforcing data integrity
a. Constraints
b. Stored Procedure
c. Triggers
d. Cursors
Q. The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..
a. Degree, Cardinality
b. Cardinality, Degree
c. Rows, Columns
d. Columns, Rows
Q. State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
a. i-True, ii-False
b. i-True, ii-True
c. i-False, ii-True
d. i-False, ii-False
Q. …………… database is used as template for all databases created.
a. Master
b. Model
c. Tempdb
d. None of the above
Q. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values canbe assigned to each data items. This is referred to as
a. Data Security
b. Domain access
c. Data Control
d. Domain Integrity
Q. ………………….. operator is basically a join followed by a project on the attributes of first relation.
a. Join
b. Semi-Join
c. Full Join
d. Inner Join
Q. Which of the following is not a binary operator in relational algebra?
a. Join
b. Semi-Join
c. Assignment
d. Project
Q. Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures theconsistency and validity of the database.
a. Increases
b. Skips
c. Does not reduce
d. Reduces