Database Management System Set 36

Learning Mode Previous Next

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

Previous Next