最新的IBM C2090-610免費考試真題

問題1

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)

正確答案: D

問題2

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

A. Lock escalation

B. Lock promotion

C. Lock conversion

D. Lock exchange

正確答案: A

問題3

Which object can be enabled for compression?

A. Storage group

B. Buffer pool

C. View

D. Temporary table

正確答案: D

問題4

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

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

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

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

D. Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.

正確答案: B

問題5

In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

A. Locked

B. Pending

C. Waiting

D. Unconnected

正確答案: D

問題6

A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?

A. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

B. SELECT name, COUNT(*) AS transactions FROM sales

C. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

D. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

正確答案: D

問題7

After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?

A. REBIND

B. BIND

C. BIND_REBIND

D. BINDADD

正確答案: B

問題8

Which platform supports DB2 pureScale environments?

A. AIX

B. Windows

C. z/OS

D. iOS

正確答案: A

問題9

What is the minimum product required for DB2 connectivity across all platforms?

A. DB2 Personal Edition

B. DB2 Development Edition

C. DB2 Development Unlimited Edition

D. DB2 Connect Personal Edition

正確答案: D

問題10

What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?

A. Trusted context

B. Oracle connect

C. Distributed request

D. Oracle federation

正確答案: C

最新的IBM DB2 10.1 Fundamentals - C2090-610免費考試真題

聯系我們

站內鏈接

最新更新