DBMS MCQ SET-4

1. Dashed ellipse are used to represent which attribute ?

(A) Simple attribute
(B) Base attribute
(C) Derived attribute
(D) Descriptive attribute

2. Data is ______ information?

(A) Raw
(B) Polished
(C) Computer output
(D) None of the above

3. Create table is the ______ command.

(A) DDL
(B) DML
(C) DQL
(D) DCL

4. Which of the following is a database administrator’s function ?

(A) Database design
(B) Performing monitoring
(C) User coordination
(D) All of the above

5. ER represents the relationship between

(A) Attributes
(B) DATA
(C) Entities
(D) None of the above

6. A candidate key is a subset of

(A) Primary key
(B) Foreign key
(C) Super key
(D) None of the above

7. The relational model represents the database as a collection of

(A) Entities
(B) Relations
(C) Database
(D) None of the above

8. The process of designating subgrouping within an entity set is called –

(A) Specialization
(B) Generalization
(C) Aggregation
(D) None of the above

9. The entity integrity constraint states that no primary key value can be

(A) Zero
(B) One
(C) Null
(D) None of these

10. For each attribute there is set of permitted valued called

(A) Tuple
(B) Row
(C) Domain
(D) None of the above

11. Second normal form(2NF) is based on the concept of –

(A) Transitive
(B) Full functional dependency
(C) Both
(D) None of the above

12. Normalization is used for –

(A) Eliminating redundant data
(B) Providing security
(C) Maintenance of database
(D) None of the above

13. Decomposition should always be

(A) Lossy
(B) Lossless
(C) Both
(D) None of the above

14. A functional dependency is basically a constraint between sets of attributes from the database.

(A) Two
(B) Three
(C) Four
(D) None of the above

15. The lowest level of data abstraction is

(A) Logical
(B) Physical
(C) View
(D) None of the above

16. Double rectangles are used to represent ______ entity set.

(A) Strong
(B) Weak
(C) Double
(D) None of the above

17. Two phase lacking does not ensure freedom from ______

(A) Data security
(B) Deadlock
(C) Data loss
(D) None of the above

18. Which of the following is DCL command ?

(A) RENAME
(B) GRANT
(C) UPDATE
(D) None of the above

19. Which of the following operation is used if we are instrested in only certain columns of a table?

(A) Projection
(B) Selection
(C) Union
(D) Join

20. DBMS helps achieve :

(A) Data independence
(B) Centralized control of data
(C) Neither (a) nor (b)
(D) Both (a) and (b)