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

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

Answers:

Related Posts

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

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

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

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