IBM Informix 11.50 Application Developer - C2090-556 FREE EXAM DUMPS QUESTIONS & ANSWERS]

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" for the view and the underlying tables. B. The privileges not 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 granted to "ABC" to access the underlying tables and not the view.

Discussion 0

Correct Answer: C Vote an answer

Question 2

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

A. Distinct types B. Named row types C. Opaque types D. Row types

Discussion 0

Correct Answer: C Vote an answer

Question 3

What format should be used to define columns using user-defined types in an ANSI-compliant database?

A. tablename.colname B. owner.tablename.colname C. owner.colname D. colname

Discussion 0

Correct Answer: C Vote an answer

Question 4

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

A. SMALLINT B. DATETIME C. SMALLFLOAT D. DECIMAL

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which datatype is a synonym for NUMERIC?

A. Fixed point DECIMAL B. INTEGER C. FLOAT D. Floating point DECIMAL

Discussion 0

Correct Answer: A Vote an answer

Question 6

To register a routine in the database, an authorized user wraps the SPL commands in a CREATE FUNCTION or CREATE PROCEDURE statement. The database server stores a registered SPL routine internally. Which two of the following can register a new routine in the database? (Choose two.)

A. Any user in the DBA group. B. The user informix. C. Any user in the DBSECADM group. D. All users. E. Any user with DBA privileges.

Discussion 0

Correct Answer: B,E Vote an answer