最新なIBM A2090-610問題集（138題）、真実試験の問題を全部にカバー！

質問 1：
When is an INTENT EXCLUSIVE (IX) lock required?
A. When a transaction intends to read but not change data.
B. When a transaction intends to change but not read data.
C. When a transaction intends to read or change data.
D. When a transaction intends to change the system catalog.
正解：C

質問 2：
Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?
A. SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id
B. SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id
C. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id
D. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id
正解：B

質問 3：
The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?
A. Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.
B. Concurrent application processes from performing any read-only operations on the table.
C. Concurrent application processes from performing any operations on the table.
D. Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table.
正解：C

質問 4：
Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?
A. SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2
B. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2
C. SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2
D. SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2
正解：A

質問 5：
If no isolation level is specified, what is the default isolation level used?
A. Cursor Stability (CS) with Currently Committed semantics
B. Repeatable Read (RR)
C. Cursor Stability (CS)
D. Read Stability (RS) with Currently Committed semantics
正解：C

質問 6：
When a COMMIT statement is executed, what happens?
A. All locks held on the database are automatically released.
B. Open cursors defined WITH HOLD are closed, but their data is retained.
C. Data stored in global temporary tables is automatically deleted.
D. The current transaction is terminated and a new transaction boundary is started.
正解：D

質問 7：
Which object can be enabled for compression?
A. View
B. Temporary table
C. Storage group
D. Buffer pool
正解：B