Free Oracle 1z1-116 Exam Dumps Questions & Answers

Which statement is true about Network ACLs?

• A.They ate used to control access by users to external network services and resources from the database through PL/SQL.
• B.They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.
• C.They are used to provide access to database packages.
• D.They are used to configure proxy for PL/SQL network utility packages.

You configured Kerberos authentication for databases running on servers A and B.
However a database link connecting the database on server A to the database on server B fails with ORA-12638 Credential retrieval failed.
Where must you make a change to sqlnet.ora to allow the database link to use its stored credentials Instead of trying to use Kerberos?

• A.on server side of server B
• B.on server side of server A
• C.on client side of server A
• D.on client side of server B

Examine this code which executes successfully:

If the IN_OFFICE_ON_WEEKEND rule set returns true for an attempt to connect from Inside the office on weekends, which two are true about the effects of this configuration?

• A.JIM can only connect when In the office on weekends.
• B.JIM con never connect.
• C.This has no effect on tom's connect attempts.
• D.This has no effect on JIM'S connection attempts.
• E.TOM can never connect.

Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.
Examine these requirements:
1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.
2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.
3. Audit records are to be collected for every evaluation of the rule set.
Which two options are true when creating the rule set?

• A.The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.
• B.One rule set contains two rules OR'ed together.
• C.The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.
• D.The rule set must be defined as is_static.
• E.The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.

You must rekey encrypted sensitive credential data In your database.
You run the command alter database dictionary rekey credentials.
Which three options ate true about the bkkey process?

• A.The rekey process only applies to the sys.ltnks CREDENTUIALS table.
• B.The rekey process only applies to the SYS.SCHEDULES$ credential table.
• C.Credential Data Is automatically encrypted using aes2S6.
• D.Both sys. links and sys . SCHEDULER_CREDENTIAL tables are rekeyed.
• E.The credential data encryption process does not de-obfuscate the obfuscated passwords before re-encrypts begin.
• F.The process of rekeylng does not automatically open the keystore.
• G.The rekey process prompts the user to provide a new key algorithm If needed.