MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Data Models Into Database Designs
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
True
False
Q.2
Surrogate keys have much meaning for users.
True
False
Q.3
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
True
False
Q.4
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
True
False
Q.5
When the parent entity is required, a new parent row can always be inserted.
True
False
Q.6
For every relationship, there are six possible referential integrity actions.
True
False
Q.7
An ideal primary key is short, numeric and seldom changing.
True
False
Q.8
The DBMS allows surrogate keys to be changed.
True
False
Q.9
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
True
False
Q.10
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
True
False
Q.11
When the parent entity is required, a new child row can always be inserted.
True
False
Q.12
All primary keys are required.
True
False
Q.13
Intersection tables are ID-dependent on both their parent tables.
True
False
Q.14
For every relationship, there are six possible sets of minimum cardinalities.
True
False
Q.15
An intersection table is required to represent M:N relationships.
True
False
Q.16
A foreign key is used to implement relationships between tables.
True
False
Q.17
The terms alternate key and candidate key mean the same thing.
True
False
Q.18
In 1:N relationships, which entity becomes the parent entity is arbitrary.
True
False
Q.19
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
True
False
Q.20
In a 1:1 relationship, the primary key placement is arbitrary.
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