最新の000-556問題集で試験を準備する

Consider the following:
GRANT DEFAULT ROLE user_role TO eric;
GRANT DEFAULT ROLE def_role TO PUBLIC;
What role will user eric use by default assuming the SET ROLE DEFAULT privilege has been granted?

• A. def_role because it was the last role command issued.
• B. user_role because it takes precedence over the public role.
• C. user_role because you cannot have both public and user level roles.
• D. def_role because default roles cannot be issued to a user.

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

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

Which of the following is NOT a legal value for the BOOLEAN data type?

• A. 'T' for true, and 'F' for false.
• B. NULL value.
• C. 't' for true, and 'f' for false.
• D. 1 for true, and 0 for false.

What does a value of 100 for SQLCODE mean?

• A. An unsuccessful query execution that returns no rows.
• B. A successful query execution that found no rows.
• C. An unsuccessful query execution that could have returned at least one row.
• D. A successful query execution that returned at least one row.

When passing parameters to a function written in Informix SPL, which statement does NOT occur?

• A. Define a single function to accept a varying number of parameters.
• B. Specify a simple large object literal (byte and text data type) as a function parameter.
• C. Call the function with integer data type when the function declaration expects a char data type.
• D. Specify a list datatype as a function parameter.