Database Management MCQ Questions Answers Computer Engineering CSE

Database Management MCQ Questions Answers Computer Engineering

1) Which normal form is considered adequate for relational database design?

a) 2 NF

b) 3 NF

c) 4 NF


View Answer
Option – b)

2) The column of table is referred to as the

a) tuple

b) attribute

c) entity

d) degree

View Answer
Option – b)

3) E-R modeling technique is a

a) top-down approach

b) bottom approach

c) left-right approach

d) both top-down and bottom-up

View Answer
Option – a)

4) What describes database latching best ?

a) Kept in lock manager’s Hash Table

b) It is a type of a lock that can be very quickly acquired and freed.

c) Protects database content

d) Non of the above

View Answer & Explanation
Option – d)

Explanation- Latches are quickly acquired low-level serialization mechanisms to protect shared data structures where lock protects the index’s logical contents from other transactions and kept in lock managers hash table.

5) Redundancy is dangerous as it a Potential threat to data

a) integrity

b) consistency

c) sufficiency

d) both (a) and (b) above

View Answer
Option – d)

6) What does the data dictionary identify ?

a) Field names

b) Filed types

c) filed formats

d) All of the above

View Answer
Option – d)

7) Data independency  in DBMS is known as

a) Data modeling

b) Data hiding

c) Data capturing

d) Data consistency

View Answer
Option – a)

8) If a relation scheme is in BCNF, then it is also in

a) first normal form

b) second normal form

c) third normal formal

d) All of the above

View Answer
Option – d)

9) The way a particular application views the data from the database that the application uses is a

a) module

b) relatioanal

c) schema

d) subschema

View Answer
Option – d)

10) Which is the discrimination of the weak entity?

a) Account number

b) Transaction number

c) {account number,data}

d) Data

View Answer
Option – b)

error: Content is protected !!