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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started