IBM Assessment: DB2 10.1 Advanced DBA for LUW - A2090-614 Exam Practice Test
Which type of storage is utilized in the implementation of an effective and flexible multi-temperature database?
Correct Answer: D
Vote an answer
In which situation would you NOT use a redirected restore?
Correct Answer: B
Vote an answer
A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?
Correct Answer: D
Vote an answer
A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?
Correct Answer: D
Vote an answer
A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:
IBM 000-614 : Practice Test
The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production.
At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?
IBM 000-614 : Practice Test
The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production.
At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?
Correct Answer: C
Vote an answer
A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2
10.1. When will a default storage group be defined for this database?
10.1. When will a default storage group be defined for this database?
Correct Answer: A
Vote an answer
What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?
Correct Answer: B
Vote an answer