Database Management System MCQ Set 3

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. ............... joins are SQL server default

A) Outer
B) Inner
C) Equi
D) None of the above


7. The ..................... is essentially used to search for patterns in target string.

A) Like Predicate
B) Null Predicate
C) In Predicate

D) Out Predicate


8. Which of the following is/are the Database server functions?
i) Data management            ii) Transaction management
iii) Compile queries            iv) Query optimization

A) i, ii, and iv only
B) i, ii and iii only
C) ii, iii and iv only
D) All i, ii, iii, and iv


9. To delete a database ................... command is used

A) delete database database_name
B) Delete database_name
C) drop database database_name
D) drop database_name


10. .............. is a combination of two of more attributes used as a primary key

A) Composite Key
B) Alternate Key
C) Candidate Key
D) Foreign Key

Answers

1.c

2.c

3.c

4.b

5.a

6.b

7.a

8.a

9.c

10.a