IBM
C2090-600 Exam
IBM Certified Database Administrator - DB2 11.1 for Linux, UNIX, and Windows
Questions & Answers (Demo Version)
https://dumpslibrary.com/ibm-c2090-600-pdf-dumps/
BUY FULL PRODUCT HERE:
, s@lm@n
IBM
Exam C2090-600
IBM DB2 11.1 DBA for LUW
Verson: Demo
[ Total Questions: 10 ]
, IBM C2090-600 : Practice Test
Question No : 1
Which DB2 Explain Facility tool uses the Explain tables to display access plain
information?
A. db2look
B. db2advis
C. db2expln
D. db2exfmt
Answer: C
Question No : 2
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ
registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
A. As the db2 instance owner (db2inst1) execute the
command:exportDB2_FMP_COMM_HEAPSZ=256000
B. Add to the following line to the userprofile (db2inst1):
DB2_FMP_COMM_HEAPSZ=256000
C. As the db2 instance owner (db2inst1) execute the command:db2set –i
DB2_FMP_COMM_HEAPSZ=256000
D. As the db2 instance owner (db2inst1)execute the command:db2set –i db2inst1
DB2_FMP_COMM_HEAPSZ=256000
Answer: C
Question No : 3
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple
steps?
A. It does not acquire locks on the table
B. It does not require additional temporary disk space
C. It enables the user to control when the table will be offline
D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments
Pass Your Certification With Marks4sure Guarantee 2
, IBM C2090-600 : Practice Test
Answer: D
Question No : 4
A production database has the following daily midnight backup schedule which includes all
table spaces. The database incurs the same volume of daily activity (inserts, updates, and
deletes).
Sunday – Delta
Monday – Incremental
Tuesday – Delta
Wednesday – Delta
Thursday – Incremental
Friday – Delta
Saturday – Full
Which day would you expect a RECOVER DATABASE following that day’s backup to take
the longest time to complete?
A. Friday
B. Monday
C. Saturday
D. Wednesday
Answer: A
Question No : 5
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose
two.)
A. XML
B. REAL
Pass Your Certification With Marks4sure Guarantee 3
, IBM C2090-600 : Practice Test
C. NUMBER
D. VRCHAR2
E. VARBINARY
Answer: C,E
Question No : 6
Which statement about the db2move command is TRUE?
A. The LOAD actions can be run from a client machine.
B. Object ownership cannot be changed after a successful schema copy operation.
C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
D. Loading data into tables containing XML columns is only supported for the LOAD
actions.
Answer: D
Question No : 7
Which of the following are all valid types of trigger?
A. AFTER, ATOMIC, BEFORE
B. AFTER, ATOMIC, INSTEAD OF
C. AFTER, BEFORE, INSTEAD OF
D. ATOMIC, BEFORE, INSTEAD OF
Answer: C
Question No : 8
When querying the MON_GET_TABLESPACE table function, the values for many of the
performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are
showing 0, even though there is activity occurring in the database. Which command must
be executed to enable the table function to return actual data?
Pass Your Certification With Marks4sure Guarantee 4
, IBM C2090-600 : Practice Test
A. UPDATE DB CFG USING MON_OBJ_METRICS BASE
B. UPDATE DB CFG USING MON_ACT_METRICS BASE
C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
Answer: C
Question No : 9
What levels of authority are needed to create a storage group? (Choose two.)
A. DBADM
B. SYSADM
C. SQLADM
D. SYSCTRL
E. SYSMAINT
Answer: B,D
Question No : 10
Which security mechanism is responsible for verifying that users are indeed who the claim
to be?
A. Authentication
B. Roles and privileges
C. Mandatory access control
D. Discretionary access control
Answer: A
Pass Your Certification With Marks4sure Guarantee 5
C2090-600 Exam
IBM Certified Database Administrator - DB2 11.1 for Linux, UNIX, and Windows
Questions & Answers (Demo Version)
https://dumpslibrary.com/ibm-c2090-600-pdf-dumps/
BUY FULL PRODUCT HERE:
, s@lm@n
IBM
Exam C2090-600
IBM DB2 11.1 DBA for LUW
Verson: Demo
[ Total Questions: 10 ]
, IBM C2090-600 : Practice Test
Question No : 1
Which DB2 Explain Facility tool uses the Explain tables to display access plain
information?
A. db2look
B. db2advis
C. db2expln
D. db2exfmt
Answer: C
Question No : 2
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ
registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?
A. As the db2 instance owner (db2inst1) execute the
command:exportDB2_FMP_COMM_HEAPSZ=256000
B. Add to the following line to the userprofile (db2inst1):
DB2_FMP_COMM_HEAPSZ=256000
C. As the db2 instance owner (db2inst1) execute the command:db2set –i
DB2_FMP_COMM_HEAPSZ=256000
D. As the db2 instance owner (db2inst1)execute the command:db2set –i db2inst1
DB2_FMP_COMM_HEAPSZ=256000
Answer: C
Question No : 3
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple
steps?
A. It does not acquire locks on the table
B. It does not require additional temporary disk space
C. It enables the user to control when the table will be offline
D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments
Pass Your Certification With Marks4sure Guarantee 2
, IBM C2090-600 : Practice Test
Answer: D
Question No : 4
A production database has the following daily midnight backup schedule which includes all
table spaces. The database incurs the same volume of daily activity (inserts, updates, and
deletes).
Sunday – Delta
Monday – Incremental
Tuesday – Delta
Wednesday – Delta
Thursday – Incremental
Friday – Delta
Saturday – Full
Which day would you expect a RECOVER DATABASE following that day’s backup to take
the longest time to complete?
A. Friday
B. Monday
C. Saturday
D. Wednesday
Answer: A
Question No : 5
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose
two.)
A. XML
B. REAL
Pass Your Certification With Marks4sure Guarantee 3
, IBM C2090-600 : Practice Test
C. NUMBER
D. VRCHAR2
E. VARBINARY
Answer: C,E
Question No : 6
Which statement about the db2move command is TRUE?
A. The LOAD actions can be run from a client machine.
B. Object ownership cannot be changed after a successful schema copy operation.
C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
D. Loading data into tables containing XML columns is only supported for the LOAD
actions.
Answer: D
Question No : 7
Which of the following are all valid types of trigger?
A. AFTER, ATOMIC, BEFORE
B. AFTER, ATOMIC, INSTEAD OF
C. AFTER, BEFORE, INSTEAD OF
D. ATOMIC, BEFORE, INSTEAD OF
Answer: C
Question No : 8
When querying the MON_GET_TABLESPACE table function, the values for many of the
performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are
showing 0, even though there is activity occurring in the database. Which command must
be executed to enable the table function to return actual data?
Pass Your Certification With Marks4sure Guarantee 4
, IBM C2090-600 : Practice Test
A. UPDATE DB CFG USING MON_OBJ_METRICS BASE
B. UPDATE DB CFG USING MON_ACT_METRICS BASE
C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
Answer: C
Question No : 9
What levels of authority are needed to create a storage group? (Choose two.)
A. DBADM
B. SYSADM
C. SQLADM
D. SYSCTRL
E. SYSMAINT
Answer: B,D
Question No : 10
Which security mechanism is responsible for verifying that users are indeed who the claim
to be?
A. Authentication
B. Roles and privileges
C. Mandatory access control
D. Discretionary access control
Answer: A
Pass Your Certification With Marks4sure Guarantee 5
