1Z0-116 Dumps with Practice Exam Questions Answers [Q30-Q46]

1Z0-116 Dumps with Practice Exam Questions Answers

1Z0-116 by Oracle Database Security Actual Free Exam Practice Test

NEW QUESTION 30
You must redact the salary column of the HR.EMPLOYEES table to display only the number o. Examine this syntax:

Which function type must be Inserted at the end of line #7?

• A. DBMS_REDACT.PARTIAL
• B. DBMS_RE DACT.RANDOM
• C. DBMS_REDACT.FUI,I.
• D. DBMS_BEDACT.NONE
• E. DBMS REDACT.REGEXP

Answer: A

 

NEW QUESTION 31
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. This has no effect on tom's connect attempts.
• C. TOM can never connect.
• D. This has no effect on JIM'S connection attempts.
• E. JIM con never connect.

Answer: A,E

 

NEW QUESTION 32
Which three are true concerning command rules?

• A. If a command rule's associated rule set Is disabled, then the rule set evaluates to true.
• B. Object privileges override command rules.
• C. A command can have only one command rule that applies to it.
• D. If a command rule's associated rule set evaluation results In an error, the command is not allowed to execute.
• E. System privileges override command rules.
• F. For DML statement command rules, you can specify a wildcard for the object name.
• G. For DML statement command rules, you can specify a wildcard for the object owner.

Answer: E,F,G

 

NEW QUESTION 33
You are the Service Consumer In the Cloud Shared Responsibility Model.
Which three are your responsibility when using the Infrastructure as a Service (IaaS)?

• A. host Infrastructure
• B. database
• C. application
• D. data
• E. guest OS
• F. network
• G. physical
• H. virtualization

Answer: A,E,H

 

NEW QUESTION 34
Which two statements are true about the Secure External Password Store (SEPS)?

• 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. Bypassing database authentication adds significant performance benefits to middle-tier applications.
• D. Password rotation policies can be enforced without changing application code.
• E. The database does not need to authenticate the connection because the password credentials are stored in a wallet.

Answer: A,B

 

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

Answer: B,C,D

 

NEW QUESTION 36
While upgrading your Oracle database server from 10g to 19c, you want to ensure that the users can still connect with their current passwords after the upgrade.
What do you need to set explicitly for this purpose?

• A. SQLNET.ALLOWED_LOGON_VERSION_sebveb = 8 In the aqlnec.ora of the new database homo.
• B. SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home
• C. Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server SQLNET.ALLOWED LOGON. VEBSION .SERVER.
• D. SQLNET.ALLOWED_LOGON_VERSION_client = 8 in the sqlnec.ora file of the client application.

Answer: A

 

NEW QUESTION 37
As the SYSKM user you must create the password-based keystore, which will be used for TDE. Examine this list:

Identify the sequence that Oracle uses to search for the keystore and its location.

• A. 1,4,5,2
• B. 3,5,2,4,1
• C. 1,2,5,4
• D. 1,2,3,5

Answer: C

 

NEW QUESTION 38
Which two tasks should you perform initially to Implement native network encryption without disrupting client applications?

• A. Configure the listener with an endpoint for protocol TCPS.
• B. Set the server side sqinet.oia parameter sqlnet.encryption_server = requested.
• C. Set the client side sqinec.ora parameter SQLNET.ENCRYPTION _client = required.
• D. Set the server side sqinot.ora parameter SQLNET.CRYPTO_CHECKSOM_SERVER - accepted.
• E. Verify which clients have encrypted connections using the view vSsession_CONNECT_INFO.
• F. Upgrade all OCI-basod clients to match the database version.
• G. Modify all JDBC Thin based clients to include network encryption parameters in Java.

Answer: A

 

NEW QUESTION 39
Examine these commands that execute successfully:

What must be done to allow the index to be used?

• A. Create a SQL baseline to preserve the execution plan from before the encryption.
• B. Use tublespace encryption instead of column encryption.
• C. Enable encryption hardware acceleration on the CPUs of the machine.
• D. Add the first_name column to the ix_employee Index to Improve its selectivity.

Answer: C

 

NEW QUESTION 40
A DBA user created and configured this secure application role:

Why does the error occur?

• A. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
• B. User psmith Is connecting outside of the SYSDATE specified.
• C. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
• D. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.
• E. user psmith is connecting remotely.
• F. The HR_ADMIN role must be granted to user PSMITH.

Answer: F

 

NEW QUESTION 41
What Is the first step when analyzing security within a database?

• A. Deploy Oracle Key Vault
• B. Configure and enable Database Vault
• C. Encrypt tablespaces using Transparent Data Encryption
• D. Execute Database Security Assessment Tool (DBSAT)
• E. Create a Data Redaction Policy for your most sensitive tables
• F. Mask nonproduction data using Data Masking & Subsetting

Answer: C

 

NEW QUESTION 42
You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?

• A. The statement will not audit any users.
• B. The statement will only audit sys.
• C. The statement will audit all users.
• D. The statement must be updated to specify which users to audit.

Answer: B

 

NEW QUESTION 43
Which two does the master key encrypt with Transparent Data Encryption?

• A. encrypted columns
• B. encrypted tablespace keys
• C. encrypted tablespaces
• D. encryption wallet
• E. temporary segments
• F. encrypted column keys

Answer: D,E

 

NEW QUESTION 44
Examine this statement and its result:

You issue this statement and then restart the database instance:

Which Is true about generated audit records?

• A. They now Include all application context attribute values.
• B. They now Include SQL statements and any bind variables.
• C. They are now written to XML files as well as the database.
• D. Information is now populated in auds .commentstext.

Answer: A

 

NEW QUESTION 45
Which three are part of an access control list (ACL) when using Real Application Security?

• A. roles
• B. column constraints
• C. schemas
• D. data realm constraints
• E. data realms
• F. privileges
• G. policies

Answer: B,D,F

 

NEW QUESTION 46
......

Free Oracle Database Security 1Z0-116 Exam Question: https://www.prep4king.com/1Z0-116-exam-prep-material.html