Online Access Free C2090-611 Exam Questions

Which is a valid statement about the Row and Column Access Control (RCAC) feature?

• A.When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.
• B.RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).
• C.Users with SECADM authority are exempt from RCAC rules.
• D.The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.

A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO What is the recommended way to convert the database MYDB to an automatic storage database?

• A.Use the CREATE STOGROUP statement to define a new storage group in the database and to assign storage paths to the new storage group.
• B.Use the ALTER DATABASE statement to add storage paths to the database.
• C.Use the DROP DATABASE command to drop the database; then, recreate the database by executing a CREATE DATABASE commandstatement that does not contain the
  AUTOMATIC STORAGE NO option.
• D.Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE configuration parameter for the database toYES.

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

• A.HSJOIN
• B.IXSCAN
• C.TBSCAN
• D.NLJOIN

Which authority is required to revoke SECADM authority?

• A.DBADM
• B.SQLADM
• C.SYSADM
• D.SECADM

An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

• A.Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.
• B.Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
• C.Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.
• D.Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.