Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. ---------------- is used to retrieve tuples from the relation.
a. Create
b. Drop
c. Select
d. All of the above
Q. ……………… defines rules regarding the values allowed in columns and is the standard mechanismfor enforcing database integrity.
a. Column
b. Constraint
c. Index
d. Trigger
Q. For like predicate which of the following is true. i) % matches zero of more characters. ii) _ matches exactly one character.
a. i-only
b. ii-only
c. Both of them
d. None of them
Q. The relational model is based on the concept that data is organized and stored in two-dimensionaltables called ……………………….
a. Fields
b. Records
c. Relations
d. Keys
Q. ……………….. contains information that defines valid values that are stored in a column or datatype.
a. View
b. Rule
c. Index
d. Default
Q. Which of the syntax is correct for insert statement?i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
a. i-only
b. ii-only
c. Both of them
d. None of them
Q. ………………. first proposed the process of normalization.
a. Edgar. W
b. Edgar F. Codd
c. Edward Stephen
d. Edward Codd
Q. For using a specific database …………… command is used.
a. Use database
b. <Database name> use
c. Both A &B
d. None of them
Q. An outstanding functionality of SQL is its support for automatic ………… to the target data.
a. Programming
b. Functioning
c. Navigation
d. Notification
Q. ………………… is a special type of integrity constraint that relates two relations & maintainsconsistency across the relations.
a. Entity Integrity Constraints
b. Referential Integrity Constraints
c. Domain Integrity Constraints
d. Key Constraints
Q. ……………..specifies a search condition for a group or an aggregate.
a. GROUP BY Clause
b. HAVING Clause
c. FROM Clause
d. WHERE Clause
Q. Drop Table cannot be used to drop a table referenced by a …………… constraint.
a. Local Key
b. Primary Key
c. Composite Key
d. Foreign Key
Q. Which are the not features of a DBMS which provide a number of advantages for data management:
a. DML
b. DDL
c. SDL
d. None of these
Q. Minimal data redundancy means improved _________:
a. Data independence
b. Data consistency
c. Data integration
d. Data sharing