C2090-600 by IBM Actual Free Exam Q&As

Question 1

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

A. Set the sort heap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE
DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K. B. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables. C. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the
ALTER BUFFERPOOL statement after making sure that at least one entry is present in
SYSCAT.BUFFERPOOLDBPARTITIONS. D. Set the SELF TUNING_MEM database configuration parameter to ON using the UPDATE
DATABASECONFIGURATION command or the db2CfgSet API.

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which statement about the db2move command is TRUE?

A. Tables containing GENERATED ALWAYS identity columns can be imported or loaded. B. Loading data into tables containing XML columns is only supported for the LOAD actions. C. Object ownership cannot be changed after a successful schema copy operation. D. The LOAD actions can be run from a client machine.

Discussion 0

Correct Answer: B Vote an answer

Question 3

What is the result of the following scenario?

A. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed B. The row is updated to (2, NULL) C. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL D. The row is updated to (2, 110.00)

Discussion 0

Correct Answer: D Vote an answer

Question 4

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists.
What is the effect of enabling compression and then running the command REORG TABLE mytable
KEEPDICTIONARY?

A. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used. B. All data, both new and existing, will be compressed. C. New and existing XML columns will be compressed but other columns remain unchanged. D. Only new or updated data for XML columns will be compressed.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

A. NUMBER B. XML C. VARBINARY D. VRCHAR2 E. REAL

Discussion 0

Correct Answer: A,C Vote an answer

Question 6

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. TRANSPORT B. INGEST C. LOAD D. IMPORT

Discussion 0

Correct Answer: D Vote an answer

IBM DB2 11.1 DBA for LUW - C2090-600 Exam Practice Test