최신IBM Assessment: DB2 9.7 Advanced DBA for LUW - A2090-544무료샘플문제

A. Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.

B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.

C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing SMS table spaces.

D. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.

A. The value of the INTER_PARALLEL Database Manager configuration parameter.

B. The number of database partitions and the definition of partition groups.

C. The value of the DFT_DEGREE database configuration parameter.

D. The number of database connections and the definition of partitions groups.

A. Attempt to create the buffer pool and immediately allocate the memory requested from available database shared memory. If the memory available is not sufficient, then allocation of the buffer pool will be deferred until the database is stopped and restarted.

B. Attempt to create the buffer pool and immediately allocate the memory requested, resizing the existing buffer pools and heaps as required. If there is insufficient memory in the global memory allocation for DB2, the buffer pool will not be created.

C. Attempt to create the buffer pool and immediately request additional memory from the operating system to allocate. If the operating system memory is not available, the buffer pool will not be created.

D. Attempt to create the buffer pool and immediately request additional instance level memory. If the instance level memory is not available, then creation of the buffer pool is deferred until the database is stopped and restarted.

A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS

B. BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS

C. BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS

D. BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS

A. 3 Oracle servers , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database

B. 3 Oracle servers , 1 DB2 server , 3 Oracle wrappers , 1 DB2 wrapper , and nicknames for each database

C. 1 Oracle server , 1 DB2 server , 3 Oracle wrappers , and nicknames for each database

D. 1 Oracle server , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database

A. Perform the equivalent of RUNSTATS on ORA1 in Oracle.

B. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then perform RUNSTATS on the ORA1 nickname.

C. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.

D. Perform RUNSTATS on the ORA1 nickname at the federated server.

A. Export data from the main partitioned table; create a table with the same definition as the partitioned table; attach to the main partitioned table; import data into the main partitioned table; run the SET INTEGRITY statement.

B. Export data from the main partitioned table; drop the main partitioned table; create the main partitioned table with new partitioning range; import data into the main partitioned table.

C. Create a table with the same definition as the partitioned table; load the new table with data; attach the new table to the main partitioned table; run the SET INTEGRITY statement.

D. Create a table with the same definition as the partitioned table; attach to the main partitioned table; data will be automatically redistributed across all table partitions.

A. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.

B. Set the DB2_DIRECT_IO configuration parameter to YES.

C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

A. DTQ

B. LTQ

C. BTQ

D. IP