Oracle Database Security Administration - 1z1-116 Exam Practice Test

A. It Is In effect only when configured as a default role for the user.

B. It can be set only by a package or procedure that is created with deflner's rights.

C. It can be set only by a package or procedure associated with the role definition.

D. It requires a password to be set.

E. It can be set only by users with the grant any bole privilege.

A. User JANE acquires the DBA role by default.

B. User JANE can create objects In sys schema only when connected as SYSDBA.

C. User JANE can grant SYSDBA privilege to roles.

D. User JANE must always connect as SYSDBA to the database instance.

E. User JANE can backup and recover the database.

F. User JANE must use operating system authentication.

A. Upgrade to a new Release.

B. Request a one off patch exception from Oracle Support.

C. Install a new Release Update Revision.

D. Install a new Release Update.

E. Implement a workaround recommended by Oracle Support.

A. Add the first_name column to the ix_employee Index to Improve its selectivity.

B. Use tublespace encryption instead of column encryption.

C. Enable encryption hardware acceleration on the CPUs of the machine.

D. Create a SQL baseline to preserve the execution plan from before the encryption.

A. They are used to provide access to database packages.

B. They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.

C. They are used to configure proxy for PL/SQL network utility packages.

D. They ate used to control access by users to external network services and resources from the database through PL/SQL.

A. Password credentials are stored on the database server.

B. Wallet usage secures deployments that rely on password credentials for connecting to databases Instances.

C. Password rotation policies can be enforced without changing application code.

D. Bypassing database authentication adds significant performance benefits to middle-tier applications.

E. The database does not need to authenticate the connection because the password credentials are stored in a wallet.

A. System privileges override command rules.

B. If a command rule's associated rule set Is disabled, then the rule set evaluates to true.

C. If a command rule's associated rule set evaluation results In an error, the command is not allowed to execute.

D. Object privileges override command rules.

E. A command can have only one command rule that applies to it.

F. For DML statement command rules, you can specify a wildcard for the object owner.

G. For DML statement command rules, you can specify a wildcard for the object name.

A. The storage quota has been reached for the ATP database.

B. The create TABLESAPECE statement is not available in ATP.

C. You must be explicitly granted the create TABLESPACE privilege in ATP.

D. There is not enough storage available in the ATP database.

E. Database Vault prevents you from executing this command.

A. Random Strings

B. Shuffle

C. Array List

D. Auto Mask

E. Substitute

A. It cannot be used to capture the privileges that have been exercised on precompiled database objects.

B. It must have the Database Vault option enabled.

C. Privilege analysis data for dropped objects are kept.

D. If a privilege is captured during run time, it is saved under the run-time capture name.

E. It can be used after you install the Oracle Database without any additional database configuration steps.

F. It shows the grant paths to the privileges and suggests which grant path to keep.