Oracle Database Security Administration - 1Z0-116 Free Exam Questions

A. It runs only on Windows systems.

B. It must be run on the server that contains the database.

C. It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.

D. It must connect to the database using a SYSDBA connection.

E. It runs only on UNIX/Linux systems.

A. John can query other user's data.

B. John Is not able to perform startup and shutdown operations.

C. John can perform backup and recovery operations by using SQL.

D. John can perform backup and recovery operations by using RMAN.

E. John must connect as sys to perform backup and recovery operations.

F. John can query dba tables.

G. John must connect as system to perform backup and recovery operations.

A. User psmith Is connecting outside of the SYSDATE specified.

B. The HR_ADMIN role must be granted to user PSMITH.

C. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.

D. user psmith is connecting remotely.

E. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.

F. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

A. The third statement falls because global roles can be granted only by using a central authority.

B. The second statement falls because granting a global role can be completed only by using a central authority.

C. The first statement falls because the database Is not set up with Enterprise User Security.

D. All statements succeed even without Enterprise User Security configuration, but the role is not effective.

A. ADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:

B. ALTER DATABASE DICTIONARY REKEY CREDENTIALS;

C. SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = 'YES*;

D. SELECT * FROM DBA_OBJECTS;

E. ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;

F. ALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;

A. grant EXECUTE ON MARY.PBOC2 Co U1;

B. grant INHERIT PRIVILEGES ON USER MARY TO Ul ;

C. grant EXECUTE ON Ul.PROC2 TO MARY;

D. grant INHERIT PRIVILEGES ON USER U1 TO MARY;

A. temporary segments

B. encrypted tablespace keys

C. encrypted columns

D. encryption wallet

E. encrypted column keys

F. encrypted tablespaces

A. The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

B. The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.

C. One rule set contains two rules OR'ed together.

D. The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.

E. The rule set must be defined as is_static.

A. to authenticate externally Identified users remotely

B. to authenticate nonprivileged database users remotely

C. to authenticate externally Identified users locally

D. to authenticate nonprivllegcd database users locally

E. to authenticate administrative privileged users remotely

F. to authenticate administrative privileged users locally

A. Set the server side sqlnet.ora parameter SQLNET.CRYPTO_CHECKSUM_SERVER-REQUESTED.

B. Use ALTER USER SCOTT IDENTIFIED BY <password>.

C. Set the server side sqlnet.ora parameter SQLNET.ENCRYPTION_SERVER=REQUESTED.

D. Use ALTER USER SCOTT IDENTIFIED BY VALUES '<value>*.

E. Use ALTER USER SCOTT PASSWORD EXPIRE.

F. Use the SQL"PIus command password SCOTT.