Database Management MCQ Questions Answers Computer Engineering
Database Management is a crucial aspect of modern information technology, enabling efficient storage, organization, retrieval, and manipulation of data. Whether you are a student, a professional, or simply curious about databases, testing your knowledge through Multiple Choice Questions (MCQs) can be an excellent way to reinforce your understanding. In this article, we present a collection of MCQs related to Database Management, along with detailed answers and explanations to help you enhance your expertise in this field.
1) Which normal form is considered adequate for relational database design?
a) 2 NF
b) 3 NF
c) 4 NF
d) BCNF
2) The column of table is referred to as the
a) tuple
b) attribute
c) entity
d) degree
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
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
5) Redundancy is dangerous as it a Potential threat to data
a) integrity
b) consistency
c) sufficiency
d) both (a) and (b) above
6) What does the data dictionary identify ?
a) Field names
b) Filed types
c) filed formats
d) All of the above
7) Data independency in DBMS is known as
a) Data modeling
b) Data hiding
c) Data capturing
d) Data consistency
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
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
10) Which is the discrimination of the weak entity?
a) Account number
b) Transaction number
c) {account number,data}
d) Data