Database Management System Set 36
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 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