WorksheetsDatabase Management System CT-4
Total questions: 20
Worksheet time: 40mins
A ___ is normalized after it has been organized.
Table
Database
Row
Column
In addition to removing undesirable characteristics, normalization also eliminates ___ anomalies.
Insert
Update
Delete
All of the above
Two attributes can be functionally ___ on/of each other.
Dependent
Independent
Both A and B
None of the above
Which of the following is not Armstrong’s Axiom?
Pseudotransitivity rule
Reflexivity rule
Transitivity rule
Augmentation rule
Redundancy is reduced in a database table by using the ___ form.
Abnormal
Normal
Special
None
In practical applications, how many types of Normal Forms are there?
3
4
5
6
Which of the following is not a type of Normal Form?
1NF
10NF
2NF
3NF
An attribute that is ___ and the primary key of a table are typically functionally dependent on one another.
Non-Key
Key
One-Key
Many-Key
Functional dependencies are classified as ___ on the left.
Dependent
Determined
Determinants
Database
If a functional dependency is reflexive, B is a subset of A and A is the set of attributes, then
B→A holds
AB→C holds
A→B holds
None of the mentioned
2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.
Foreign
Primary
Composite
Alternate
Which of the following are active database elements?
Functions
Constraints
Triggers
Views
Consider a relation R(A, B, C, D, E) with FD set S = {A → BC, CD → E, B → D, E → A}. If R is decomposed into two relations, which of the following is a lossless join decomposition?
(ABC), (CDE)
(ABC), (ADE)
(ABD), (BCE)
None of the above
If a relation has a 4NF and no join dependency, and when it joins, it should be___, it is considered 5NF.
Lossful
Lesser
Lossless
Full
What is TRUE about the First Normal Form (1NF)?
If a relation contains an atomic value, it will be 1NF.
A table attribute cannot contain more than one value, according to this rule.
A single-valued attribute can only be stored in it.
All of the above
Non-prime attributes cannot be transitively dependent, so the relation must have the ___ normal form.
First
Second
Third
Fourth
The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary)
This type of decomposition is called
Lossless decomposition
Lossless-join decomposition
All of the mentioned
None of the mentioned
How many types of functional dependencies are there?
1
2
3
4
Assume that we have a relation R(A, B, C, D, E) with a multi-valued dependency A →→ BC (A multi-determines BC). Which of the following statements are correct?
For a given A, the values of BC and DE are independent of each other
The values of BC can determine that of DE
For a given A, the values of BC and DE are dependent of each other.
The values of DE can determine that of BC
If more than one value of B is present for a single value of A in a dependency A -> B, then the relationship is ___.
Single
Multi-valued
Both a and b
None of the above
