DBMS MCQ SET-1

1. DBA stands for

(A) Data Bank Access
(B) Database Access
(C) Database Administrator
(D) Database Assistant

2. In ER diagram, the total participation by entities is represented as ______

(A) Dashed line
(B) Rectangle
(C) Double rectangle
(D) Double line

3. The feature that database allows to access only certain records in database is ______

(A) Queries
(B) Reports
(C) Forms
(D) Tables

4. Which of the following is not a property of transactions?

(A) Atomicity
(B) Concurrency
(C) Isolation
(D) Durability

5. Relational Algebra does not have

(A) Selection operator
(B) Projection operator
(C) Aggregation operator
(D) Division operator

6. Tree structure are used to store data in

(A) Network model
(B) Relation model
(C) Hierarchical model
(D) File based system

7. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

(A) Procedural DML
(B) Non-procedural DML
(C) Procedural DDL
(D) Non-procedural DDL

8. The rule that a value of a foreign key must appear as a value of some specific table is called a

(A) Referential constraint
(B) Index
(C) Integrity constraint
(D) Functional dependency

9. In an ER diagram double lines indicate

(A) Total participation
(B) Multiple participation
(C) Cardinality N
(D) None of the above

10. Fifth Normal form is concerned with

(A) Functional dependency
(B) Multivalued dependency
(C) Join dependency
(D) Domain key

11. The metadata is created by the

(A) DML compiler
(B) DML pre-processor
(C) DDL interpreter
(D) Query interpreter

12. When an ER diagram is mapped to tables, the representation is redundant for

(A) Weak entity sets
(B) Weak relationship sets
(C) Strong entity sets
(D) Strong relationship sets

13. If the closure of an attribute set is the entire relation then the attribute set is a

(A) Superkey
(B) Candidate key
(C) Primary key
(D) Not a key

14. The keyword to eliminate duplicate rows from the query result in SQL is

(A) DISTINCT
(B) NO DUPLICATE
(C) UNIQUE
(D) None of the above

15. The information stored in the catalog of a database is called

(A) Distributed data
(B) Raw data
(C) Encapsulated data
(D) Meta

16. The method of access which uses key transformation is known as

(A) Direct
(B) Hash
(C) Random
(D) Sequential

17. 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)

18. The statement in SQL which allows to change the definition of a table is

(A) Alter
(B) Update
(C) Create
(D) Select

19. SET concept is used in

(A) Network model
(B) Hierarchical model
(C) Relational model
(D) None of these

20. ______ produces the relation that has attributes of R1 and R2

(A) Cartesian product
(B) Difference
(C) Intersection
(D) Product