Solved MCQ of Database Management System (DBMS) Set - 5


1. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

A) Fields

B) Records

C) Relations

D) Keys


2. ……………….. contains information that defines valid values that are stored in a column or data type.

A) View

B) Rule

C) Index

D) Default


3. 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


4. ………………. First proposed the process of normalization.

A) Edgar. W

B) Edgar F. Codd

C) Edward Stephen

D) Edward Codd


5. For using a specific database …………… command is used.

A) use database

B) database name use

C) Both A &B

D) None of them


6. Which of the following is not comparison operator?

A) <>

B) <

C) =<

D) >=


7. An outstanding functionality of SQL is its support for automatic ………… to the target data.

A) programming

B) functioning

C) navigation

D) notification


8. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A) Entity Integrity Constraints

B) Referential Integrity Constraints

C) Domain Integrity Constraints

D) Domain Constraints

E) Key Constraints


9. ……………..specifies a search condition for a group or an aggregate.

A) GROUP BY Clause

B) HAVING Clause

C) FROM Clause

D) WHERE Clause


10. 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


Answers:

1. C) Relations
2. C) Index
3. C) Both of them
4. B) Edgar F. Codd
5. A) use database
6. C) =<
7. C) navigation
8. B) Referential.....Constraints
9. B) HAVING Clause
10. D) Foreign Key

Get 1000's of DBMS MCQs as pdf E-Book on Free Download Now