IBM IBM Certified Advanced Database Administrator A2090-544 Questions & Answers

• Question 61:

  The table STORESALES was created with the following statement:

  

  Which is true when the following statement is executed? CREATE UNIQUE INDEX index_partIDcustID ON storesales (partID, custID)

  A. A unique partitioned index is created successfully.

  B. A unique non-partitioned index is created successfully.

  C. The index creation fails because it does not contain the column from the table partitioning key.

  D. A non-unique partitioned index is created successfully.

  Correct Answer: B

• Question 62:

  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

  Correct Answer: D

• Question 63:

  A database and a table space were created using the following commands:

  

  Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?

  A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

  B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

  C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?

  D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

  Correct Answer: B

• Question 64:

  Given a database created as follows:

  

  If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/ foreign key relationship between column C1 in table T1, and column C1 in table T2?

  A. CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

  B. CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;

  C. CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

  D. CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k;

  Correct Answer: B

• Question 65:

  What is a method for enabling non-buffered I/O at the table space level in a DB2 database?

  A. Set the DB2_DIRECT_IO configuration parameter to YES.

  B. Set the DB2_FILESYSTEM_CACHE 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.

  Correct Answer: D

• Question 66:

  Which action can be performed by the ALTER TABLESPACE statement?

  A. Change an SMS table space to a DMS table space on any database partition.

  B. Change the size of a container in an SMS table space.

  C. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.

  D. Add a container to an SMS table space on a database partition that currently has no containers.

  Correct Answer: D

• Question 67:

  What is the minimum authority required to execute the LOAD command?

  A. DATAACCESS

  B. SQLADM

  C. ACCESSCTRL

  D. SYSCTRL

  Correct Answer: A

• Question 68:

  You have a database with eight partitions on a single server. Immediately after executing the following

  command:

  CREATE BUFFERPOOL mybp DEFERRED SIZE 3000

  How much memory is consumed by buffer pool MYBP on the server?

  A. 0 pages

  B. 3000 pages

  C. 24000 pages

  D. 192000 pages

  Correct Answer: A

• Question 69:

  If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?

  A. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.

  B. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.

  C. Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.

  D. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.

  Correct Answer: A

• Question 70:

  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

  Correct Answer: AB