1z0-116 Oracle Database Security Administration Questions and Answers

The storage quota has been reached for the ATP database.

The create TABLESAPECE statement is not available in ATP.

There is not enough storage available in the ATP database.

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

Database Vault prevents you from executing this command.

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

It requires a password to be set.

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

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

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

System privileges override command rules.

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

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

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

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

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

Object privileges override command rules.

Upgrade all OCI-basod clients to match the database version.

Set the server side sqinet.oia parameter sqlnet.encryption_server = requested.

Configure the listener with an endpoint for protocol TCPS.

Verify which clients have encrypted connections using the view vSsession_CONNECT_INFO.

Set the client side sqinec.ora parameter SQLNET.ENCRYPTION _client = required.

Set the server side sqinot.ora parameter SQLNET.CRYPTO_CHECKSOM_SERVER - accepted.

Modify all JDBC Thin based clients to include network encryption parameters in Java.

Option A

Option B

Option C

Option D

Option E

the table name

the schema owning the table

the policy type

the policy name

the policy group to which the policy belongs

You must create a rule set for a rule, before creating the rule.

You con reference Oracle-supplied rules In rule sets that you create.

If a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.

A given rule can be added to only one rule set.

Deleting a rule set also deletes all the rules that have been added to It.

Set sqlnet.aothentication_sebvices=(NONe» In sqlnet.ora on the database server.

Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.

Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.

Set REMOTE_OS_AUTHENT = FALSE In the init.ora file.

none of the columns

foreign key columns only

the primary and foreign key columns

columns with any type of constraint

the primary key column only

Only DBA users can query SESSION_CONTEXT view contents.

An administrator issues the ALTER SYSTEM FLUSH global context statement.

The set_empno_crx_proc procedure must be in a package.

The application context is global.

Enterprise User Security is not configured and used for the user.