C2090-320: DB2 11 Fundamentals for z/OS

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

10 row locks
200 page locks
A single table space lock
6 partition locks (given a table space with a total of 10 partitions)

Correct answer: C

Which of the following is NOT TRUE?

An index can be created on XML columns
Length must be specified for an XML column
XML columns can be added to existing tables
Triggers can be created on tables with XML columns

Correct answer: D

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

SELECT * FROM MYUSER.EMP;
CONNECT TO MYREMOTE;
SELECT * FROM MYUSER.EMP;
SELECT * FROM MYUSER.MYREMOTE.EMP;
CREATE ALIAS EMP_ALIAS FOR LOCATION.MYREMOTE.MYUSER.EMP;
SELECT * FROM MYUSER.EMP_ALIAS;

Correct answer: B

Which of the following elements is affected by a ROLLBACK statement?

LOB table spaces
Changes in cursor positioning
Acquisition and release of locks
Caching of rolled back statements

Correct answer: A

Explanation:

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

Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

SQLCA
SQLDA
SQLCODE
SQLSTATE

Correct answer: B

Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA ON”. Which of the following statements must precede the CREATE statement so that you can create the index?

SET CURRENT SQLID = ‘DB2’;
SET CURRENT RULES = ‘DB2’;
No preceding statement is needed
SET CURRENT SCHEMA = ‘DB2’;

Correct answer: A

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

A view
A temporal table
A created global temporary table
A declared global temporary table

Correct answer: B

In a unique referential constraint, which type of key does a foreign key reference?

Child key
Collation key
Parent key
Secondary key

Correct answer: C

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html

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

The cursor is read only
WITH ROWSET POSITIONING is not allowed
The select-statement must not contain an SQL data change statement
The cursor has sensitivity to changes that are made to the database after the result table is materialized

Correct answer: A

Explanation:

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

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?

Bind your application with ISOLATION(UR)
Bind your application with ISOLATION(CS)
Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

Correct answer: D

Explanation:

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

Vendor:	IBM
Exam Code:	C2090-320
Exam Name:	DB2 11 Fundamentals for z/OS
Date:	Apr 05, 2019
File Size:	559 KB

Download DB2 11 Fundamentals for z-OS.C2090-320.PracticeTest.2019-04-05.29q.tqb

How to open TQB files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown