MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
The Relational Model And Normalization
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
A functional dependency is a relationship between or among:
tables.
rows.
relations.
attributes.
Q.2
A primary key is a composite key that was selected to be the main identifier for the relation.
True
False
Q.3
A primary key is a composite key that was selected to be the main identifier for the relation.
True
False
Q.4
A primary key is a composite key that was selected to be the main identifier for the relation.
True
False
Q.5
A primary key is a composite key that was selected to be the main identifier for the relation.
True
False
Q.6
Relations are categorized into normal forms according to the referential integrity constraints that they have.
True
False
Q.7
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
True
False
Q.8
A functional dependency is always an equation.
True
False
Q.9
A relation has cells that hold multi-value entries.
True
False
Q.10
In a relation, the rows are sometimes called "fields".
True
False
Q.11
A candidate key is a determinant that determines all the other columns is a relation.
True
False
Q.12
The only reason for the existence of relations is to store instances of functional dependencies.
True
False
Q.13
A relation is in 5NF when multivalued dependencies are isolated in their own relation.
True
False
Q.14
In a relation, the order of the columns does not matter.
True
False
Q.15
A functional dependency is a relationship between or among attributes.
True
False
Q.16
A key is a group of one or more attributes that uniquely identifies a row.
True
False
Q.17
The functional dependency
R → S
means that the value of S can be determined when we are given a value of R.
True
False
Q.18
In a relation, the columns are sometimes called "attributes".
True
False
Q.19
Keys made up of two or more attributes are called composite keys.
True
False
Q.20
Given the functional dependency
R → S
,
R
is called the determinant.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page