IBM Assessment: DB2 10.1 Fundamentals - A2090-610 Free Exam Questions

A. SELECT dept_info(dept_id, dept_name)

B. SELECT TABLE dept_id, dept_name FROM dept_info()

C. SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

D. SELECT dept_id, dept_name FROM dept_info()

A. SALES can be the name of a declared global temporary table.

B. SALES can be the name of an existing alias.

C. SALES can be the name of a schema.

D. SALES can be the name of a package.

A. Table

B. Sequence

C. View

D. Identity Column

A. Concurrent application processes from performing any operations on the table.

B. Concurrent application processes from performing any read-only operations on the table.

C. Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.

D. Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table.

A. When you want to automatically generate a numeric value for each row that is added to a specific table.

B. When you want to automatically generate a numeric value that is not tied to any specific column or table.

C. When you want to control the order in which triggers are fired.

D. When you want to control the order in which stored procedures can be invoked.

A. Trusted context

B. Oracle connect

C. Distributed request

D. Oracle federation

A. SQL Procedure

B. Trigger

C. Sequence Object

D. Materialized Query Table

A. Control Center

B. DB2 Connection Pool Manager

C. Universal Connection Expert

D. IBM Data Studio

A. Cursor Stability (CS)

B. Read Stability (RS) with Currently Committed semantics

C. Repeatable Read (RR)

D. Cursor Stability (CS) with Currently Committed semantics

A. Exclusive (X)

B. Intent Exclusive (IX)

C. Share (S)

D. Update (U)