On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 36

Q1 | If attributes A and B determine attribute C, then it is also true that:
  • A → C.
  • B → C
  • (A, B) is a composite determinant.
  • C is a determinant
Q2 | If attribute A determines both attributes B and C, then it is also true that:
  • A → B
  • B → A
  • C → A
  • (B,C) → A
Q3 | One solution to the multivalued dependency constraint problem is to:
  • split the relation into two relations, each with a single theme
  • Change the theme.
  • Create a new theme.
  • add a composite key
Q4 | FD stands for:
  • Functional dependency
  • Facilitate dependency
  • Functional data
  • Facilitate data
Q5 | In which model of database data is stored in tables:
  • Network model
  • Relational model
  • Hierarchical model
  • None of these
Q6 | How many types of keys in relation database design:
  • Primary key
  • Candidate key
  • Foreign key
  • All of these
Q7 | Which key is referencing a primary key in a table:
  • Primary key
  • Candidate key
  • Foreign key
  • All of these
Q8 | In which ways two tables may be related:
  • One-one
  • One-many
  • Many-many
  • All of these
Q9 | Which rules are defined in relational models they from as an essential part of any relationdatabase:
  • Integrity rules
  • Database
  • Record
  • Memory
Q10 | Which are the types of integrity rule:
  • Entity integrity
  • Referential integrity
  • Both
  • None
Q11 | ______states that primary keys should not be null:
  • Entity integrity
  • Referential integrity
  • Both
  • None
Q12 | Which command creates database objects like tables, views and indexes:
  • Create command
  • Update command
  • Both
  • None
Q13 | Which command enables alteration the data stored in existing records:
  • Create command
  • Update command
  • Deletion command
  • All of these
Q14 | Which are the dependencies types:
  • Full functional dependency
  • Partial dependency
  • Trivial functional dependency
  • All of these
Q15 | FDs are the types of constraints that are based on______:
  • Key
  • Key revisited
  • Superset key
  • None of these
Q16 | Who developed the normalization process:
  • E.F. codd
  • F.F. codd
  • E.E. codd
  • None of these
Q17 | Which is a bottom-up approach to database design that design by examining therelationship between attributes:
  • Functional dependency
  • Database modeling
  • Normalization
  • Decomposition
Q18 | In decomposition technique of splitting a relation into_____ relation:
  • ONE or MORE
  • TWO or MORE
  • THREE or MORE
  • FOUR or MORE
Q19 | Consequently R.Boyce-Codd jointly launched powerful definition for the third normalform called______:
  • Boyce-Codd normal form
  • First normal form
  • Second normal form
  • All of these
Q20 | BCNF stands for:
  • Basic -Codd normal form
  • Build -Codd normal form
  • Boyce-Codd normal form
  • None of these
Q21 | Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
  • 1NF
  • 2NF
  • 3NF
  • All of these
Q22 | Which forms every non-prime attribute is fully dependent functionally on the candidatekey of a relational schema:
  • 1NF
  • 2NF
  • 3NF
  • 5NF
Q23 | PJNF stands form:
  • Practically –join normal form
  • Project –join normal form
  • Pages –join normal form
  • programming –join normal form
Q24 | Which forms are based on the concept of functional dependency
  • 1NF
  • 2NF
  • 3NF
  • 4NF
Q25 | The DBMS utility, ____________ allows to reconstruct the correct state of database fromthe backup and history of transactions.
  • Backup
  • Recovery
  • Monitoring
  • Data loading