Exam Code: C2090-611 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10.1 DBA for Linux, UNIX, and Windows
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-611 Exam.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-611 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-611 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-611-exam-dumps.html

Q31. Which authority is required to revoke SECADM authority?

A. DBADM

B. SECADM

C. SYSADM

D. SQLADM

Answer: B


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

A. Job Console

B. Job Manager

C. Task Manager

D. Utilities Console

Answer: B


Q33. When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?

A. After a SET INTEGRITY statement is executed.

B. After a truncate table operation is performed in the background.

C. Immediately after the ALTER TABLE DETACH statement is executed.

D. Immediately after asynchronous partition detach processing completes for this data partition.

Answer: D


Q34. What can be used to provide input to the Design Advisor?

A. An XML file.

B. A query workload file.

C. The database configuration file.

D. The database manager configuration file.

Answer: B


Q35. 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.

Answer: D


Q36. Which registry variable is used to enable transparent Lightweight Directory Access Protocol

(LDAP)?

A. DB2LDAP

B. DB2AUTH

C. CLNT_PW_PLUGIN

D. SRVCON_PW_PLUGIN

Answer: B


Q37. 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

Answer: B,D


Q38. 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.

Answer: C


Q39. Which statement about triggers is FALSE?

A. A statement-level trigger fires only once for each SQL statement.

B. A trigger's code block can be executed either before or after a triggering event.

C. A row-level trigger fires once for each row that is affected by a triggering event.

D. A table-level trigger fires once for each table that is affected by a triggering event.

Answer: D


Q40. Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?

A. SYNC (synchronous)

B. ASYNC (asynchronous)

C. NEARSYNC (near synchronous)

D. SUPERASYNC (super asynchronous)

Answer: D