Ics 321 - Quiz 5

Front 1

SQL Server supports AFTER and INSTEAD OF triggers, but not BEFORE triggers. (T/F)

Back 1

True

Front 2

In SQL Server, insert and update triggers store old values in a pseudotable named deleted. (T/F)

Back 2

False

Front 3

Each entity in the extended E-R model is represented as a table in the relational database design. (T/F)

Back 3

True

Front 4

A surrogate key is appropriate when the primary key of a table contains a lengthy text field. (T/F)

Back 4

True

Front 5

A null value is an attribute value that has been set to zero. (T/F)

Back 5

False

Front 6

When placing a foreign key for a 1:1 relationship, the key of either table can be used as the foreign key in the other table. (T/F)

Back 6

True

Front 7

Like all ID-dependent relationships, the parents of an association table are required. (T/F)

Back 7

True

Front 8

All identifying relationships are 1:N. (T/F)

Back 8

True

Front 9

When the parent entity has a surrogate key, the enforcement actions are the same for both parent and child. (T/F)

Back 9

False

Front 10

SQL Server AFTER triggers may be assigned to either tables or views. (T/F)

Back 10

False

Front 11

Inline user defined function can use input parameters. (T/F)

Back 11

True

Front 12

A view may not be assigned to a(n) ____.
a) BEFORE trigger
b) INSTEAD OF trigger
c) CONCURRENT trigger
d) AFTER trigger
e) any of the above

Back 12

d) AFTER trigger

Front 13

Which of the following is not true about representing subtypes in a relational database design?
a) one table is created for the supertype and one for each subtype
b) all of the attributes of the supertype are added to the subtype relations
c) the key of the supertype is made the key of the subtypes
d) a subtype and its supertype are representations of the same underlying table
e) and instance of the supertype may be related to one instance each of several subtypes

Back 13

b) all of the attributes of the supertype are added to the subtype relations

Front 14

A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary
a) incremental updates
b) incremental deletes
c) controlled key adjustments
d) cascading updates
e) cascading deletes

Back 14

e) cascading deletes

Front 15

Which of the following is not a step in the database design process?
a) create tables and columns from entities and attributes
b) select primary keys
c) represent relationships
d) create constraints and triggers
e) all of the above are steps in the database design process

Back 15

d) create constraints and triggers

Front 16

The identifier of the entity becomes the ____ of the corresponding table.
a) primary key
b) foreign key
c) supertype
d) subtype
e) either a or b

Back 16

a) primary key

Front 17

One of the important properties of an attribute is whether or not it is _____.
a) found in more than one entity
b) required
c) character or numeric
d) subject to normalization
e) subject to de-normalization

Back 17

b) required

Front 18

In many-to-many relationships in a relational database design _______.
a) the key of the child is placed as a foreign key into the parent
b) the key of the parent is placed as a foreign key into the child
c) the keys of both tables are placed in a third table
d) the keys of both tables are joined into a composite key
e) c and d

Back 18

e) c and d

Front 19

When transforming an ID-dependent E-R data model relationship into a relational database design, and the child entity is designed to use a surrogate key, then _____.
a) the parent entity must also use a surrogate key
b) the relationship remains an ID-dependent relationship
c) the relationship changes to a non-ID-dependent relationship
d) a and b
e) a and c

Back 19

c) the relationship changes to a non-ID-dependent relationship

Front 20

RAISEERROR sends a message, optionally logging it in the error log, but it does not affect batch execution unless ____, in which case the connection is closed.
a) the state of the message is set to 19
b) the severity is 20 or more
c) the disconnect option is turned on
d) the error message has no log and a message_id of 5000
e) a and c

Back 20

b) the severity is 20 or more

Front 21

For triggers on insert and update actions, the new column values are stored in ____.
a) a table named new:TableName
b) a table named old: TableName
c) a pseudotable name inserted
d) a pseudotable name deleted
e) none of the above

Back 21

c) a pseudotable name inserted

Front 22

You must ____ if you want a function to use an input parameter's default value.
a) leave the parameter area blank
b) specify the DEFAULT keyword
c) specify the NULL keyword
d) enter '%%%%'
e) you cannot have default values with inline user defined functions

Back 22

b) specify the DEFAULT keyword

Front 23

SQL server does not support ____ triggers as Oracle does.

Back 23

BEFORE

Front 24

For update and delete triggers, old data values are stored in a pseudotable named ______.

Back 24

deleted

Front 25

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 is called ____.

Back 25

cascading updates

Front 26

In 1:N relationships, the table on the "one" side is called the ______.

Back 26

parent

Front 27

In representing a M:N relationship in a relational database design, a(n) ___ table is created.

Back 27

intersection

Front 28

To represent a M:N relationship in a relational database design, in essence it is reduced to two ____ relationships.

Back 28

1:N

Front 29

The ____ system variable provides the error status of the most recently executed statement.

Back 29

@@ERROR

Front 30

For insert and update triggers, new data values are stored in a pseudotable named ______.

Back 30

inserted

Front 31

User-defined functions that return a table data type are referred to as _____.

Back 31

table-valued functions