C2090-616 sample questions

Question 1

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)

Accepted Answer

Scalar

Answer

Row

Answer

Table

Answer

External

Question 2

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

Accepted Answer

It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Answer

A ROLLBACK command executed just after the COMMIT command cancels that COMMIT

Answer

Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command

Answer

It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT

Question 3

Which of the following statements about triggers are TRUE? (Choose two.)

Accepted Answer

Triggers can be activated as a result of changes due to referential constraint enforcement

Accepted Answer

Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers

Answer

There is a limit of 8 for the maximum number of cascading trigger activations

Answer

Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view

Answer

The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Question 4

Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

Accepted Answer

Selecting from the DUAL table

Answer

Implicit casting

Answer

Double-dot notation

Answer

Use of bitmap indexes

Question 5

Which of the following DB2 objects can be used to provide a simplified, logical representation of data from one or more tables, but does not itself permanently store data?

graph TD subgraph Database T1[Table: EMPLOYEES] T2[Table: DEPARTMENTS] V1{View: EMP_DEPT_VIEW} end T1 -- join --> V1 T2 -- join --> V1 User[User] -->|SELECT * FROM| V1

Accepted Answer

View

Answer

Table

Answer

Alias

Answer

Materialized Query Table (MQT)

Question 6

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

Accepted Answer

Primary key

Answer

NOT NULL

Answer

Foreign key

Answer

Informational constraint

Question 7

Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations.

Which of the following Cloud offerings best suits your needs?

Accepted Answer

DB2 on Cloud

Answer

Cloudant

Answer

dashDB for analytics

Answer

dashDB for transactions

Question 8

Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?

Accepted Answer

DB2 pureScale

Answer

DB2HADR

Answer

DB2 Express-C

Answer

DS2 Database Partitioning Feature

Question 9

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

Accepted Answer

Management of very large data sets

Accepted Answer

Faster response time of long-running or complex queries with I/O spread across many computers

Answer

Easy scalability

Answer

Continuously available dataset solution

Answer

Increased throughput of many concurrent short running queries

Question 10

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?

Accepted Answer

it groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY

Answer

it ranks the rows in each WORKDEPT by SALARY

Answer

it generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY

Answer

it tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY

C2090-616 DB2 11.1 Fundamentals for LUW Practice Questions

Create an account to continue.

Create an account to continue.

Related exams