IBM IBM Certifications C2090-320 Questions & Answers

• Question 101:

  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

  Correct Answer: C

  Reference: http://www.ibmbigdatahub.com/blog/db2-native-sql-procedures-future-computing

• Question 102:

  Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

  A. GRANT, COPY, BIND, RUN

  B. BIND, EXECUTE, COPY, RUN

  C. CREATE, COPY, RUN, EXECUTE

  D. COPY, BINDADD, SQL, EXECUTE

  Correct Answer: B

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

• Question 103:

  You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

  A. REAL

  B. BIGINT

  C. DECIMAL

  D. INTEGER

  Correct Answer: C

  Reference: https://www.ibm.com/support/knowledgecenter/en/SS6NHC/ com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0000791.html

• Question 104:

  Which of the following is a characteristic of a stand-alone utility?

  A. It can only be executed using JCL

  B. It can only be executed by a user with SYSADM

  C. It can only be executed if no other utilities are running

  D. It can only be executed in a non-data sharing environment

  Correct Answer: A

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/

  db2z_invokestandaloneutl.html

• Question 105:

  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 WHERE...;

  D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

  Correct Answer: B

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

• Question 106:

  Given the following CREATE VIEW statement and sample data; your login id is "ROGER". What will be the result for this query?

  

  A. 6

  B. 5

  C. 4

  D. 2

  Correct Answer: C

• Question 107:

  You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved.

  How can you accomplish this?

  A. Bind your application with ISOLATION(UR)

  B. Bind your application with ISOLATION(CS)

  C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)

  D. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

  Correct Answer: D

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

• Question 108:

  If a scrollable cursor is INSENSITIVE, which of the following applies?

  A. The cursor is read only

  B. WITH ROWSET POSITIONING is not allowed

  C. The select-statement must not contain an SQL data change statement

  D. The cursor has sensitivity to changes that are made to the database after the result table is materialized

  Correct Answer: A

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

• Question 109:

  The following definition for COL1 is given by this statement:

  CREATE TABLE... (COL1 BINARY (05))

  Which of the following statements will successfully insert data into the table?

  A. INSERT INTO... (COL1) VALUES(HEX(`12345'));

  B. INSERT INTO... (COL1) VALUES(BLOB(`12345'));

  C. INSERT INTO... (COL1) VALUES(CHAR(`12345'));

  D. INSERT INTO... (COL1) VALUES(BINARY(`123456'));

  Correct Answer: C

• Question 110:

  The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

  A. A view

  B. A temporal table

  C. A created global temporary table

  D. A declared global temporary table

  Correct Answer: B