VCEdump

C2090-611 DB2 10.1 DBA for Linux UNIX and Windows

PDF question preview Back to product

Reading controls

Reader tools

Free demo

18 of 118 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice17

Multiple choice1

IBM · C2090-611

Free C2090-611 Exam Dumps Preview

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

Question 1

Single choice

What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

A
Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore
the database and recover the droppedtable.
B
Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore
the appropriate table space and recover thedropped table.
C
Restore the database from a backup image that was taken before the table was dropped; run the
ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE option to restore the
database and recover the dropped table.
D
Restore the appropriate table space from a backup image that was taken before the table was
dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE
option to restore the appropriate table space and recover the dropped table.

Reveal answer details Close answer details

Correct answerD

Question 2

Single choice

In IBM Data Studio, where can you schedule script-based jobs?

A
Job Console
B
Job Manager
C
Task Manager
D
Utilities Console

Reveal answer details Close answer details

Correct answerB

Question 3

Single choice

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

A
NLJOIN
B
HSJOIN
C
IXSCAN
D
TBSCAN

Reveal answer details Close answer details

Correct answerC

Question 4

Single choice

Which statement regarding compression for temporary tables is true?

A
Temporary tables can only be compressed using adaptive compression.
B
Temporary tables can only be compressed using classic row compression.
C
Compression for temporary tables can be dynamically enabled and disabled.
D
The DB2 optimizer automatically decides to use classic row compression or adaptive compression for
temporary tables.

Reveal answer details Close answer details

Correct answerB

Question 5

Single choice

What type of Label-Based Access Control (LBAC) security label component is used to define a scale in which the first element listed represents the highest level of trust a person can have and the last element listed represents the lowest level of trust a person can have?

A
Set
B
Array
C
Tree
D
Range

Reveal answer details Close answer details

Correct answerB

Question 6

Single choice

A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO

What is the recommended way to convert the database MYDB to an automatic storage database?

A
Use the ALTER DATABASE statement to add storage paths to the database.
B
Use the CREATE STOGROUP statement to define a new storage group in the database and to assign
storage paths to the new storage group.
C
Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE
configuration parameter for the database toYES.
D
Use the DROP DATABASE command to drop the database; then, recreate the database by executing
a CREATE DATABASE commandstatement that does not contain the AUTOMATIC STORAGE NO
option.

Reveal answer details Close answer details

Correct answerB

Question 7

Single choice

If an MQT named Q1_SALES was created as follows:

Which statement will execute successfully?

A
DELETE FROM q1_sales
B
REFRESH TABLE q1_sales
C
INSERT INTO q1_sales VALUES(80.2)
D
ALTER TABLE q1_sales REFRESH IMMEDIATE

Reveal answer details Close answer details

Correct answerB

Question 8

Single choice

Given the following statement:

How many constraints are present in the DEPARTMENT table?

Reveal answer details Close answer details

Correct answerD

Question 9

Single choice

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

A
To terminate a failed INGEST command.
B
To restart a failed INGEST command from the beginning.
C
To clean up the log records of a failed INGEST command.
D
To restart a failed INGEST command from the last commit point.

Reveal answer details Close answer details

Correct answerD

Question 10

Multiple choice

What are two types of DB2 Discovery requests that a client can make? (Choose two.)

A
KNOWN
B
SEARCH
C
LOOKUP
D
TRUSTED
E
UNTRUSTED

Reveal answer details Close answer details

Correct answersA, B

Question 11

Single choice

Which command will enable automatic reorg on a database?

A
UPDATE DB CFG USING AUTO_REORG ON
B
UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON
C
UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON
D
UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON

Reveal answer details Close answer details

Correct answerD

Question 12

Single choice

What authorization is needed to execute the CREATE MASK statement?

A
SECADM
B
SQLADM
C
SYSADM
D
SYSCTRL

Reveal answer details Close answer details

Correct answerA

Question 13

Single choice

Which is a valid statement about the Row and Column Access Control (RCAC) feature?

A
Users with SECADM authority are exempt from RCAC rules.
B
The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.
C
RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).
D
When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are
returned.

Reveal answer details Close answer details

Correct answerD

Question 14

Single choice

Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

A
INGEST
B
REPLICATION
C
LOAD WITH READ ACCESS
D
IMPORT WITH BUFFERED INSERT

Reveal answer details Close answer details

Correct answerA

Question 15

Single choice

Which command can be used to restore a corrupted database using only the recovery history file?

A
RESTART DATABASE
B
RECOVER DATABASE
C
RESTORE DATABASE
D
ROLLFORWARD DATABASE

Reveal answer details Close answer details

Correct answerB

Question 16

Single choice

Which statement is NOT true about a database restore operation?

A
A table space restore operation must be done offline.
B
A table space is not usable until the restore operation completes successfully.
C
A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice
versa.
D
A database restore operation requires an exclusive connection. No applications can run against the
database while the operation is inprogress.

Reveal answer details Close answer details

Correct answerA

Question 17

Single choice

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL

What will happen?

A
RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
B
RUNSTATS will be executed on all user and system tables and a REORGCHK report will be
generated.
C
RUNSTATS will be executed on all user tables only if statistics have not been collected and a
REORGCHK report will be generated.
D
RUNSTATS will be executed on all system tables only if statistics have not been collected and a
REORGCHK report will be generated.

Reveal answer details Close answer details

Correct answerB

Question 18

Single choice

When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

A
They are automatically dropped.
B
They are marked as "Move Pending."
C
They are marked as "Dropped Pending."
D
They are automatically moved to the new table space.

Reveal answer details Close answer details

Correct answerC

Free C2090-611 Exam Dumps Preview

DB2 10.1 DBA for Linux UNIX and Windows

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

VOL	TYPE	QUESTIONS
1	Single choice	17
2	Multiple choice	1