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

试卷相关题目

• 1What 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.

  开始考试点击查看答案
• 2What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEXstatement、

  A.To override the limit on index key columns.

  B.To further enforce the uniqueness of index values.

  C.To combine two or more indexes to create a single unique index.

  D.To improve performance of some queries by allowing index-only access.

  开始考试点击查看答案
• 3Which event will NOT cause a trigger to be fired、

  A.Execution of an INSERT statement.

  B.Execution of LOAD REPLACE operation.

  C.Execution of an INSERT operation of a MERGE statement.

  D.Execution of an UPDATE operation of a MERGE statement.

  开始考试点击查看答案
• 4Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced、

  A.Check

  B.Unique

  C.Referential

  D.Informational

  开始考试点击查看答案
• 5The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of thefollowing、

  A.Define a view on one or more tables or views.

  B.Revalidate all invalid objects that are referenced on a view's fullselect.

  C.Ensure that any inserted or updated rows conform to the definition of the view.

  D.Define a view that only consists of columns that have check constraints defined.

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

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

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

  开始考试点击查看答案
• 9Which statement about a deadlock is true、

  A.The victim will be rolled back.

  B.The victim will read through the lock.

  C.Both victim and holder are rolled back.

  D.The victim must wait until the holder releases the lock.

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

  开始考试点击查看答案