A2090-544 Online Practice Questions and Answers

Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

A. GET CURRENT ACTIVE LOGFILE

B. LIST LOGFILES

C. GET DATABASE CONFIGURATION

D. LIST INDOUBT TRANSACTIONS

What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?

A. Issue a RESTORE DATABASE command with the REDIRECT option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

B. Issue a RESTORE DATABASE command with the REDIRECT option;issue a RESTORE DATABASE command with the CONTINUE option;

C. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a RESTORE DATABASE command with the CONTINUE option;

D. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?

A. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Check constraint integrity for the partitioned table

B. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Rebind the partitioned table

C. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Update statistics on the partitioned table

D. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Reorg the partitioned table

How can a DBA validate that an existing backup was compressed?

A. Check the output from the command LIST HISTORY BACKUP ALL FOR the database.

B. Check the value of the COMPRESS_BACKUP database configuration setting.

C. Check the value of the DB2_COMPRESS_BACKUP registry variable.

D. Check the header information of the backup file using db2ckbkp.

Which command CANNOT be used to create the compression dictionary for a table?

A. IMPORT

B. INSPECT

C. LOAD

D. RUNSTATS

When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

A. It terminates immediately.

B. It remains active as long as the MAXAGENTS setting is not exceeded.

C. It is placed in the agent pool if the connection is terminated.

D. It automatically releases the database connection and returns to the pool.

A user with Security Administrator (SECADM) authority executes the following statements:

If user USER2 queries the table S.TAB1, how many rows will be returned?

A. 0

B. 1

C. 2

D. 3

At which two levels can events be audited? (Choose two.)

A. Instance level

B. Database level

C. Server level

D. Operating System level

E. Node level

The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

A. CREATE TABLE tab1(yearday INT,year CHAR(2),day INT))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year, day))

B. CREATE TABLE tab1(yearday INT,year CHAR(2),day INT))PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year, day))

C. CREATE TABLE tab1(yearday INT,year CHAR(2),day INT))PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year))

D. CREATE TABLE tab1(yearday INT,year CHAR(2),day INT))PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (day))

Which series of items are required to establish a TCP/IP connection to a DB2 for z/OS database from a DB2 for Linux, UNIX, or Windows server?

A. hostname, logical unit (LU) name, target database name, local database name, node name

B. hostname, logical unit (LU) name, subsystem ID, local database name, node name

C. hostname, port number/protocol, subsystem ID, local database name, node name

D. hostname, port number/protocol, target database name, local database name, node name