최신 IBM Certified Application Developer A2090-610 무료샘플문제:

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

A) Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.
B) 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.
C) 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.
D) 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.

2. If a table named MY_TAB contains 100 rows and the following statement is executed:

How many rows will be updated?

A) 1
B) 10
C) 99
D) 0

3. Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?

A) LOCK TABLE tab1 IN SHARE MODE
B) LOCK TABLE tab1 IN READ MODE
C) LOCK TABLE tab1 IN READ-ONLY MODE
D) LOCK TABLE tab1 IN EXCLUSIVE MODE

4. An SQL function named DEPT_INFO was created as follows:

What is the correct way to use this function in a query?

A) SELECT TABLE dept_id, dept_name FROM dept_info()
B) SELECT dept_id, dept_name FROM dept_info()
C) SELECT dept_info(dept_id, dept_name)
D) SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

5. When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

A) The data in the table is deleted and the table persists.
B) The temporary table is converted to a base table and the data is persistent.
C) The data in the table is deleted and the table is implicitly dropped.
D) The temporary table is converted to a base table and the data is deleted.

질문과 대답: