VCEdump

C2090-610 DB2 10.1 Fundamentals

PDF question preview Back to product

Reading controls

Reader tools

Free demo

21 of 138 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice20

Multiple choice1

IBM · C2090-610

Free C2090-610 Exam Dumps Preview

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

Question 1

Single choice

Which operation normally does NOT require an exclusive lock?

A
BIND
B
DROP
C
GRANT
D
SELECT

Reveal answer details Close answer details

Correct answerD

Question 2

Single choice

Which object is a stored procedure defined into?

A
Table
B
Schema
C
Package
D
Database

Reveal answer details Close answer details

Correct answerB

Question 3

Single choice

Which tool allows users to connect to a DB2 database using a wizard?

A
Control Center
B
IBM Data Studio
C
Universal Connection Expert
D
DB2 Connection Pool Manager

Reveal answer details Close answer details

Correct answerB

Question 4

Single choice

If no isolation level is specified, what is the default isolation level used?

A
Cursor Stability (CS)
B
Repeatable Read (RR)
C
Read Stability (RS) with Currently Committed semantics
D
Cursor Stability (CS) with Currently Committed semantics

Reveal answer details Close answer details

Correct answerA

Question 5

Single choice

What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?

A
Trigger
B
Procedure
C
Table function
D
Scalar function

Reveal answer details Close answer details

Correct answerA

Question 6

Single choice

What privilege is required to create a view on a table that you are not the owner of?

A
INSERT
B
SELECT
C
CREATE
D
TRIGGER

Reveal answer details Close answer details

Correct answerB

Question 7

Single choice

When is it appropriate to use a sequence?

A
When you want to control the order in which triggers are fired.
B
When you want to control the order in which stored procedures can be invoked.
C
When you want to automatically generate a numeric value that is not tied to any specific column or
table.
D
When you want to automatically generate a numeric value for each row that is added to a specific
table.

Reveal answer details Close answer details

Correct answerC

Question 8

Single choice

Which DB2 product is NOT suitable for very large data warehouse applications?

A
DB2 for i
B
DB2 for AIX
C
DB2 for z/OS
D
DB2 for Linux

Reveal answer details Close answer details

Correct answerA

Question 9

Single choice

Which command will delete all rows from a table without generating log records?

A
TRIM
B
DROP
C
DELETE
D
TRUNCATE

Reveal answer details Close answer details

Correct answerD

Question 10

Single choice

What is the purpose of the Query Tuner?

A
To automatically capture and stop rogue queries.
B
To provide recommendations and analysis for tuning a single query.
C
To provide recommendations and analysis for tuning up to 100 queries.
D
To recommend indexes and to guide DBAs through the process of creating new indexes.

Reveal answer details Close answer details

Correct answerB

Question 11

Single choice

If a table named MY_TAB contains 100 rows and the following statement is executed:

What will happen?

A
The last 5 rows in the table will be deleted.
B
The first 5 rows in the table will be deleted.
C
The statement will fail because a subquery cannot be used with a DELETE statement.
D
The statement will fail because a table name was not specified with the DELETE statement.

Reveal answer details Close answer details

Correct answerA

Question 12

Single choice

Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level.

Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

A
Read Stability (RS)
B
Cursor Stability (CS)
C
Repeatable Read (RR)
D
Uncommitted Read (UR)

Reveal answer details Close answer details

Correct answerD

Question 13

Single choice

Which object is used to cache table and index data as it is read from disk?

A
Database
B
Buffer pool
C
Table space
D
Package cache

Reveal answer details Close answer details

Correct answerB

Question 14

Single choice

When is an INTENT EXCLUSIVE (IX) lock required?

A
When a transaction intends to read or change data.
B
When a transaction intends to change but not read data.
C
When a transaction intends to read but not change data.
D
When a transaction intends to change the system catalog.

Reveal answer details Close answer details

Correct answerA

Question 15

Single choice

Which statement about INSERT operations is true?

A
The INSERT statement is used to insert rows into a table, view, or table function.
B
Inserted values must satisfy the conditions of any check constraints defined on the table.
C
If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.
D
If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.

Reveal answer details Close answer details

Correct answerB

Question 16

Single choice

User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks.

What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

A
DBADM
B
DBCTRL
C
SECADM
D
DBMAINT

Reveal answer details Close answer details

Correct answerC

Question 17

Multiple choice

Which two activities indicate the need for a data warehouse? (Choose two.)

A
Confirm product inventory.
B
Monitor product availability.
C
Summarize sales by region.
D
Identify patterns for products sold in the last five years.
E
Associate one or more products with a purchase order.

Reveal answer details Close answer details

Correct answersC, D

Question 18

Single choice

Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

A
BIGINT
B
BINARY
C
DOUBLE
D
DECIMAL

Reveal answer details Close answer details

Correct answerD

Question 19

Single choice

If a table named MY_TAB contains 100 rows and the following statement is executed:

How many rows will be updated?

A
0
B
1
C
10
D
99

Reveal answer details Close answer details

Correct answerC

Question 20

Single choice

Which action needs to be performed in order to complete the definition of an application-period temporal table?

A
A transaction-start-id column must be defined for the table.
B
A history table must be defined and associated with the base table.
C
A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
D
A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.

Reveal answer details Close answer details

Correct answerC

Question 21

Single choice

What needs to be defined in order to track changes made to a system-period temporal table over time?

A
Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.
B
A history table must be created with identical columns to the base table and a unique index must be
defined on the transaction-start-id column.
C
A history table must be created as a clone table of the base table after the row-begin, row-end, and
transaction-start-id columns have beendefined.
D
A history table must be created with identical columns to the base table and then the base table altered
with the ADD VERSIONING clause torelate it to the history table.

Reveal answer details Close answer details

Correct answerD

Free C2090-610 Exam Dumps Preview

DB2 10.1 Fundamentals

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15

QUESTION 16

QUESTION 17

QUESTION 18

QUESTION 19

QUESTION 20

QUESTION 21

VOL	TYPE	QUESTIONS
1	Single choice	20
2	Multiple choice	1