MIS 336 Final Exam Review Ch. 6-7
Which SQL keyword is used to change the structure, properties or constraints of a table?
ALTER
Which SQL keyword is used to impose restrictions on a table, data or relationship?
CONSTRAINT
Which SQL keyword is used to delete a table's structure?
DROP
Which SQL keyword is used to add one or more rows of data to a table?
INSERT
A casual relationship is when there is a foreign key column, but no foreign key constraint.
True
A database design is DBMS-specific and intended to implemented in a DBMS product.
True
A surrogate key is appropriate when the primary key of a table contains a lengthy text field.
True
A trigger is a stored program that is executed whenever a specified event occurs.
True
An example of an intrarelation constraint is that the date of birth must occur before the date of death.
True
Archetype/Instance patterns may not be id-dependent, but still weak.
True
Domain constraints limit column values to a particular set of values.
True
If an artist can only have one work at the gallery (1:1 relationship), the following needs to be added: CONSTRAINT UniqueWork UNIQUE (ArtistID).
True
In a 1:1 relationship between strong entities, you can place the primary key of the first table in the second as a foreign key, or you can place the primary key of the second table in the first table as a foreign key.
True
In a N:M relationship between two strong entities, the solution is to create a third table called an intersection table.
True
The CREATE TABLE statement is used to name a new table and describe the table's columns.
True
The first step in the database design process is to create tables and columns from entities and attributes.
True
The ideal primary key is short, numeric, and fixed.
True
Triggers are modules of code that are invoked if a certain event occurs.
True
Many-to-many relationships are represented by ________.
an intersection table which has 1:N relationships with the two tables
In many-to-many relationships in a relational database design, ________.
the keys of both tables are placed in a third table
When representing a one-to-many relationship in a relational database design, ________.
the parent is always on the one side of the one-to-many relationship
When transforming an E-R data model into a relational database design, the key of the parent entity should be placed as part of the primary key into the child entity ________.
when the child entity is ID-dependent
A null value is an attribute value that has been set to zero.
False
An association entity is nothing like the N:M relationship.
False
Data constraints are specified by using the DEFAULT keyword.
False
Default values are specified by using the CHECK keyword.
False
Intrarelation constraints limit a column's value in comparison to other column's values in other tables.
False
Multivalued entities are never id-dependent.
False
SQL MAKE TABLE statement is used to construct tables, define columns and column constraints, and create relationships.
False
TRUNCATE TABLE deletes the data and the table structure.
False
The expression ON DELETE NO ACTION indicates that deletions of rows that have children is allowed.
False
The keyword VALUES is used in bulk insert
False
The only default value available in SQL server is NULL.
False
When creating a table in the relational database design from an entity in the extended E-R model, the attributes of the entity become the rows of the table.
False
A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.
cascading updates
