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
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
11) Which of the following operations is not part of the five basic set operations in relational algebra?
a) Union
b) Division
c) Cartesian Product
d) Set Difference
12) A lack of normalization can lead to which one of the following problems?
a) Insertion problems
b) Deadlock
c) Lost Updates
d) Deferred Updates
13) Which of the following relational algebraic operation is not a commutative operation?
a) Union
b) Intersection
c) Selection
d) Project
14) Constraints are specified as a part of
a) Data definition
b) Data Manipulation
c) Data Control
d) None of the above
15) Which of the following is not a file operation?
a) FindNext
b) Find
c) Reset
d) None of the above
16) Relations produced from an E-R model will always be in
a) First normal form
b) Second normal form
c) third normal form
d) Fourth normal form
17) If the precedency graph of a given schedule is acyclic, then schedule—
a) will be always serializable
b) will never serializable
c) may be serializable
d) can’t say
18) What is the goal of concurrency control protocol?
a) schedule should be serializable
b) schedule should be recoverable
c) both (a) and (b)
d) none of these
19) Student and courses enrolled, is an example of
a) one-to-one relationship
b) one-to-many relationship
c) many-to-many relationship
d)many-to-one relationship
20) Which of the following is generally a benefit of normalization??
a) performance is improved
b) insertion anomalies are avoided
c) Selection anomalies are avoided
d) number of tables is reduced
21) The set permitted values for each attribute is called is
a) attribute set
b) Attribute range
c) domain
d) Group