Database Management System MCQ Set 10

1) A relational database developer refers to a record as

A. a criteria
B. a relation
C. a tuple
D. an attribute


2) .......... keyword is used to find the number of values in a column.

A. TOTAL
B. COUNT
C. ADD
D. SUM


3) An advantage of the database management approach is

A. data is dependent on programs
B. data redundancy increases
C. data is integrated and can be accessed by multiple programs
D. none of the above


4) The collection of information stored in a database at a particular moment is called as ......

A. schema
B. instance of the database
C. data domain
D. independence


5) Data independence means

A. data is defined separately and not included in programs.
B. programs are not dependent on the physical attributes of data
C. programs are not dependent on the logical attributes of data
D. both B and C


6) A ......... is used to define overall design of the database

A. schema
B. application program
C. data definition language
D. code


7) Key to represent relationship between tables is called

A. primary key
B. secondary key
C. foreign key
D. none of the above


8) Grant and revoke are ....... statements.

A. DDL
B. TCL
C. DCL
D. DML


9) DBMS helps achieve

A. Data independence
B. Centralized control of data
C. Neither A nor B
D. Both A and B


10) .......... command can be used to modify a column in a table

A. alter
B. update
C. set
D. create

Answers

1.c

2.b

3.c

4.b

5.d

6.a

7.c

8.c

9.d

10.a