IBM C2090-556 問題集

質問 1：
Which statement is NOT a characteristic of a sequence?
A. It has a lower level of concurrency than a serial column.
B. It specifies a negative value.
C. Rolling back a generated value is not allowed.
D. It specifies an initial value.
正解：A

質問 2：
What isolation level prevents other users from changing any of the rows that are examined by your query?
A. Committed Read
B. Cursor Stability
C. Dirty Read
D. Repeatable Read
正解：D

質問 3：
For what is the DBINFO function below used?
DBINFO('sqlca.sqlerrd2')
A. Returns the last SQL error code.
B. Returns the number of rows processed.
C. Returns the last serial number inserted.
D. Returns the last ISAM error code.
正解：B

質問 4：
What is the name of the SQL function that needs to be used in place of SQL_FUNCTION in the INSERT statement given below?
CREATE TABLE EMPLOYEE (EMP_ID INTEGER, EMP_PICTURE BLOB)
PUT EMP_PICTURE IN MYSPACE1; INSERT INTO EMPLOYEE VALUES (1001, SQL_FUNCTION('emppicture.jpg', 'client'));
A. FILETOBLOB
B. TOBLOB
C. BLOBCOPY
D. LOBCOPY
正解：A

質問 5：
Which statement describes the distributed query capabilities of Informix?
A. Queries can span a maximum of six (6) Informix databases on a single host server only.
B. Queries can span a maximum of six (6) Informix databases on multiple host servers.
C. Queries can span an unlimited number of Informix databases on a single host server.
D. Queries can span an unlimited number of Informix databases on multiple host servers.
正解：D

質問 6：
What are the different types of trigger actions supported by Informix Server?
A. Insert, update and delete triggers only.
B. Update and delete triggers only.
C. Insert, update, delete and select triggers.
D. Insert and update triggers only.
正解：C

質問 7：
Given the attached exhibit, what value does Mary see for their savings account?
A. 0
B. -100
C. 200
D. 100
正解：D

質問 8：
Pamela has decided to fragment a large table containing binary objects to optimize performance. Which of the following statements about data placement is NOT true?
A. It is possible to fragment a table across multiple dbspaces.
B. Simple binary large objects can reside within the table or can be placed into only a single blobspace.
C. Smart large objects can only be placed within a single sbspace.
D. It is possible to fragment a table within a single dbspace.
正解：C

質問 9：
Given the following table structure and triggers:

In what order will the triggers fire if you execute the following statement?
UPDATE item SET (itemno, stockcode) = (99, 9999999);
A. You cannot predict the firing order.
B. The triggers will fire simultaneously.
C. Trigger itm_trg1 will fire first, as it includes the first column in the table.
D. Trigger itm_trg2 will fire first, as it includes the first column out of those touched.
正解：C