IBM DB2 9.7 Advanced DBA for LUW - 000-544 Exam Practice Test
A database named DB1 has a database partition group named MULTIPG that has been defined
across partitions 3, 4 and 5.
The DBA issues the following series of commands/SQL statements:
CONNECT TO db1;
SET CURRENT DBPARTITIONNUM 4;
ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6);
Which partition will DB2 use as a model for table spaces on partition 6?
across partitions 3, 4 and 5.
The DBA issues the following series of commands/SQL statements:
CONNECT TO db1;
SET CURRENT DBPARTITIONNUM 4;
ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6);
Which partition will DB2 use as a model for table spaces on partition 6?
Correct Answer: D
Vote an answer
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?
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?
Correct Answer: A
Vote an answer
Which statement is true about clustering indexes in a partitioned database?
Correct Answer: C
Vote an answer
Which statement about compression and temporary tables is NOT correct?
Correct Answer: D
Vote an answer
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?
Correct Answer: B
Vote an answer
Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?
Correct Answer: D
Vote an answer
Click the Exhibit button.
Refer to the table definition shown in the exhibit.
Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?
Refer to the table definition shown in the exhibit.
Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?
Correct Answer: A
Vote an answer
If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?
Correct Answer: C
Vote an answer