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) databasename use

C) Both A &B

D) None of them

 

6. Which of the following is not comparison operator?

A) <>

B) <

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

D) 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