1177 お客様のコメント
質問 1：
When is a cursor necessary in an SQL program?
A. A cursor is necessary before an after trigger can be created.
B. A cursor is only necessary when using DISTINCT, UNIQUE, ORDER BY, GROUP BY or aggregates in SQL statements.
C. A cursor is necessary when a query returns more than one row and you wish to examine their content before an update or delete statement is executed.
D. A cursor is necessary when a query returns one row and you wish to examine its content and maybe update it or delete it.
正解：C
質問 2：
Consider the following code:
What action is undertaken if Error -210 is encountered when executing the logic above?
A. Action C followed by Action A
B. Action B
C. Action C
D. Action A followed by Action C
E. Action A
正解：C
質問 3：
Given the following SQL statements:
What is the result of the following query?
SELECT user, current, today FROM mytab;
A. The information would be the same as DBINFO(utc_user, utc_current, utc_today).
B. The current user name, the current time and the current date.
C. The query will fail because user, current and today are built-in functions.
D. josh, 11:30:30, 1/22/2008
正解：B
質問 4：
What happens if you run the following CREATE TABLE statement without the PUT clause?
CREATE TABLE EMPLOYEE
(EMP_ID INTEGER, EMP_PICTURE BLOB) PUT EMP_PICTURE IN MYSPACE1;
A. The BLOB is inserted into an operating system file on the server.
B. The BLOB is stored with the table data.
C. The BLOB is inserted into a system default SBSPACE defined with SBSPACENAME onconfig parameter.
D. The CREATE TABLE statement fails with syntax error.
正解：C
質問 5：
You wish to show a user a total balance across all of their savings and checking accounts. However, you do not want them to be blocked or to see inconsistent information if money is being transferred between their accounts at the time of the query. What isolation level would you use?
A. READ COMMITTED
B. COMMITTED READ LAST COMMITTED
C. CURSOR STABILITY LAST COMMITTED
D. REPEATABLE READ
正解：B
質問 6：
To register a new user-defined access method called my_tree for a virtual index, which of the following SQL statements must be used?
A. CREATE VIRTUAL INDEX ACCESS_METHOD my_tree
B. CREATE PRIMARY ACCESS_METHOD my_tree
C. CREATE SECONDARY ACCESS_METHOD my_tree
D. CREATE VIRTUAL TABLE ACCESS_METHOD my_tree
正解：C
When is a cursor necessary in an SQL program?
A. A cursor is necessary before an after trigger can be created.
B. A cursor is only necessary when using DISTINCT, UNIQUE, ORDER BY, GROUP BY or aggregates in SQL statements.
C. A cursor is necessary when a query returns more than one row and you wish to examine their content before an update or delete statement is executed.
D. A cursor is necessary when a query returns one row and you wish to examine its content and maybe update it or delete it.
正解：C
質問 2：
Consider the following code:
What action is undertaken if Error -210 is encountered when executing the logic above?
A. Action C followed by Action A
B. Action B
C. Action C
D. Action A followed by Action C
E. Action A
正解：C
質問 3：
Given the following SQL statements:
What is the result of the following query?
SELECT user, current, today FROM mytab;
A. The information would be the same as DBINFO(utc_user, utc_current, utc_today).
B. The current user name, the current time and the current date.
C. The query will fail because user, current and today are built-in functions.
D. josh, 11:30:30, 1/22/2008
正解：B
質問 4：
What happens if you run the following CREATE TABLE statement without the PUT clause?
CREATE TABLE EMPLOYEE
(EMP_ID INTEGER, EMP_PICTURE BLOB) PUT EMP_PICTURE IN MYSPACE1;
A. The BLOB is inserted into an operating system file on the server.
B. The BLOB is stored with the table data.
C. The BLOB is inserted into a system default SBSPACE defined with SBSPACENAME onconfig parameter.
D. The CREATE TABLE statement fails with syntax error.
正解：C
質問 5：
You wish to show a user a total balance across all of their savings and checking accounts. However, you do not want them to be blocked or to see inconsistent information if money is being transferred between their accounts at the time of the query. What isolation level would you use?
A. READ COMMITTED
B. COMMITTED READ LAST COMMITTED
C. CURSOR STABILITY LAST COMMITTED
D. REPEATABLE READ
正解：B
質問 6：
To register a new user-defined access method called my_tree for a virtual index, which of the following SQL statements must be used?
A. CREATE VIRTUAL INDEX ACCESS_METHOD my_tree
B. CREATE PRIMARY ACCESS_METHOD my_tree
C. CREATE SECONDARY ACCESS_METHOD my_tree
D. CREATE VIRTUAL TABLE ACCESS_METHOD my_tree
正解：C
Aoki -
C2090-556試験対策のテキストです。
豊富な補足解説が理解を深める