C2090-611 by IBM Actual Free Exam Questions And Answers

Question 1

What is the FLUSH PACKAGE CACHE statement used for?

A. To remove all cached static SQL statements from the package cache.

B. It saves dynamic SQL stored in the package cache to an external file.

C. It causes all SQL statements in the package cache that are currently in use to be recompiled.

D. To remove all cached dynamic SQL statements from the package cache.

Discussion 0

Correct Answer: D Vote an answer

Question 2

If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

A. Version recovery

B. Roll-forward recovery

C. Crash recovery

D. Disaster recovery

Discussion 0

Correct Answer: C Vote an answer

Question 3

How can you remove all effects of compression from an index?

A. Execute the ALTER INDEX statement to turn compression off.

B. Execute the ALTER TABLE statement to turn compression off.

C. Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer thatcompression is no longer used.

D. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.

Discussion 0

Correct Answer: D Vote an answer

Question 4

By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

A. Drop and recreate the index.

B. Drop and reload the table.

C. Reorganize the table to cluster its data according to that index.

D. Reorganize the table to cluster its index according to that query plan.

Discussion 0

Correct Answer: C Vote an answer

Question 5

Which statement is true regarding client-server database connectivity?

A. A loopback connection can be made with either the APPC or TCP/IP protocol enabled.

B. A remote connection is established between a DB2 client in a different location from the database server.

C. A DB2 client running a lower version of DB2 can establish a local connection to a server running on a newer version.

D. A remote connection uses Interprocess Communication (IPC).

Discussion 0

Correct Answer: B Vote an answer

Question 6

What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

A. Permission to log in to the database client using telnet.

B. Permission to log in to the database server using telnet.

C. Permission to log in to the database server using secure shell (SSH).

D. Permission to log in to the database client using secure shell (SSH).

Discussion 0

Correct Answer: C Vote an answer

Question 7

Given the following statement:

How many constraints are present in the DEPARTMENT table?

A. 2

B. 4

C. 3

D. 1

Discussion 0

Correct Answer: B Vote an answer

Question 8

When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

A. They are marked as "Move Pending."

B. They are automatically moved to the new table space.

C. They are marked as "Dropped Pending."

D. They are automatically dropped.

Discussion 0

Correct Answer: C Vote an answer

Question 9

Which statement about referential constraints is true?

A. A referential constraint can be defined against a catalog table.

B. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.

C. A referential constraint can be defined on both tables and views.

D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.

Discussion 0

Correct Answer: B Vote an answer

Question 10

Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?

A. db2fmtdiag

B. db2trace

C. db2diag

D. db2pd

Discussion 0

Correct Answer: C Vote an answer

IBM DB2 10.1 DBA for Linux, UNIX, and Windows - C2090-611 Exam Practice Test

Contact Us

Useful Links

Latest Updated