IBM(000-730)单项选择题每日一练(2019.03.21)

单项选择题
Which kind of non-sourced UDF can be created so that it only returns a single value?（）
A.Row
B.Table
C.Scalar
D.Column
单项选择题
A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）
A.Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B.From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C.At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D.Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.
单项选择题
Which of the following is true of an index used to support a UNIQUE constraint?（）
A.It must have the UNIQUE attribute.
B.It cannot be created explicitly by the user.
C.It must have the UNIQUE and CLUSTER attributes.
D.It must have the UNIQUE WHERE NOT NULL attribute.
单项选择题
If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）
A.Rollback the transaction in both applications.
B.Rollback the transaction in one of the two applications.
C.Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
D.Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
单项选择题
Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）
A.Journal
B.Task Center
C.Control Center
D.Activity Monitor