307 お客様のコメント
質問 1：
Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?
A. GRANT ALTER ON SEQUENCE myseq TO user1
B. GRANT SELECT ON SEQUENCE myseq TO user1
C. GRANT COMMENT ON SEQUENCE myseq TO user1
D. GRANT USAGE ON SEQUENCE myseq TO user1
正解：A
質問 2：
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
A. SELECT * FROM employee WHERE salary < 100000
B. SELECT * FROM employee WHERE salary GREATER THAN 100000
C. SELECT salary FROM employee WHERE salary > 100,000.00
D. SELECT salary FROM employee WHERE salary > 100000
正解：D
質問 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 tool allows users to connect to a DB2 database using a wizard?
A. DB2 Connection Pool Manager
B. IBM Data Studio
C. Universal Connection Expert
D. Control Center
正解：B
質問 5：
Which two statements are true about foreign key constraints? (Choose two.)
A. The number and data types of foreign key constraint columns must match the parent key.
B. The foreign key constraint columns must be supported by an index.
C. To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.
D. The foreign key constraint columns must be defined as NOT NULL.
E. The columns of one foreign key constraint cannot be used in another foreign key constraint.
正解：A,C
質問 6：
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
質問 7：
If a table named MY_TAB contains 100 rows and the following statement is executed:
How many rows will be updated?
A. 0
B. 99
C. 1
D. 10
正解：D
Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?
A. GRANT ALTER ON SEQUENCE myseq TO user1
B. GRANT SELECT ON SEQUENCE myseq TO user1
C. GRANT COMMENT ON SEQUENCE myseq TO user1
D. GRANT USAGE ON SEQUENCE myseq TO user1
正解：A
質問 2：
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
A. SELECT * FROM employee WHERE salary < 100000
B. SELECT * FROM employee WHERE salary GREATER THAN 100000
C. SELECT salary FROM employee WHERE salary > 100,000.00
D. SELECT salary FROM employee WHERE salary > 100000
正解：D
質問 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 tool allows users to connect to a DB2 database using a wizard?
A. DB2 Connection Pool Manager
B. IBM Data Studio
C. Universal Connection Expert
D. Control Center
正解：B
質問 5：
Which two statements are true about foreign key constraints? (Choose two.)
A. The number and data types of foreign key constraint columns must match the parent key.
B. The foreign key constraint columns must be supported by an index.
C. To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.
D. The foreign key constraint columns must be defined as NOT NULL.
E. The columns of one foreign key constraint cannot be used in another foreign key constraint.
正解：A,C
質問 6：
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
質問 7：
If a table named MY_TAB contains 100 rows and the following statement is executed:
How many rows will be updated?
A. 0
B. 99
C. 1
D. 10
正解：D
小田** -
勉強して試験に行ったんだけど、C2090-610試験に出てくる内容のほとんどがこの問題集に収めている