IBM DB2 9.7 Advanced DBA for LUW Set 2

Question - 15 Maximum mark : - 29

Home
All Exams
IBM DB2 9.7 Advanced DBA for LUW Online Mock Tests
IBM DB2 9.7 Advanced DBA for LUW Set 2

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?

CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1; ✘ CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k; ✘ CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k;ALTER TABLESPACE tempspace1BUFFERPOOL bp1; ✘ CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k; ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

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

✘

ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?ALTER TABLESPACE tbsp1MANAGED BY AUTOMATIC STORAGE;

✘

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

✘

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

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

1 Oracle server , 1 DB2 server , 3 Oracle wrappers , and nicknames for each database ✘ 1 Oracle server , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database ✘ 3 Oracle servers , 1 DB2 server , 3 Oracle wrappers , 1 DB2 wrapper , and nicknames for each database ✘ 3 Oracle servers , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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 unique partitioned index is created successfully. ✘ A unique non-partitioned index is created successfully. ✘ The index creation fails because it does not contain the column from the table partitioning key. ✘ A non-unique partitioned index is created successfully. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Check constraint integrity for the partitioned table ✘ 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new tableas a new partition in the existing partitioned table4) Rebind the partitioned table ✘ 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new tableas a new partition in the existing partitioned table 4) Update statistics on the partitioned table ✘ 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new tableas a new partition in the existing partitioned table 4) Reorg the partitioned table ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, 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?

CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (yearmonth))

✘

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

✘

CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (year))

✘

CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year))

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which factor should influence your selection of distribution key(s)?

The distribution key(s) should include the most frequently accessed XML column(s). ✘ The distribution key(s) should include the longest column(s). ✘ The distribution key(s) should include column(s) with the smallest number of distinct values. ✘ The distribution key(s) should include the most frequently joined column(s). ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

Check the output from the command LIST HISTORY BACKUP ALL FOR the database. ✘ Check the value of the COMPRESS_BACKUP database configuration setting. ✘

Check the value of the DB2_COMPRESS_BACKUP registry variable.

✘ Check the header information of the backup file using db2ckbkp. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which conditions must be met to implement HADR?

Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit). ✘ Operating systems on primary and standby servers need not be the same; DB2 versions must be the same;and the databases need not have the same bit-size (32 or 64 bit). ✘ Operating systems on primary and standby servers must be the same; DB2 versions must be the same;and the databases need not have the same bit-size (32 or 64 bit). ✘ Operating systems on primary and standby servers must be the same; DB2 versions must be the same;and the databases must have the same bit-size (32 or 64 bit). ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full backup being taken. What is the fastest way to restore the database?

RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

✘

RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKENAT (Monday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

✘

RESTORE DB proddb TAKEN AT (Friday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKENAT (Saturday);

✘

RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKENAT (Friday);

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

IBM DB2 9.7 Advanced DBA for LUW Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner