A. Executes the first SOL statement in the workload file 100 times.

B. Executes an index analysis for the first SQL statement in the workload file 100 times.

C. Executes up to 100 combinations of optimizations for both SQL statements in the workload file

D. Executes both SQL statements in the workload file 100 times.

A. Windows

B. AIX

C. Linux

D. Solaris

A. CREATE DATABASEproddb REVOKE ALL FROM PUBLIC

B. CREATE DATABASEproddb GRANT PUBLIC NO

C. CREATE DATABASEproddb SECURE

D. CREATE DATABASEproddb RESTRICTIVE

A. CREATE TABLE customer
(custid INTEGER NOT NULL PRIMARY KEY,
custinfo XML)

B. CREATE TABLE customer
(custid INTEGER,
custinfo XML(1 M) NOT NULL PRIMARY KEY)

C. CREATE TABLE customer
(custid INTEGER,
custinfo XML NOT NULL PRIMARY KEY)

D. CREATE TABLE customer (custid INTEGER NOT NULL PRIMARY KEY, custinfo XML( 10000))

A. Synchronize, copy, or merge database schema definitions between DB2 Data Servers.

B. Integrate remote DB2 Command execution, such as utilities, application binding and rebinding, and data loading and unloading

C. Schedule changes for DPF objects or configurations.

D. Schedule delta online backups andreorgs for different days of the week.

A. A set of dynamic SQL statements that are stored in a file named db2advise.in that is to be executed against a database named SAMPLE

B. A set of dynamic SQL statements that have been captured by the snapshot monitor for a database named SAMPLE.

C. A set of dynamic SQL statements that have been stored in the SYSCAT.WORKLOADS catalog view of a database named SAMPLE.

D. A set of dynamic SQL statements that have been captured by the Query Patroller for a database named SAMPLE.

A. Kerberos authentication

B. Group retrieval

C. Encryption authentication

D. Server authentication