Assessment: Informix 11.50 Application Developer

Question 1

When user "ABC" attempts to use a view, the database server tests for which of the following privileges?

A. The privileges granted to "ABC" to access the underlying tables and not the view.

B. The privileges granted to "ABC" for the view and the underlying tables.

C. The privileges granted to "ABC" for the view and not the underlying tables.

D. The privileges not granted to "ABC" for the view and the underlying tables.

Correct Answer: C

Question 2

Casts can be created for which two of the following? (Choose two.)

A. BLOB data types

B. Unnamed row types

C. TEXT data types

D. Named row types

E. DISTINCT data types

Correct Answer: D,E

Question 3

William needs to create a table with a BYTE column which must be populated. Which of the following CREATE TABLE clauses can be used to ensure that the BYTE column contains a value?

A. It is not possible to ensure that a BYTE column is populated.

B. CHECK (IS NOT NULL)

C. NOT NULL

D. OF TYPE

Correct Answer: B

Question 4

Assuming you have an employee table that stores the salary for each employee. What will this query return?
SELECT AVG(salary), STDEV(salary) FROM employees;

A. Average salary and standard deviation for all rows not containing NULL salaries.

B. Average salary and standard deviation for all rows.

C. Average salary and standard deviation for all rows assuming the average value for NULL salaries.

D. Average salary and standard deviation for all rows assuming zero for NULL salaries.

Correct Answer: A

Question 5

Which statement describes a select cursor?

A. It is used when you associate an EXECUTE FUNCTION statement with a cursor.

B. It is a cursor that uses the FETCH option to retrieve successive rows of data from another cursor.

C. It is the representation of columns or values that a user-defined function returns after a SELECT statement.

D. It is a data structure that represents the active set of rows that the SELECT statement retrieved.

Correct Answer: D

Question 6

Which two statements are correct about privileges? (Choose two.)

A. RESOURCE privilege has all the capabilities of a CONNECT privilege.

B. Owner of a table can transfer ownership to another user.

C. A user would need RESOURCE privilege to run SET SESSION AUTHORIZATION statement.

D. User Informix can grant DBA privilege to a role.

E. A user with DBA privilege can alter, drop, or rename any database object.

Correct Answer: A,E

IBM Assessment: Informix 11.50 Application Developer - A2090-556 Exam Practice Test

Latest Update

Useful Links

Contact Us