IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two workload management thresholds support priority aging by providing a remapping action? (Choose two.)

A. REMAPACTIVITY B. ACTIVITYTOTALTIME C. CONCURRENTDBCOORDACTIVITIES D. SQLROWSREADINSC E. CPUTIMEINSC

Discussion 0

Correct Answer: D,E Vote an answer

Question 2

You have created a table using the INLINE LENGTH option. Which function is used to determine if XML documents or LOB data is being stored in the base table?

A. STORED_INLINE B. ADMIN_IS_INLINED C. ADMIN_INLINED D. INLINE_IS_ENABLE

Discussion 0

Correct Answer: B Vote an answer

Question 3

Which two registry variables that are normally used to delay or avoid acquiring locks are affected by Currently Committed (CC) semantics when the Cursor Stability (CS) isolation level are used? (Choose two.)

A. DB2_EVALUNCOMMITTED Extended Option: B. DB2_EVALCOMMITTED Extended Option: C. DB2_SKIPINSERTED Extended Option: D. DB2_SKIPUPDATED Extended Option: E. DB2_WAITFOROUTCOME Extended Option:

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

Which function/stored procedure CANNOT be used to view audit facility data?

A. SYSPROAUDIT_LIST_LOGS B. SYSPROC.AUDIT_ARCHIVE C. SYSPROC.AUDIT_DELIM_EXTRACT D. SYSPROC.AUDIT_AUTH

Discussion 0

Correct Answer: D Vote an answer

Question 5

Click on the Exhibit button Given the following DDL statements:

If COL2 contains XML documents similar to the scenario, what is the end result of the CREATE INDEX statement?

A. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table spaceas the related data. B. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX willautomatically be created within the first index partition listed in the create table statement. C. A non-partitioned index will be created in the INDEX_TS table space for XML_INDEX. D. An error will be returned because it is not possible to create an index for an XML column like COL2

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which two of the following can now be monitored with DB2 v9.7? (Choose two.)

A. Deadlocks, lock timeouts, and lock waits. B. Memory consumption by static SQL statements. C. Unit of work total memory usage. D. Unit of work total CPU usage. E. Memory consumption by static and dynamic SQL statements.

Discussion 0

Correct Answer: A,D Vote an answer

Question 7

Which statements about Explain administration authority (EXPLAIN) are true?

A. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. DBADM can grant this authority and this authority can be granted to PUBLIC. B. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM can grant this authority and this authority can be granted to PUBLIC. C. EXPLAIN authority allows a user to explain query plans without gaining access to data for a specific database. SECADM and DBADM can grant this authority and this authority cannot be granted to PUBLIC. D. EXPLAIN authority allows a user to explain query plans by gaining limited access to data for a specific database. SECADM can grant this authority and this authority cannot be granted to PUBLI

Discussion 0

Correct Answer: B Vote an answer

Question 8

A DB2 9.7 database has been enabled for Oracle compatibility. What is the command to disable all compatibility features?

A. db2set DB2_COMPATIBILITY_VECTOR= B. db2set DB2_COMPATIBILITY_VECTOR=ORA C. db2set DB2_COMPATIBILITY_VECTOR=DB2 D. db2set DB2_COMPATIBILITY_VECTOR_ORACLE=OFF

Discussion 0

Correct Answer: A Vote an answer