OMIS 452 Final Exam 2 with Complete Solutions
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
T/F: The use of a double nested set of NOT EXISTS SELECT statements is a famous
pattern in SQL use
Choose an answer
1 True 2 False
Don't know?
Terms in this set (104)
,In a relational database design, Creating a foreign key
all relationships are expressed
by ________.
The identifier of the entity Primary Key
becomes the ________ of the
corresponding table
Which of the following is not They are non-unique within a table
true about surrogate keys?
Which of the following is not a Create constraints and triggers
step in the database design
process?
Each attribute of an entity Column
becomes a(n) ________ of a table.
The first step in transforming an Create a table for each entity
extended E-R model into a
relational database design is to
________
A surrogate key should be The key contains a lengthy text field
considered when ________.
The ideal primary key is ________. All of the above
When representing a 1:1 The key of either table may be placed as a foreign key into the
relationship in a relational other
database design ________.
, To which of the following Create
actions are referential integrity
constraints not applied?
The Entity-Relationship (E-R) Tables, Attributes, Identifiers, and Relationships
Model may contain which of the
following items:
T/F: When the key of one table is False
placed into a second table to
represent a relationship, the key
is called a "relational key" in the
second table
T/F: A foreign key is a key that False
does not belong in any table.
T/F: When creating a table in the False
relational database design from
an entity in the extended E-R
model, the attributes of the
entity become the rows of the
table.
T/F: Data types are consistent False
across all DBMS products.
T/F: An intersection table can False
have additional attributes
besides the keys of its parent
tables.
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
T/F: The use of a double nested set of NOT EXISTS SELECT statements is a famous
pattern in SQL use
Choose an answer
1 True 2 False
Don't know?
Terms in this set (104)
,In a relational database design, Creating a foreign key
all relationships are expressed
by ________.
The identifier of the entity Primary Key
becomes the ________ of the
corresponding table
Which of the following is not They are non-unique within a table
true about surrogate keys?
Which of the following is not a Create constraints and triggers
step in the database design
process?
Each attribute of an entity Column
becomes a(n) ________ of a table.
The first step in transforming an Create a table for each entity
extended E-R model into a
relational database design is to
________
A surrogate key should be The key contains a lengthy text field
considered when ________.
The ideal primary key is ________. All of the above
When representing a 1:1 The key of either table may be placed as a foreign key into the
relationship in a relational other
database design ________.
, To which of the following Create
actions are referential integrity
constraints not applied?
The Entity-Relationship (E-R) Tables, Attributes, Identifiers, and Relationships
Model may contain which of the
following items:
T/F: When the key of one table is False
placed into a second table to
represent a relationship, the key
is called a "relational key" in the
second table
T/F: A foreign key is a key that False
does not belong in any table.
T/F: When creating a table in the False
relational database design from
an entity in the extended E-R
model, the attributes of the
entity become the rows of the
table.
T/F: Data types are consistent False
across all DBMS products.
T/F: An intersection table can False
have additional attributes
besides the keys of its parent
tables.
