IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows - A2090-611 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What is an informational constraint?

A. A constraint that is used by the optimizer but is not enforced. B. A constraint that is created from information supplied to the design advisor. C. A constraint that provides Information to the RUNSTATS utility. D. A constraint that defines a relationship to a federated object.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

A. CLIENT B. SERVER C. KERBEROS_PLUGIN D. LDAP_PLUGIN E. DATA_ENCRYPT

Discussion 0

Correct Answer: B,E Vote an answer

Question 3

You have just converted an existing database to an automatic storage database. What can you use to move data from an existing DMS table space to an automatic storage table space, while the data remains online and available for access?

A. The ADMIN_MOVE_TABLE_UTIL procedure B. The db2relocatedb command C. The db2move command D. The ADMIN_MOVE_TABLE procedure

Discussion 0

Correct Answer: D Vote an answer

Question 4

What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

A. Processing instructions performed B. Timerons C. CPU cycles D. Elapsed time, in milliseconds

Discussion 0

Correct Answer: B Vote an answer

Question 5

Which is a valid statement about the Row and Column Access Control (RCAC) feature?

A. RCAC is a more powerful security mechanism than Label Based Access Control (LBAC). B. The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality. C. When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned. D. Users with SECADM authority are exempt from RCAC rules.

Discussion 0

Correct Answer: C Vote an answer

Question 6

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?

A. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated. B. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated. C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated. D. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.

Discussion 0

Correct Answer: D Vote an answer

Question 7

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. Crash recovery B. Roll-forward recovery C. Version recovery D. Disaster recovery

Discussion 0

Correct Answer: A Vote an answer

Question 8

What can be used to provide input to the Design Advisor?

A. An XML file. B. The database manager configuration file. C. The database configuration file. D. A query workload file.

Discussion 0

Correct Answer: D Vote an answer

Question 9

An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

A. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted. B. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE. C. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE. D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.

Discussion 0

Correct Answer: D Vote an answer