C2090-320 | how many questions of C2090-320 dumps?

New Questions 2

Which of the following is TRUE for using LOAD on a partition-by-growth table space?

A. Data can only be loaded at the partition level

B. Data can only be loaded at the table space level

C. Data can only be loaded using a clustering index

D. Data can be loaded at either the table space level or the partition level

Answer: A

New Questions 3

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

A. A view

B. A temporal table

C. A created global temporary table

D. A declared global temporary table

Answer: B

New Questions 4

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?

A.

B.

C.

D.

Answer: D

New Questions 5

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

A. TRUNCATE employee;

B. DELETE FROM employee;

C. DELETE FROM employee WHEREu2026;

D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

Answer: B

New Questions 6

Which of the following statements concerning a bi-temporal table is TRUE?

A. It provides business history, but is not useful for audit purposes

B. It is defined with both an application period and a system period

C. It is useful for audit purposes, but is not useful for business history

D. It contains data reflecting two different times u2013 current time and one previous time

Answer: B

New Questions 7

In which address space would a native SQL stored procedure run?

A. WLM

B. DIST

C. DBM1

D. The address space of the calling program

Answer: C

New Questions 8

Which component of the program preparation produces a DBRM (Database request Module)?

A. Compiler

B. Linkage Editor

C. Bind command

D. Precompiler/Coprocessor

Answer: D

New Questions 9

Given the following table and index definitions, what type of index will be created?

A. Non-partitioned index

B. Non-partitioned secondary index

C. Data-partitioned secondary index

D. Data-partitioned partitioning index

Answer: C

New Questions 10

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

A. It can only be executed using JCL

B. It can only be executed by a user with SYSADM

C. It can only be executed if no other utilities are running

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

Answer: A

New Questions 11

Which of the following elements is affected by a ROLLBACK statement?

A. LOB table spaces

B. Changes in cursor positioning

C. Acquisition and release of locks

D. Caching of rolled back statements

Answer: A