Assessment: Informix 11.50 Application Developer (A2090-556) Free Practice Test

Question 1

Which statement about Dirty Read (Read Uncommited) isolation levels is correct?

A. It does not check whether there is any lock on the required rows.

B. It prevents the phantom read phenomenon.

C. It does not place a lock on the row that it is reading, but does check if any lock is placed on them.

D. It places a shared lock on the row that is being read and releases it when the next row is locked.

Correct Answer: A

Question 2

Which of the following data types is not based on built-in data types?

A. Distinct types

B. Named row types

C. Row types

D. Opaque types

Correct Answer: D

Question 3

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 stored with the table data.

B. The BLOB is inserted into a system default SBSPACE defined with SBSPACENAME onconfig parameter.

C. The CREATE TABLE statement fails with syntax error.

D. The BLOB is inserted into an operating system file on the server.

Correct Answer: B

Question 4

Which of the following data types can be directly cast to a DATE type?

A. DATETIME

B. SMALLINT

C. DECIMAL

D. SMALLFLOAT

Correct Answer: B

Question 5

Which of the following data types can be directly cast to a DATE type?

A. DATETIME

B. SMALLINT

C. DECIMAL

D. SMALLFLOAT

Correct Answer: B

Question 6

What are all the possible table level privileges granted to user John on table ACCOUNT after the following statement is executed?
GRANT ALL ON ACCOUNT TO JOHN;

A. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, DROP

B. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, RENAME

C. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, UNDER

D. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, RENAME, DROP

Correct Answer: C

Question 7

What does the TRACE PROCEDURE statement do when debugging stored procedures?

A. Activates the TRACE statements embedded in the stored procedure.

B. Traces the routine calls and return values, and every parsed statement in the stored procedure.

C. Traces the routine calls and return values, but not the body of the stored procedure.

D. Traces the routine calls and return values, automatically setting the debug file to the name of the stored procedure.

Correct Answer: C

Welcome to TestSimulate

IBM Assessment: Informix 11.50 Application Developer (A2090-556) Free Practice Test