31. Which of the following are ANSI defined isolation levels? (Choose all that a

Question

31. Which of the following are ANSI defined isolation levels? (Choose all that apply) *This question is required.

a. SERIALIZABLE

b. REPEATABLE READ

c. CURSOR STABILITY

d. COMMITTED READ LAST COMMITTED

32. Which of the following catalog tables contain information on a CHECK constraint? (Choose all that apply) *This question is required.

a. SYSCHECKS

b. SYSDEFAULTS

c. SYSREFERENCES

d. SYSCONSTRAINTS

e. SYSCOLDEPEND

f. SYSCOLATTRIBS

33. What does the ORDERED directive do? *This question is required.

a. It causes the output of an SQL statement to be sorted in a particular order

b. It causes the Optimizer to join the tables in the order in which they are coded in the FROM clause

c. It causes the Optimizer to sort the records before filtering them

d. It causes the Optimizer to process any other directives in the order in which they were coded

34. The database named DB_101 uses unbuffered logging. The following SQL statement is successfully executed against the database:

SET CONSTRAINTS pk_const, fk_const DEFERRED;

When will referential violations involving the two constraints be detected? *This question is required.

a. Never

b. After each statement is executed

c. At COMMIT time

d. At the end of the session

Explanation / Answer

31.
a. SERIALIZABLE
b. REPEATABLE READ
32.
a. SYSCHECKS
c. SYSREFERENCES
d. SYSCONSTRAINTS
e. SYSCOLDEPEND
33.
b. It causes the Optimizer to join the tables in the order in which they are coded in the FROM clause
34.
c. At COMMIT time

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.