25 June, 2020

Rebirth C2090-320 Pdf Exam For DB2 11 Fundamentals For Z/OS Certification

we provide Approved IBM C2090-320 real exam which are the best for clearing C2090-320 test, and to get certified by IBM DB2 11 Fundamentals for z/OS. The C2090-320 Questions & Answers covers all the knowledge points of the real C2090-320 exam. Crack your IBM C2090-320 Exam with latest dumps, guaranteed!

Free demo questions for IBM C2090-320 Exam Dumps Below:

Page: 1 / 10

Total 124 questions Full Exam Access

Question 1

Which of the following is a characteristic of a stand-alone utility?

It can only be executed using JCL

It can only be executed by a user with SYSADM

It can only be executed if no other utilities are running

It can only be executed in a non-data sharing environment

Question 2

An application program is running much longer than expected. The PLAN_TABLE shows the following access path information:
ACCESSTYPE = 'R' PREFETCH = 'S'
What access path does this represent?

IN-list access

Direct row access

Dynamic prefetch access

Table space scan access

Question 3

Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?

ISOLATION(UR)

ISOLATION(RS)

ISOLATION(CS)CURRENTDATA(NO)

ISOLATION(CS)CURRENTDATA(YES)

Question 4

Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

Declaring a cursor

Using the WHENEVER statement

Using DCLGEN to produce declarations for tables

Dynamically executing a statement with parameter markers

Question 5

What is the result XQuery FLWOR expression when running the following scenario?
C2090-320 dumps exhibit

Joe Smith

<name> Joe Smith </name>

<employeeinfo><name> Joe Smith </name></employeeinfo>

<name> Joe Smith </name><department name>DB2</department name>

Question 6

Which two of the following functions are synonyms of one another? (Choose two)

CLOB

VALUE

IFNULL

DBCLOB

COALESCE

Question 7

Which of the following statements about a table with a LOB column is TRUE?

It doesn’t need an auxiliary table if it has an inline LOB

It must also have a ROWID column and an auxiliary table

It doesn’t need a ROWID column (implicit or explicit) if a LOB locator will be used

It must be in a partitioned by growth (PBG) universal table space with a ROWID column

Question 8

A summary table can be easily maintained using which of the following?

An auxiliary table

A partitioned table

A bi-temporal table

A materialized query table

Question 9

Which job generates the subsystem parameter module?

DSNTIJIN

DSNTIJJP

DSNTIJUZ

DSNTIJEN

Question 10

We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries(SALARY) for each of them. Which single SQL statement will do this?
C2090-320 dumps exhibit

Question 11

While DSN is running, which of the following commands CANNOT be successfully executed?

–STOP DB2

–START DB2

–TERM UTILITY

–DISPLAY UTILITY

Question 12

You want to limit the access of a table to allow users to only see certain columns and/or rows. Which of the following options CANNOT be used to accomplish this?

A view

Multilevel security

An MQT (Materialized Query Table)

A combination of row permissions and column masks

Question 13

Which SQL statement supports an insert or an update in a single SQL statement?

MERGE

UPSERT

UPDATE or INSERT INTO....

INSERT INTO table... ON DUPLICATE KEY ....

Question 14

Consider the following question: “What is the average salary by sex within education level?” An occasional uncommitted record can be tolerated in the average. Which of the following is the most appropriate isolation level for this?

Question 15

Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL(NONE)?

LOB

Simple

Partition-by-range

Partition-by-growth

Question 16

The following warning message is issued when the last available active log data set is 5% full: DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL
What will happen if you ignore this message?

DB2 will shut down if it reaches the 100 % full condition

DB2 will overwrite the oldest archive log without archiving

DB2 will stop any activity that requires log writes if it reaches the 100 % full condition

DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them

Question 17

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

Child key

Collation key

Parent key

Secondary key

Question 18

Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for all employees from the EMP table.
A)
C2090-320 dumps exhibit

Option A

Option B

Option C

Option D

Question 19

Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is "DROP INDEX AAA". Which of the following statements must precede th$ DROP statement so that it drops the index?

SET CURRENT PATH = \'DB2\';

SET CURRENT RULES = \'DB2\';

No preceding statement is needed

SET CURRENT SCHEMA = \'DB2\':

Question 20

A view is considered read only if which of the following is TRUE?

The first EROM clause identifies only one table

The outer fullselect contains an ORDER BY clause

The first SELECT clause specifies the DISTINCT option

The fullselect includes a column of a base table that is defined as implicitly hidden

Question 21

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

Question 22

Which of the following SELECT statements returns a different data value than the other SQL statements ?

SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENTTIMESTAMP(10))l6l2)t,0\')l11l") FROM SYSIBM.SYSDUMMY1;

SELECT TIMESTAMPDIFF(64. CHAR( CURRENT TIMESTAMP - TIMESTAMP(\'2016-01-01-00.00.00\'))) FROM SYSIBM.SYSDUMMY1;

Question 23

Which BIND option determines when DB2 will do authorization checking?

DEFER

DEPLOY

VALIDATE

CURRENTDATA

Question 24

How can a stored procedure be invoked?

Via an SQL SELECT statement

Via a CALL statement using SPUFI

Directly via a RUN PROGRAM command

Via a CALL statement from within an application program

Page: 1 / 10

Total 124 questions Full Exam Access