Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()
时间:2022-10-11
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?()
时间:2022-10-08
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?()
时间:2022-10-06
Which of the following will DELETE all of the rows from table T03?()
时间:2022-10-05
For which of the following is a data warehouse optimized?()
Which of the following privileges permits a user to update the comment on a sequence?()
时间:2022-10-04
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?()
时间:2022-10-02
Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?()
A trigger can be created on which of the following objects?()
Which of the following is true of an index used to support a UNIQUE constraint?()
Which of the following describes the model used by the Geodetic Extender?()
时间:2022-10-01
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?()
时间:2022-09-30
On which of the following database objects may the SELECT privilege be controlled?()
时间:2022-09-27
Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?()
时间:2022-09-25
Which of the following resources can be referenced in the LOCK statement?()