MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Logical Database Design
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 candidate key must uniquely identify each row.
True
False
Q.2
Well-structured relations encourage anomalies of data.
True
False
Q.3
A foreign key may be null and still adhere to the referential integrity constraint.
True
False
Q.4
If a relation is in third normal form, it does not need to be in second normal form.
True
False
Q.5
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
True
False
Q.6
A null value is assigned when no other value applies.
True
False
Q.7
A synonym is two or more attributes that have different names but the same meaning.
True
False
Q.8
The primary key in a relation does not need to be underlined.
True
False
Q.9
In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
True
False
Q.10
An enterprise key is a primary key whose value is unique for a given relation.
True
False
Q.11
Normalization is a formal process for deciding which attributes should be grouped together in a relation.
True
False
Q.12
A composite attribute does not get mapped into a relation.
True
False
Q.13
A relation is a two-dimensional table.
True
False
Q.14
Weak entities do not get mapped into a relation.
True
False
Q.15
A relation has which of the following properties?
Each row is not unique.
Attributes can have the same name within a given table.
Each relation has a unique name.
The order of the columns is significant.
Q.16
When mapping a ternary relationship with an associative entity into a relation which of the following is true?
One relation is created.
Two relations are created.
Three relations are created.
Four relations are created.
Q.17
A primary key may be null.
True
False
Q.18
When mapping a regular entity into a relation which of the following is true?
One relation is created.
Two relations are created.
Three relations are created.
Four relations are created.
Q.19
When mapping a supertype/subtype relationship which of the following is true?
The supertype primary key is assigned to each subtype.
The subtype primary key is assigned to each supertype.
There is no link between the supertype/subtype entities.
There is no primary key/foreign key relationship between a supertype/subtype.
Q.20
When mapping a multivalued attribute into a relation which of the following is true?
One relation is created.
Two relations are created.
Three relations are created.
Four relations are created.
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