Free Download C2090-320 Examp Dump: IBM.C2090-320.ActualTests.2019-08-01.61q.vcex

Question 1

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

Question 2

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:

Question 3

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

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Exam	DB2 11 Fundamentals for z/OS
Number	C2090-320
File Name	IBM.C2090-320.ActualTests.2019-08-01.61q.vcex
Size	465 KB
Posted	Aug 01, 2019
Download	IBM.C2090-320.ActualTests.2019-08-01.61q.vcex

Download IBM.C2090-320.ActualTests.2019-08-01.61q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions