最新の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.

How can you prevent concurrency problems when other users are modifying a nonlogging or raw table?

• A. Lock the table in exclusive mode for the whole transaction OR use repeatable read isolation level for the whole transaction.
• B. Lock the table in shared mode for the whole transaction OR use repeatable read isolation level for the whole transaction.
• C. Lock the table in exclusive mode for the whole transaction OR use committed read isolation level for the whole transaction.
• D. Lock the table in shared mode for the whole transaction OR use committed read isolation level for the whole transaction.

Which temporary table statement is NOT true?

• A. The table can have fragmented indexes.
• B. Temporary tables are visible to all users.
• C. The table exists until the database is closed.
• D. The table can use multiple dbspaces.

What is the name of the SQL function that needs to be used in place of SQL_FUNCTION in the INSERT statement given below?
CREATE TABLE EMPLOYEE (EMP_ID INTEGER, EMP_PICTURE BLOB)
PUT EMP_PICTURE IN MYSPACE1; INSERT INTO EMPLOYEE VALUES (1001, SQL_FUNCTION('emppicture.jpg', 'client'));

• A. FILETOBLOB
• B. BLOBCOPY
• C. LOBCOPY
• D. TOBLOB

Which statement about casting is correct?

• A. When you create a distinct data type, the database server automatically registers explicit casts from the distinct data type to the source data type and from the source data type to the distinct data type.
• B. When you create an opaque data type, the server automatically define template casts to handle conversions between the internal and external representations of the opaque data type.
• C. You don't need create casts on distinct types to handle conversions between the new distinct data type and other data types in the database, the server takes care of that automatically.
• D. In most cases, you can explicitly cast a named row type to built-in data types without creating the cast.