C2090-320: DB2 11 Fundamentals for z/OS - Free download from Exam Files

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 statement is TRUE regarding ROLLBACK processing?

It only reads active logs
It always needs archive logs
It can never be processed just from memory
It uses output buffers, active and archive logs

Correct answer: D

Explanation:

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

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

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?

INSERT INTO (COL1) VALUES(HEX(‘12345’));
INSERT INTO (COL1) VALUES(BLOB(‘12345’));
INSERT INTO (COL1) VALUES(CHAR(‘12345’));
INSERT INTO (COL1) VALUES(BINARY(‘123456’));

Correct answer: C

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

Which of the following can activate a trigger?

A row is inserted
A table or view is created
A check constraint is defined
A referential constraint is violated

Correct answer: D

Explanation:

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

In which address space would a native SQL stored procedure run?

WLM
DIST
DBM1
The address space of the calling program

Correct answer: C

Explanation:

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

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?

MSTR
DBM1
DIST
IRLM

Correct answer: A

Vendor:	IBM
Exam Code:	C2090-320
Exam Name:	DB2 11 Fundamentals for z/OS
Date:	Aug 01, 2019
File Size:	465 KB

Download DB2 11 Fundamentals for z-OS.C2090-320.ActualTests.2019-08-01.61q.vcex

How to open VCEX 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