IBM Certified Database Administrator C2090-600 Dumps | Updated Aug 04, 2021 - TestValid
Master 2021 Latest The Questions IBM Certified Database Administrator and Pass C2090-600 Real Exam!
NEW QUESTION 15
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
- A. It does not require additional temporary disk space
- B. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments
- C. It does not acquire locks on the table
- D. It enables the user to control when the table will be offline
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 16
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?
- A. Check the encrypted database parameter in database configuration
- B. Select from the ADMIN_GET_ENCRYPTION_INFO table function
- C. Run the db2ckbkp command and verify the compression settings
- D. Check ENCROPTS database configuration parameter for encryption options
Answer: D
NEW QUESTION 17
Which statement regarding event monitors is TRUE?
- A. Event monitors are used to obtain information about how a database system looks at a specific point in time
- B. Event monitors must always be started manually after activating a database
- C. Event monitor data can be reviewed while the event monitor is active
- D. Event monitors must write data to .EVT files before the data can be loaded into database tables
Answer: B
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/ doc/r0000915.html
NEW QUESTION 18
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
- A. The routine cannot contain comments.
- B. The routine must be generated with IBM Database Conversion Workbench (DCW).
- C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
- D. The routine must return either an integer or a null.
- E. The routine cannot contain argument lists or variable arguments (varargs).
Answer: D,E
NEW QUESTION 19
Which options are valid for an online reorganization operation?
- A. CLASSIC and RECLAIM EXTENTS
- B. FULL and RECLAIM EXTENTS
- C. FULL and CLEANUP OVERFLOWS
- D. CLEAN OVERFLOWS and RECLAIM EXTENTS
Answer: B
NEW QUESTION 20
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density.
What can cause an MDC table to use much more space?
- A. The page size is too small.
- B. High cardinality of the dimension(s) chosen.
- C. The extent size is too small.
- D. Low cardinality of the dimension(s) chosen.
Answer: B
NEW QUESTION 21
If the following SQL statements are executed:
How many rows will be added to the DEPARTMENT table?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 22
Which of the following are valid Explain operators? (Choose two.)
- A. COLSCAN
- B. CTQ
- C. IXSCAN
- D. SELECT
- E. XSCAN
Answer: C,E
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.explain.doc/doc/r0052023.html
NEW QUESTION 23
Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?
- A. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.
- B. A local keystore is not needed if a Hardware Security Module (HSM) is used to manage master keys.
- C. A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.
- D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.
Answer: C
NEW QUESTION 24
Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?
- A. db2advis
- B. db2expln
- C. db2dart
- D. db2pd
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 25
Which of the following are all valid types of trigger?
- A. ATOMIC, BEFORE, INSTEAD OF
- B. AFTER, ATOMIC, INSTEAD OF
- C. AFTER, BEFORE, INSTEAD OF
- D. AFTER, ATOMIC, BEFORE
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0020224.html
NEW QUESTION 26
Which of the following statements is TRUE?
- A. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
- B. REORGCHK can only be used for user tables, not for system tables.
- C. REORGCHK automatically runs tables reorganization.
- D. REORGCHK uses only current table and index statistics.
Answer: D
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.cmd.doc/doc/r0001971.html
NEW QUESTION 27
What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?
- A. SYSFUN
- B. SYSCAT
- C. SYSIBM
- D. SYSIBMADM
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_4.2.0/
com.ibm.swg.im.infosphere.biginsights.commsql.doc/doc/r0059071.html
NEW QUESTION 28
Where does the DB2 Problem Determination tool (db2pd) get information from?
- A. DB2memory sets
- B. Monitoring table functions
- C. the db2diag.log file
- D. A set of pre-defined event monitors
Answer: A
NEW QUESTION 29
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
- A. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
- B. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
- C. REORG TABLE sales INPLACE REBUILDDICTIONARY
- D. REORG TABLE sales INPLACE RESETDICTIONARY
Answer: A
NEW QUESTION 30
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. Only new or updated data for XML columns will be compressed.
- D. New and existing XML columns will be compressed but other columns remain unchanged.
Answer: A
NEW QUESTION 31
If the following SQL statements are executed:
How many rows will be added to the DEPARTMENT table?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 32
Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)
- A. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage
- B. Catalog a storage access alias in the DB2 database
- C. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
- D. Create an FTP account on IBM Softlayer Object Storage
- E. Use the DB2REMOTE parameter of the LOAD command
Answer: B,E
NEW QUESTION 33
What levels of authority are needed to create a storage group? (Choose two.)
- A. SQLADM
- B. SYSMAINT
- C. SYSADM
- D. SYSCTRL
- E. DBADM
Answer: C,D
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/ doc/r0058606.html
NEW QUESTION 34
......
A fully updated 2021 C2090-600 Exam Dumps exam guide from training expert TestValid: https://www.testvalid.com/C2090-600-exam-collection.html