A2090-544 Online Practice Questions and Answers

While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client: CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000; CATALOG DATABASE samp001 AS samp001 AT NODE node001; TERMINATE; When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node. The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?

A. Add a Database Connection Services entry to the /etc/services file on the Windows client.

B. Change the service name (SVCENAME) in the remote servers database configuration.

C. Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/ services file on the remote server.

D. Add an entry into the Database Connection Services directory on the Windows client.

Which command CANNOT be used to explicitly build a compression dictionary for a table?

A. REORG

B. LOAD

C. INSPECT

D. IMPORT

What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

A. SECADM authority

B. EXECUTE privilege on audit routines with DATA

C. DBADM authority

D. EXECUTE privilege on audit routines with NO DATA

E. SYSADM authority

A DBA needs to create a federated database and configure access to join data from three Oracle instances and one DB2 database. Which objects are needed to establish the specified connections?

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

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

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

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

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.

Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do when a new buffer pool is created using the IMMEDIATE option?

A. 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.

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 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.

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.

Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?

A. CARDINALITY VOLATILE

B. INDEXSCAN

C. VOLATILE

D. CURRENT CARDINALITY

Given the following statement:

Which statement will successfully add a new partition to table T1 for April 2010?

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. 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.

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. 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.

Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node. Explanation: The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

A. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS

B. CATALOG DCS DATABASE dsample AS db2t

C. CATALOG DCS DATABASE db2t AS dsample

D. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS

A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?

A. Uncatalog and re-catalog the directory entries for the zOS database and try again.

B. Catalog the zOS database in the Local Database Directory.

C. Catalog the zOS database in the Database Connection Services Directory.

D. Catalog the zOS database in the Distributed Data Facility Directory.