Download DB2 11 Fundamentals for z-OS.C2090-320.Pass4Sure.2019-05-02.36q.vcex

Vendor:	IBM
Exam Code:	C2090-320
Exam Name:	DB2 11 Fundamentals for z/OS
Date:	May 02, 2019
File Size:	372 KB

Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

Demo Questions

Which of the following are contained in the PLAN_TABLE? (Choose two.)

RUNSTATS recommendations
Access to LOB values, which are stored separately from the base table
Access to parent or dependent tables needed to enforce referential constraints
Whether an index access or table space scan is used for each access to a table
The join methods and types that are used, and the order in which DB2 joins the tables

Correct answer: DE

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

COPY
REORG
STOSPACE
BACKUP SYSTEM

Correct answer: D

Explanation:

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

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

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

Correct answer: D

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

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

Given the following CREATE VIEW statement and sample data; your login id is “ROGER”. What will be the result for this query?