[Jul 05, 2021] C2090-600 PDF Dumps is essential on your C2090-600 Exam Questions Certain Success!
C2090-600 PDF Questions - Perfect Prospect To Go With C2090-600 Practice Exam
NEW QUESTION 16
Given the following:
What will be the result of the following SQL statement?
INSERT INTO v3 (col1) values (30);
- A. The insert will succeed as it passes validation.
- B. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.
- C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
- D. The insert will succeed as there is no WITH CHECK OPTION on view V3.
Answer: C
NEW QUESTION 17
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
Explanation:
Explanation
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.apdv.porting.doc/doc/r_sql_compat_nzplsql.html/
NEW QUESTION 18
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 19
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
- A. db2trc on -db mydb -m "backup,load"
run the desired operations
db2tc dump db2trc.dmp
db2tc format db2tc.dmp db2tc.fmt
db2tc off - B. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
- C. db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).
Run the desired operations.
Afterwards, issue db2trc dump <outfile> - D. CONNECT TO mydb
PRUNE HISTORY TO /outdir
Answer: A
NEW QUESTION 20
An HADR environment has two standby databases - one principal and one auxiliary. What is the only mode that can be used to transfer data to the auxiliary standby?
- A. NEARSYNC
- B. ASYNC
- C. SUPERASYNC
- D. SYNC
Answer: C
NEW QUESTION 21
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
- A. db2advis
- B. db2exfmt
- C. db2expln
- D. db2look
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/
com.ibm.db2.luw.admin.perf.doc/doc/c0005134.html
NEW QUESTION 22
Which of the following statements about compression for BLU MPP tables is TRUE?
- A. Each table has a single compression dictionary that gets replicated across all partitions
- B. Compression must be explicitly enabled for BLU MPP tables
- C. Unique compression dictionaries are generated for each partition
- D. Compression requires decompression to evaluate partition joins
Answer: A
Explanation:
Explanation/Reference:
Reference: http://www.idug.org/p/bl/et/blogaid=503
NEW QUESTION 23
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
NEW QUESTION 24
Which statement about NOT ENFORCED unique constraints is TRUE?
- A. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a warning will be returned
- B. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index
- C. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
- D. NOT ENFORCED unique constraints can not be defined on primary key columns
Answer: D
NEW QUESTION 25
Which of the following statements about audit policies is TRUE?
- A. If a user is switched within a trusted connection, the applicable audit policies are re-evaluated for the new user without regard to audit policies for the original user.
- B. Audit policy changes are applied instantly and affect all inflight transactions.
- C. Multiple audit policies can be associated with the same table at the same time.
- D. The audit policy applied to a table is automatically applied to any view based on that table.
Answer: A
NEW QUESTION 26
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
- A. DATETIME
- B. BLOB
- C. VARCHAR
- D. XML
- E. CLOB
Answer: A,C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0061454.html
NEW QUESTION 27
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 28
You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?
- A. db2cluster -cm -list -alert
- B. db2cluster -cm -verify -resource
- C. db2cluster -verify -configuration
- D. db2cluster -verify
Answer: B
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/tutorials/dm-1108db2purescalepd/
NEW QUESTION 29
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
- A. db2advis
- B. db2exfmt
- C. db2expln
- D. db2look
Answer: C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.perf.doc/ doc/c0005134.html
NEW QUESTION 30
Which operation can be performed with trusted context privileges that are acquired through a role?
- A. DML operations
- B. Server maintenance operations
- C. DDL operations
- D. Security administration operations
Answer: A
NEW QUESTION 31
......
C2090-600 Exam with Accurate IBM DB2 11.1 DBA for LUW PDF Questions: https://www.testpdf.com/C2090-600-exam-braindumps.html
