Free IBM C2090-320 Exam Dumps Questions & Answers

Which privilege or authority is required to use the DSN command?

• A.  EXECUTE
• B.  None
• C.  SECADM
• D.  SYSADM

Given the following table and index definitions, what type of index will be created?

• A.  Data-partitioned partitioning index
• B.  Non-partitioned secondary index
• C.  Data-partitioned secondary index
• D.  Non-partitioned index

Your current authorization ID is DBA.
Only one of your secondary authorization IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is "DROP INDEX AAA". Which of the following statements must precede th$ DROP statement so that it drops the index?

• A.  SET CURRENT PATH = 'DB2';
• B.  No preceding statement is needed
• C.  SET CURRENT RULES = 'DB2';
• D.  SET CURRENT SCHEMA = 'DB2':

Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

• A.  Create the object after activating an audit policy that will apply to the table that you are about to create
• B.  Let somebody with SYSCTRL authority create the object
• C.  Create the object after activating the SEPARATE_SECURITY=YES DSNZPARM
• D.  Create the object in a trusted context that is defined with the ROLE AS OBJECT OWNER AND QUALIFIER clause

You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

• A.  CLOB
• B.  BLOB
• C.  DBCLOB
• D.  VARGRAPHIC