Online Access Free C2090-546 Exam Questions

Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Which of the following actions can be done through an ALTER INDEX statement?

• A.Make this index the clustering index.
• B.Make the COMPRESS attribute YES or NO.
• C.Change the PCTFREE specification.
• D.Add a column to the index key.

A range-partitioned table TAB1 has been created with COL1 and COL2 with COL1 as the partitioning column. What is the result of running the following statement? CREATE UNIQUE INDEX xcol2 ON tab1(col2) PARTITIONED

• A.The index will be created as a non-unique index and a warning will be returned.
• B.The statement will be rejected and an error will be returned.
• C.The uniqueness will be enforced locally within each partition.
• D.The index will be created as a unique non-partitioned index and a warning will be returned.

What authority is required to grant SECADM authority to roles and groups?

• A.Database Administrator with DATAACCESS and ACCESSCTRL privileges
• B.Database Administrator
• C.Security Administrator
• D.System Administrator

The SAMPLE database is backed up and the recovery logs are included in the backup image. Which of the following actions is required to restore the database to the end of the backup?

• A.RESTORE DB sample TO END OF BACKUP AND STOP;
• B.RECOVER DB sample TO END OF BACKUP;
• C.RECOVER DB sample TO END OF BACKUP;
  ROLLFORWARD DB sample AND COMPLETE;
• D.RESTORE DB sample;
  ROLLFORWARD DB sample TO END OF BACKUP AND COMPLETE;

The following trusted context has been defined:

Which statement is correct?

• A.If USER1 connects to the database from address 9.26.113.204 without providing a password, the connection will run under userid APP1.
• B.If APP1 establishes a connection to the database, a connection to the database server at address 9.26.113.204 will be enabled using a role of CONTEXT_ROLE.
• C.If APP1 connects from address 9.26.113.204 and no role has been granted to APP1, then and only then will role CONTEXT_ROLE be used.
• D.If APP1 connects from address 9.26.113.204, it will have role CONTEXT_ROLE associated with the connection.