User USER1 wants to store part numbers and part descriptions in a table named PARTS; user
USER1 also wants to ensure that any comparisons of part descriptions that are made will be done
so in binary, regardless of the database collating sequence used. Which statement should user
USER1 execute to create the desired table?

What mechanism is typically used to automatically update other tables, generate or transform
values for inserted or updated rows, and perform tasks such as issuing alerts?

Which data type should be used to store data in a column that represents money and accurately
returns a two position scale?

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2
in such a way that whenever a record is deleted from table TAB1, any related records are deleted
from table TAB2. What must user USER1 do to accomplish this?

Which statement about a deadlock is true?

What takes place when a process accesses a data object on which it already holds a lock, and the
access mode requires a more restrictive lock than the one currently held?

What is the act of releasing a large number of row-level locks that an application holds on a single
table to acquire a table-level lock known as?

The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the
following?

What factor influences lock conversion/promotion?

Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation
level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1
immediately, rather than have to wait until application APP_A has finished making updates?