Database Management System Set 15
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
On This Page
This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 15
Q1 | A data type that creates unique numbers for key columns in Microsoft Access is:
- autonumber
- boolean
- sequential key
- sequential number
Q2 | A dependency exist between two columns when
- together they constitute a composite key for the table
- knowing the value in one column determines the value stored in another column
- the table is in 3nf
- together they constitute a foreign key
Q3 | In the normal form, a composite attribute is converted to individual attributes.
- first
- second
- third
- fourth
Q4 | Tables in second normal form (2NF):
- eliminate all hidden dependencies
- eliminate the possibility of a insertion anomalies
- have a composite key
- have all non key fields depend on the whole primary key
Q5 | Functional Dependencies are the types of constraints that are based on
- key
- key revisited
- superset key
- none of the mentioned
Q6 | Which is a bottom-up approach to database design that design by examining the relationship between attributes:
- functional dependency
- database modeling
- normalization
- decomposition
Q7 | A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.
- 2nf
- 3nf
- bcnf
- 1nf
Q8 | What are the desirable properties of a decomposition
- partition constraint
- dependency preservation
- redundancy
- security
Q9 | R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
- a->b, b->cd
- a->b, b->c, c->d
- ab->c, c->ad
- a->bcd
Q10 | The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
- bcnf algorithm
- 2nf algorithm
- 3nf synthesis algorithm
- 1nf algorithm
Q11 | Which normal form is considered adequate for normal relational database design?
- 2nf
- 5nf
- 4nf
- 3nf
Q12 | Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
- zero
- more than zero but less than that of an equivalent 3nf decomposition
- proportional to the size of f+
- indeterminate
Q13 | Which forms has a relation that possesses data about an individual entity?
- 2nf
- 3nf
- 4nf
- 5nf
Q14 | If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
- a many-to-many relationship set
- a multivalued attribute of an entity set
- a one-to-many relationship set
- both a many-to-many relationship set and a multivalued attribute of an entity set
Q15 | Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
- a many-to-many relationship set
- a multivalued attribute of an entity set
- a one-to-many relationship set
- none of the mentioned
Q16 | Fifth Normal form is concerned with
- functional dependency
- multivalued dependency
- join dependency
- domain-key
Q17 | In 2NF
- no functional dependencies (fds) exist
- no multivalued dependencies (mvds) exist
- no partial fds exist
- no partial mvds exist
Q18 | can help us detect poor E- R design.
- database design process
- e-r design process
- relational scheme
- functional dependencies
Q19 | Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
- a many-to-many relationship set
- a multivalued attribute of an entity set
- a one-to-many relationship set
- all of the mentioned
Q20 | In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
- a many-to-many relationship set
- a multivalued attribute of an entity set
- a one-to-many relationship set
- all of the mentioned
Q21 | Designers use which of the following to tune the performance of systems to support time-critical operations?
- denormalization
- redundant optimization
- optimization
- realization
Q22 | Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
- fourth nf
- bcnf
- third nf
- second nf
Q23 | A table on the many side of a one to many or many to many relationship must:
- be in second normal form (2nf)
- be in third normal form (3nf)
- have a single attribute key
- have a composite key
Q24 | Which of the normal form is based on multivalued dependencies?
- first
- second
- third
- fourth
Q25 | What is the best way to represent the attributes in a large database?
- relational-and
- concatenation
- dot representation
- all of the mentioned