IBM IBM Certifications C2090-320 Questions & Answers

• Question 11:

  You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

  A. BLOB

  B. CLOB

  C. DBCLOB

  D. VARGRAPHIC

  Correct Answer: A

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

• Question 12:

  Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?

  A. All held LOB locators are retained

  B. All locks that are implicitly acquired during the unit of recovery are retained

  C. All rows and all logical work files of every created temporary table of the application process are deleted

  D. All cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated

  Correct Answer: D

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

• Question 13:

  Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)

  A. MAXPARTITIONS

  B. ENDING AT clause on a CREATE INDEX statement for the table

  C. MEMBER CLUSTER

  D. ENDING AT clause on the CREATE TABLE statement

  E. A LOB column specified as a column of the partitioning key

  Correct Answer: BE

• Question 14:

  Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

  A. CLI

  B. JDBC

  C. DRDA

  D. ODBC

  Correct Answer: C

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

• Question 15:

  What is the implicitly created column in a base table which contains an XML column called?

  A. Node ID

  B. ROWID

  C. LOCATOR

  D. DOCID

  Correct Answer: B

• Question 16:

  Given the following SQL statement:

  GRANT DELETE ON TABLE customer TO user1;

  Which of the following statements is TRUE?

  A. User1 can only remove the customer table

  B. User1 can only remove rows from the customer table

  C. User1 can remove the customer table and grant the privilege to remove the customer table to other users

  D. User1 can remove rows from the customer table and can grant the privilege to remove rows from the customer table to other users

  Correct Answer: D

• Question 17:

  When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following?

  GRANT DBADM ON SYSTEM TO smith;

  A. Tables

  B. Traces

  C. Sequences

  D. Security Objects

  Correct Answer: B

• Question 18:

  An application program is running much longer than expected. The PLAN_TABLE shows the following access path information:

  ACCESSTYPE = `R' PREFETCH = `S'

  What access path does this represent?

  A. IN-list access

  B. Direct row access

  C. Dynamic prefetch access

  D. Table space scan access

  Correct Answer: D

  Reference: https://flylib.com/books/en/2.608.1.155/1/

• Question 19:

  Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?

  A. SYSIBM.SYSSTMT

  B. SYSIBM.SYSPARMS

  C. SYSIBM.SYSROUTINES

  D. SYSIBM.SYSVARIABLES

  Correct Answer: B

• Question 20:

  Which CREATE TABLESPACE option specifies that a table space is partition-by-growth?

  A. DSSIZE

  B. PARTITION

  C. NUMPARTS

  D. MAXPARTITIONS

  Correct Answer: D

  Reference: https://it.toolbox.com/blogs/williamfavero/be-careful-how-you-define-your-partition-by-growthuniversal-table-space-012512