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),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Practice Mode Previous Next
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
Answer: autonumber
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
Answer: together they constitute a composite key for the table
Q3 | In the                      normal form, a composite attribute is converted to individual attributes.
  • first
  • second
  • third
  • fourth
Answer: first
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
Answer: eliminate all hidden dependencies
Q5 | Functional Dependencies are the types of constraints that are based on             
  • key
  • key revisited
  • superset key
  • none of the mentioned
Answer: key
Q6 | Which is a bottom-up approach to database design that design by examining the relationship between attributes:
  • functional dependency
  • database modeling
  • normalization
  • decomposition
Answer: normalization
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
Answer: 3nf
Q8 | What are the desirable properties of a decomposition
  • partition constraint
  • dependency preservation
  • redundancy
  • security
Answer: dependency preservation
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
Answer: 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
Answer: 3nf synthesis algorithm
Q11 | Which normal form is considered adequate for normal relational database design?
  • 2nf
  • 5nf
  • 4nf
  • 3nf
Answer: 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
Answer: more than zero but less than that of an equivalent 3nf decomposition
Q13 | Which forms has a relation that possesses data about an individual entity?
  • 2nf
  • 3nf
  • 4nf
  • 5nf
Answer: 4nf
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
Answer: 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
Answer: a many-to-many relationship set
Q16 | Fifth Normal form is concerned with
  • functional dependency
  • multivalued dependency
  • join dependency
  • domain-key
Answer: join dependency
Q17 | In 2NF
  • no functional dependencies (fds) exist
  • no multivalued dependencies (mvds) exist
  • no partial fds exist
  • no partial mvds exist
Answer: no partial fds exist
Q18 |                            can help us detect poor E- R design.
  • database design process
  • e-r design process
  • relational scheme
  • functional dependencies
Answer: 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
Answer: a many-to-many relationship set
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
Answer: a multivalued attribute of an entity set
Q21 | Designers use which of the following to tune the performance of systems to support time-critical operations?
  • denormalization
  • redundant optimization
  • optimization
  • realization
Answer: denormalization
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
Answer: bcnf
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
Answer: have a composite key
Q24 | Which of the normal form is based on multivalued dependencies?
  • first
  • second
  • third
  • fourth
Answer: fourth
Q25 | What is the best way to represent the attributes in a large database?
  • relational-and
  • concatenation
  • dot representation
  • all of the mentioned
Answer: concatenation
Previous Next