C2090-320: DB2 11 Fundamentals for z/OS

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

Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

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

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

Explanation:

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

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

Which package level privileges does the user smith have when the following statement is executed?

GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

GRANT, COPY, BIND, RUN
BIND, EXECUTE, COPY, RUN
CREATE, COPY, RUN, EXECUTE
COPY, BINDADD, SQL, EXECUTE

Correct answer: B

Explanation:

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

Vendor:	IBM
Exam Code:	C2090-320
Exam Name:	DB2 11 Fundamentals for z/OS
Date:	Sep 21, 2018
File Size:	417 KB

Download DB2 11 Fundamentals for z-OS.C2090-320.Prep4Sure.2018-09-21.27q.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