IBM IBM Certifications C2090-320 Questions & Answers

• Question 61:

  Which authorizations can change the value of the subsystem parameter SYSADM using the -SET SYSPARM command? (Choose two.)

  A. SYSADM

  B. SECADM

  C. SYSCTRL

  D. Installation SYSADM

  E. Installation SYSOPR

  Correct Answer: DE

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/comref/src/tpc/ db2z_cmd_setsysparm.html

• Question 62:

  Which of the following is NOT a valid trigger?

  A. MERGE

  B. INSERT

  C. UPDATE

  D. DELETE

  Correct Answer: A

  Reference: https://www.splessons.com/lesson/db2-trigger/

• Question 63:

  Which characteristic best describes a created global temporary table?

  A. Inserts are logged

  B. Rows are locked when they exist in the table

  C. They have permanent, shareable descriptions

  D. Access to rows can be shared across multiple processes

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/ db2z_creationoftemporarytables.html

• Question 64:

  Given the following INDEX definition, which attributes apply to this index? (Choose two.)

  

  A. The index is partitioned

  B. The index data sets are user-managed

  C. The index data sets are DB2-managed

  D. The index is unique and in ascending order

  E. The maximum total size of the index is 1 GB

  Correct Answer: AB

• Question 65:

  Consider the following scenario:

  User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1 Is User3 able to retrieve rows from TABLE1?

  A. No

  B. Yes

  C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES

  D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

  Correct Answer: B

• Question 66:

  In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

  A. A unique key

  B. A foreign key

  C. A primary key

  D. A duplicate key

  E. A secondary key

  Correct Answer: AC

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020153.html

• Question 67:

  How can a stored procedure be invoked?

  A. Via an SQL SELECT statement

  B. Via a CALL statement using SPUFI

  C. Directly via a RUN PROGRAM command

  D. Via a CALL statement from within an application program

  Correct Answer: D

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_call.html

• Question 68:

  A summary table can be easily maintained using which of the following?

  A. An auxiliary table

  B. A partitioned table

  C. A bi-temporal table

  D. A materialized query table

  Correct Answer: D

  Reference: http://www.informit.com/articles/article.aspx?p=2755707andseqNum=3

• Question 69:

  A clone table can only be created in which of the following?

  A. A simple table space

  B. A universal table space

  C. An auxiliary table space

  D. A classic segmented table space

  Correct Answer: B

  Reference: https://community.toadworld.com/platforms/ibmdb2/w/wiki/6841.clone-tables

• Question 70:

  Which privilege or authority is required to use the DSN command?

  A. None

  B. SYSADM

  C. SECADM

  D. EXECUTE

  Correct Answer: B

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_cmd_bindplan.html