Free Oracle 1z1-116 Exam Dumps Questions & Answers

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

The utl_http package is used to invoke REST API's to manage Oracle GoldenGate Microservlces Architecture components on host1.
You must use dbms__network_acl_admin to specify a range of ports to be used when connecting to host01.
What three requirements must you consider?

• A.  The upper_port may be null but the lower_port must specify a value.
• B.  upper_port must be greater than or equal to lower_port.
• C.  The lower_port may be null but the upper_port must specify a value.
• D.  The port range must not overlap with any other port ranges for host01.
• E.  The port range may not include values larger than or equal to 1024.
• F.  Both lower_port and upper_port must not be NULL

You are Implementing a security policy that makes use of the USERENV namespace.
Which USERRENV value does not change for the duration of a session?

• A.  CURRENT SCHEMA
• B.  SESSION_CSER
• C.  CURRENT_OSER
• D.  CLIENT_INFO

Examine this command:

What masking definitions does it list?

• A.  All with the name credit and the commands to deploy them on a database with the name test.
• B.  All with names starting with credit and created on databases with names starting with test.
• C.  All with the name credit and the commands to deploy them on all databases with names starting with test.
• D.  All with the name credit and created on databases with name starting with teat.
• E.  All with names starting with credit and created on any database.

Which two configurations can be used to protect sensitive data In a database?

• A.  enforcing row-level security at the table level
• B.  setting the SQL92_SECURITy initialization parameter to false
• C.  collecting sensitive data Information with Database Security Assessment Tool (DBSAT)
• D.  enforcing row-level security at the database level
• E.  creating a procedure that defines the VPD restrictions in a VPD policy
• F.  enabling salt tor an encrypted column