Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
P.S. Refined C2090-320 paper are available on Google Drive, GET MORE: https://drive.google.com/open?id=1ONX12YMjzKx_pFwlad2x5sVsVebtwWy8
New Questions 2
In which address space would a native SQL stored procedure run?
A. WLM
B. DIST
C. DBM1
D. The address space of the calling program
Answer: C
New Questions 3
Which of the following are contained in the PLAN_TABLE? (Choose two.)
A. RUNSTATS recommendations
B. Access to LOB values, which are stored separately from the base table
C. Access to parent or dependent tables needed to enforce referential constraints
D. Whether an index access or table space scan is used for each access to a table
E. The join methods and types that are used, and the order in which DB2 joins the tables
Answer: DE
New Questions 4
Which BIND option determines when DB2 will do authorization checking?
A. DEFER
B. DEPLOY
C. VALIDATE
D. CURRENTDATA
Answer: C
New Questions 5
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?
A. SQLCA
B. SQLDA
C. SQLCODE
D. SQLSTATE
Answer: B
New Questions 6
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?
A.
B.
C.
D.
Answer: D
New Questions 7
Which authorizations can change the value of the subsystem parameter SYSADM using the u2013SET SYSPARM command? (Choose two.)
A. SYSADM
B. SECADM
C. SYSCTRL
D. Installation SYSADM
E. Installation SYSOPR
Answer: DE
New Questions 8
Which statement is TRUE regarding ROLLBACK processing?
A. It only reads active logs
B. It always needs archive logs
C. It can never be processed just from memory
D. It uses output buffers, active and archive logs
Answer: D
New Questions 9
Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?
A. TRUNCATE employee;
B. DELETE FROM employee;
C. DELETE FROM employee WHEREu2026;
D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;
Answer: B
New Questions 10
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?
A. MSTR
B. DBM1
C. DIST
D. IRLM
Answer: A
New Questions 11
Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?
A. 10 row locks
B. 200 page locks
C. A single table space lock
D. 6 partition locks (given a table space with a total of 10 partitions)
Answer: C
Recommend!! Get the Refined C2090-320 dumps in VCE and PDF From Dumpscollection, Welcome to download: http://www.dumpscollection.net/dumps/C2090-320/ (New Q&As Version)