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

An application cannot be modified to assign the required privileges to carry out specific actions once connected to a database. What method is used to assign the required privileges to this application?

• A. Within the application, GRANT the required privileges.
• B. Include the necessary GRANT statements in the application profile.
• C. Create a role with the necessary privileges and GRANT DEFAULT ROLE to the application id.
• D. Create a stored procedure called applicationid and GRANT the necessary privileges within.

What occurs when the following statement is issued?
SET DEBUG FILE TO "eric";

• A. A file called eric.debug will be create in users home directory if they are connected to a remote database.
• B. A file called eric will be created in the users current directory if they are connected to a local database.
• C. A file called eric will be created in INFORMIXDIR if they are connected to a remote database.
• D. A file called eric.debug will be created in INFORMIXDEBUG if they are connected to a local database

Which built-in function is supported by Informix Server?

• A. TOCHAR()
• B. IFNULL()
• C. FORMAT_UNITS()
• D. LASTDAY()

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.

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 inserted into an operating system file on the server.
• B. The CREATE TABLE statement fails with syntax error.
• C. The BLOB is inserted into a system default SBSPACE defined with SBSPACENAME onconfig parameter.
• D. The BLOB is stored with the table data.