Which object may be used during query optimization to improve the performance for a subset of SELECT queries?()
时间:2022-09-07
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?()
时间:2022-09-06
Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?()
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()
时间:2022-09-05
Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?()
Which of the following is a characteristic of a schema?()
Which of the following best describes how locks are used in DB2?()
时间:2022-09-03
A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()
时间:2022-09-02
Which of the following is a feature of a unit of work?()
Which of the following is a characteristic of a sequence?()
时间:2022-09-01
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?()
时间:2022-08-31
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?()
An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?()
时间:2022-08-28
Which of the following strings can be inserted into an XML column using XMLPARSE?()
时间:2022-08-27