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

• Question 11:

  Which data organization schemes are supported?

  A. PARTITION BY HASH and ORGANIZE BY

  B. PARTITION BY RANGE and ORGANIZE BY HASH

  C. PARTITION BY HASH and ORGANIZE BY RANGE

  D. PARTITION BY RANGE and ORGANIZE BY

  Correct Answer: D

• Question 12:

  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 the database?

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

• Question 13:

  A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification?

  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.

  Correct Answer: D

• Question 14:

  If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?

  A. ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'

  B. ALTER TABLESPACE tbsp1 ADD ('/db2/filesystem1')

  C. ALTER DATABASE ADD STORAGE FOR tbsp1 ('/db2/filesystem1')

  D. ALTER TABLESPACE tbsp1 EXTEND USING ('/db2/filesystem1')

  Correct Answer: A

• Question 15:

  Given the following table spaces, their associated page size, and number of pages:

  

  Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for optimal data access?

  A. IBMDEFAULTBP - 16K page size, 85000 pages

  B. IBMDEFAULTBP - 4K page size, 25000 pagesBP1 -16K page size, 20000 pages

  C. BP1 - page size 8K, 45000 pages

  D. BP1 - 4K page size, 30000 pagesBP2 - 8K page size, 20000 pagesBP3 - 16K page size, 15000 pages

  Correct Answer: D

• Question 16:

  Given a newly created database and sufficient memory. If the following statements are successful: CREATE BUFFERPOOL bp1 SIZE 40MB; CREATE BUFFERPOOL bp2 PAGESIZE 16K SIZE 40000; How much memory will be allocated for buffer pools BP1 and BP2?

  A. 40MB

  B. 80MB

  C. 665MB

  D. 680MB

  Correct Answer: C

• Question 17:

  A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?

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

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

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

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

  Correct Answer: D

• Question 18:

  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

• Question 19:

  A database named MYDB is created in instance DB2INST1, which has been configured to use KRB_SERVER_ENCRYPT authentication. If a client attempting to access database MYDB does not support Kerberos authentication, which authentication method will be used to establish a connection?

  A. SERVER_ENCRYPT

  B. SERVER

  C. KRB_SERVER_ENCRYPT

  D. CLIENT

  Correct Answer: A

• Question 20:

  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

  Correct Answer: C