What statement describes the logging restriction that applies to distributed queries?
A. Participating databases must have unbuffered logging.
B. Participating databases must be ANSI-compliant.
C. Participating databases must have buffered logging.
D. Participating database must have identical transaction logging types.
正解:D
質問 2:
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
質問 3:
Which of the following is NOT a valid loop construct in Stored Procedure Language?
A. FOR ... END FOR
B. WHILE ... END WHILE
C. LOOP ... END LOOP
D. REPEAT ... END REPEAT
正解:D
質問 4:
A user opens a transaction. In that transaction, a cursor is opened to fetch multiple rows for read access. Another transaction is opened and that connection attempts to modify some rows that the first transaction is examining. Which isolation level will ensure that the rows the first transaction examines remain the same?
A. DIRTY READ
B. CURSOR STABILITY
C. COMMITTED READ
D. REPEATABLE READ
正解:D
質問 5:
A distinct user defined data type called "dollar" is created as follows:
CREATE DISTINCT TYPE dollar AS DOUBLE PRECISION;
When can you convert it to its base data type double precision?
A. When a cast function exists between these two types.
B. As long as no conversion rate is required.
C. It may always be converted to its base data type.
D. Only when the ALLOW_BASE_CAST attribute is used when creating the type.
正解:A
質問 6:
In an ANSI compliant database, what value of SQLCODE indicates a successful query that returned no rows?
A. 100
B. -330
C. -1
D. -201
正解:A
武部** -
このC2090-556問題集のみの勉強、ひと月半ほどの勉強で一発合格できました。私はアルゴリズムという言葉の意味すらわからない初心者でしたが、この本のみ、勉強時間は会社の往復の電車の中、アプリバージョンで、平日1時間ちょいでした。