VCEdump

C2090-616 DB2 11.1 Fundamentals for LUW

PDF question preview Back to product

Reading controls

Reader tools

Free demo

10 of 62 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice8

Multiple choice2

IBM · C2090-616

Free C2090-616 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

Which of the following is TRUE about indexes on column organized tables?

A
No indexes are allowed
B
Indexes are only allowed on numeric columns
C
Indexes are automatically created to enforce unique constraints
D
An index is only allowed on the synopsis table supporting a column organized table

Reveal answer details Close answer details

Correct answerA

Question 2

Single choice

What type of function is created using the following command?

CREATE FUNCTION TAN (X DOUBLE)

RETURNS DOUBLE

LANGUAGE SQL

CONTAINS SQL

NO EXTERNAL ACTION

DETERMINISTIC

RETURN SIN(X)/COS(X)

A
Row
B
Table
C
Scalar
D
External

Reveal answer details Close answer details

Correct answerC

Question 3

Single choice

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

A
Concurrency may be improved
B
Lock escalation will be prevented
C
Query performance will be reduced
D
The number of locks for the same workload will be reduced

Reveal answer details Close answer details

Correct answerA

Question 4

Single choice

Which three facilities are used to control authorization in DB2?

A
privileges, db2ssh, LBAC credentials
B
privileges, authority levels, certificates
C
db2ssh, trusted contexts, authority levels
D
privileges, authority levels, LBAC credentials

Reveal answer details Close answer details

Correct answerD

Question 5

Single choice

A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns.

What could you use to derive the analytic improvements offered by BLU technology in such an environment?

A
Shadow tables
B
Range-partitioned tables
C
Materialized query tables
D
Multidimensional clustering tables

Reveal answer details Close answer details

Correct answerA

Question 6

Multiple choice

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

A
Direct Standard Edition
B
Enterprise Server Edition
C
Workgroup Server Edition
D
DB2 Direct Advanced Edition
E
Advanced Enterprise Server Edition

Reveal answer details Close answer details

Correct answersB, C

Question 7

Single choice

Which of the following statements about stored procedures is TRUE?

A
Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
B
The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
C
There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
D
Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Reveal answer details Close answer details

Correct answerB

Question 8

Multiple choice

Which optional NPS compatibility features will be activated by executing the following? (Choose two.)

SET SQL_COMPAT=`NPS'

A
YEARSBETWEEN
B
BINARY and VARBINARY data types
C
Double-dot notation to specify a database object
D
OFFSET x ROWS FETCH FIRST y ROWS ONLY
E
TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Reveal answer details Close answer details

Correct answersC, E

Question 9

Single choice

Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

A
Deadlock
B
Lock timeout
C
Lock escalation
D
Lock conversion

Reveal answer details Close answer details

Correct answerA

Question 10

Single choice

Consider the following SQL statement:

SELECT workdept, empno, lastname, salary,

RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary

FROM employee

ORDER BY workdept, lastname

What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?

A
It ranks the rows in each WORKDEPT by SALARY.
B
It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY.
C
It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY.
D
It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY.

Reveal answer details Close answer details

Correct answerB

VOL	TYPE	QUESTIONS
1	Single choice	8
2	Multiple choice	2

Free C2090-616 Exam Dumps Preview

DB2 11.1 Fundamentals for LUW

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10