Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

IBM C2090-611 Exam - DB2 10.1 DBA for Linux, UNIX, and Windows

Questions & Answers for IBM C2090-611

Showing 1-15 of 116 Questions

Question #1 - Topic 1

Which command is used to export connectivity configuration information from a file known
as a configuration profile?

A. db2ca

B. db2cfexp

C. db2cfimp

D. db2cfgexp

Question #2 - Topic 1

Which two server authentication methods are supported by transparent Lightweight
Directory Access Protocol (LDAP)? (Choose two.)

A. CLIENT

B. SERVER

C. LDAP_PLUGIN

D. DATA_ENCRYPT

E. KERBEROS_PLUGIN

Question #3 - Topic 1

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 dropped table.

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 with the 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 DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

Question #4 - Topic 1

Which statement is true regarding client-server database connectivity?

A. A remote connection uses Interprocess Communication (IPC).

B. A loopback connection can be made with either the APPC or TCP/IP protocol enabled.

C. A remote connection is established between a DB2 client in a different location from the database server.

D. A DB2 client running a lower version of DB2 can establish a local connection to a server running on a newer version.

Question #5 - Topic 1

You have an High Availability and Disaster Recovery (HADR) environment set up and
youwant to read from the standby database. What must you do?

A. Assign the value ON to the DB2_HADR_ROS registry variable.

B. Assign the value ON to the DB2_HADR_SNAP registry variable.

C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.

D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.

Question #6 - Topic 1

If the following statement is executed:

What indexes will be created for table TAB1?

A. 1dimension-block index and 1 composite-block index

B. 1 dimension-block index and 3 composite-block indexes

C. 3 dimension-block indexes and 1 composite-block index

D. 3 dimension-block indexes and 3 composite-block indexes

Question #7 - Topic 1

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

Question #8 - Topic 1

Which command will define the alternate diagnostic data directory path as
/db2data/db2dump2?

A. db2set ALT_DIAGPATH=/db2data/db2dump2

B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2

C. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

D. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Question #9 - Topic 1

Given a system-period temporal table POLICY_INFO withits associated history table
HIST_POLICY_INFO, which statement is true?

A. When querying with a time period specification, only the HIST_POLICY_INFO table is queried.

B. When querying with no time period specification, only the HIST_POLICY_INFO table isqueried.

C. When querying with a time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

D. When querying with no time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

Question #10 - Topic 1

What authorization is needed to execute the CREATE MASK statement?

A. SECADM

B. SQLADM

C. SYSADM

D. SYSCTRL

Question #11 - Topic 1

Which statement about Binary XML is FALSE?

A. Binary XML format is only used for datatransmission.

B. Binary XML data refers to data that is in the XDBX format.

C. Only textual XML data format is supported by Binary XML.

D. The binary format provides a faster way to transmit and receive XML data.

Question #12 - Topic 1

Which statement regarding SECADM authority is true?

A. The instance owner has SECADM authority by default.

B. PUBLIC cannot receive SECADM authority, either directly or indirectly.

C. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.

D. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.

Question #13 - Topic 1

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

A. Job Console

B. Job Manager

C. Task Manager

D. Utilities Console

Question #14 - Topic 1

Which statement about the ADMIN_MOVE_TABLE procedureis true?

A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operation to the target table.

B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active(source) table during the move to a user-supplied staging table so they can be replayed against the target table when the move is complete.

C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, the target table is renamed (to the source table name) once the data has been copied into the target table.

D. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if thetarget table is to be created automatically, a name that is different from that of the active table must be specified for the target table.

Question #15 - Topic 1

Which statement describes a way to minimize the impact of a RUNSTATS operation?

A. Reduce I/O by using a shadow table space for statistics collection.

B. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.

C. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.

D. Limit the number of pages and rows processed by using page-level or row-level table sampling.

You Need Avanset VCE Player in Order to Open VCE Files

AUTUMN SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

AUTUMN SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@exam-labs.com and follow the directions.