Which statement about a deadlock is true、

试卷相关题目

• 1User 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、

  A.1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.

  B.1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE CASCADE rule.

  C.1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE RESTRICT rule.

  D.1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE RESTRICT rul

  开始考试点击查看答案
• 2Which data type should be used to store data in a column that represents money and accurately returns a two position scale、

  A.BIGINT

  B.BINARY

  C.DOUBLE

  D.DECIMAL

  开始考试点击查看答案
• 3What 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、

  A.Trigger

  B.Procedure

  C.Table function

  D.Scalar function

  开始考试点击查看答案
• 4User USER1 wants to store part numbers and part descriptions in a table named PARTS; userUSER1 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、

  A.CREATE TABLE parts (part_no INTEGER, desc CLOB))

  B.CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200))

  C.CREATE TABLE parts (part_no INTEGER, desc CLOB FOR BIT DATA))

  D.CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200) FOR BIT DATA)

  开始考试点击查看答案
• 5What are INSTEAD OF triggers used for、

  A.To update data in other tables.

  B.To perform insert, update, and delete operations against complex views.

  C.To check or modify values before they are actually stored in a database.

  D.To run non-database operations that are coded in user-defined functions.

  开始考试点击查看答案
• 6What 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、

  A.Lock wait

  B.Lock timeout

  C.Lock escalation

  D.Lock conversion

  开始考试点击查看答案
• 7What 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、

  A.Lock exchange

  B.Lock promotion

  C.Lock escalation

  D.Lock conversion

  开始考试点击查看答案
• 8When is an INTENT EXCLUSIVE (IX) lock required、

  A.When a transaction intends to read or change data.

  B.When a transaction intends to change but not read data.

  C.When a transaction intends to read but not change data.

  D.When a transaction intends to change the system catalog.

  开始考试点击查看答案
• 9The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of thefollowing、

  A.Concurrent application processes from performing any operations on the table.

  B.Concurrent application processes from performing any read-only operations on the table.

  C.Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.

  D.Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe tabl

  开始考试点击查看答案
• 10What factor influences lock conversion/promotion、

  A.Lock size

  B.Number of locks

  C.Lock mode needed

  D.Available real storage

  开始考试点击查看答案