[Aug 02, 2022] Download Free Oracle 1Z0-116 Real Exam Questions
Pass Your Exam With 100% Verified 1Z0-116 Exam Questions
Understanding functional and technical aspects of Oracle Database Security Administration Exam Number: 1Z0-116
The following will be discussed in the ORACLE 1Z0-116 exam dumps:
- Regulate PKI Certificate Authentication
- Regulate Kerberos Authentication
- Regulate OS Authentication
- Oversee Centrally Managed Users
NEW QUESTION 20
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_RE DACT.RANDOM
- B. DBMS_BEDACT.NONE
- C. DBMS REDACT.REGEXP
- D. DBMS_REDACT.PARTIAL
- E. DBMS_REDACT.FUI,I.
Answer: D
NEW QUESTION 21
A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table.
Which two arguments are passed to the function?
- A. the schema owning the table
- B. the table name
- C. the policy name
- D. the policy type
- E. the policy group to which the policy belongs
Answer: A,C
NEW QUESTION 22
Examine these statements which execute successfully:
Which are the two reasons that no rows Are returned from the query?
- A. The set_empno_crx_proc procedure must be in a package.
- B. Enterprise User Security is not configured and used for the user.
- C. Only DBA users can query SESSION_CONTEXT view contents.
- D. The application context is global.
- E. An administrator issues the ALTER SYSTEM FLUSH global context statement.
Answer: B,D
NEW QUESTION 23
Database Vault is not used in your installation.
Why is a conventional secure application role more secure than a normal role?
- A. It can be set only by users with the grant any bole privilege.
- B. It can be set only by a package or procedure that is created with deflner's rights.
- C. It requires a password to be set.
- D. It can be set only by a package or procedure associated with the role definition.
- E. It Is In effect only when configured as a default role for the user.
Answer: A
NEW QUESTION 24
Examine this command that Is executed:
What is the result?
- A. The salary column is encrypted using TDE column encryption.
- B. The salary column is nullified when queried by the database users.
- C. The salary column is fine grain audited.
- D. The bind variables for the salary column are masked In trace files and vS views.
- E. The salary column is redacted when queried by database users.
Answer: E
NEW QUESTION 25
As an Autonomous Transaction Processing (ATP) database administrator, you want to extend the storage capacity In the database.
Examine this command and output from the database:
What is the reason for the error?
- A. Database Vault prevents you from executing this command.
- B. You must be explicitly granted the create TABLESPACE privilege in ATP.
- C. There is not enough storage available in the ATP database.
- D. The storage quota has been reached for the ATP database.
- E. The create TABLESAPECE statement is not available in ATP.
Answer: C
NEW QUESTION 26
User jane must report on who has done RMAN backups on a database that has Unified Auditing enabled.
What is the minimum that must be done to allow JANE to generate these reports?
- A. Use grant audit_viewer to Jane;
- B. Use grant audit_admin to Jane;
- C. Use create audit policy.
- D. Use alter system set AUDIT_SYS_OPERATION= TRUE;
Answer: C
NEW QUESTION 27
You export and Import a table's data using Data Pump connected as a user who Is assigned DBA role with default privileges.
There is a data redaction policy on the table.
Which two statements are true about the redaction policy?
- A. The policy Is not Included In export and Import operation.
- B. The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.
- C. The actual data in the tables is copied to the Data Pump target system without being redacted.
- D. The policy is included in the export and import operation and applied by default to the objects in the target system.
- E. The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.
Answer: A,C
NEW QUESTION 28
When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?
- A. The key store is not open.
- B. You do not have select privileges on this database view.
- C. This is expected behavior for this view.
- D. The master key has not been created.
- E. The master key has been corrupted.
Answer: A
NEW QUESTION 29
Which type of attack attempts to find data by repeatedly trying similar SQL with a modified predicate?
- A. timing attack
- B. side-channel attack
- C. cache attack
- D. known-plaintext attack
- E. Inference attack
- F. data remanence attack
Answer: C
NEW QUESTION 30
Which three authentication methods are available with Centrally Managed Users (CMU)?
- A. kerberos authentication
- B. username/password authentication
- C. remote Access Services authentication
- D. SSH authentication
- E. smart key authentication
- F. public key Infrastructure (PKT) authentication
Answer: A,B,C
NEW QUESTION 31
Examine this query:
Why is this account in this status?
- A. The account uses a global authentication.
- B. The ACCOUNTS_ STATUS column is not updated until the user attempts to log in.
- C. The user exceeded the value of FAILED_LOGIN _ATTEMPTS and its password has not been reset yet.
- D. The account has the SYSDBA privilege granted.
- E. The user exceeded the value of PASSWORD_LIFE_TIME and Its password has not been reset yet
Answer: D
NEW QUESTION 32
Database Vault realm r protects all tables In the fin schema from DBA access User fin is configured as the owner in realm R.
You must also prevent access to realm r protected tables by user FIN. Which achieves this?
- A. Make user FIN participant In realm r. Instead of owner.
- B. Revoke the select any table privilege from user FIN.
- C. Make realm R a mandatory realm.
- D. Remove the owner authorization of user fin in realm R.
Answer: A
NEW QUESTION 33
You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?
- A. The statement will audit all users.
- B. The statement will not audit any users.
- C. The statement will only audit sys.
- D. The statement must be updated to specify which users to audit.
Answer: C
NEW QUESTION 34
Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role.
You have not yet configured the database with Enterprise User Security.
You plan to perform these steps:
1. create role GLOBAI._ROI.E identified globally;
2. grant select any table to GLODAL_COLE;
3. grant GLOBAL_ROLE to SCOTT;
What is the result?
- A. All statements succeed even without Enterprise User Security configuration, but the role is not effective.
- 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. The third statement falls because global roles can be granted only by using a central authority.
Answer: C
NEW QUESTION 35
Examine this configuration and requirement:
1. The hr user created a private database link in the pdb2 pluggable database linking to the hr schema In the PDBl pluggable database.
2. Other users in pdb2 must query the remote HR.EMPLOYEES table In PDBI using this database link.
Which two operations together ensure that the database link provides access only to the HR.EMPLOYEES table in the PDBI pluggable database?
- A. Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.
- B. Grant other users access to the database link In the PDB2 pluggable database.
- C. Grant other users access to the database link in the PDBI pluggable database.
- D. Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.
- E. Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .
Answer: B,E
NEW QUESTION 36
......
1Z0-116 Dumps 100 Pass Guarantee With Latest Demo: https://www.prepawayexam.com/Oracle/braindumps.1Z0-116.ete.file.html
1Z0-116 Dumps PDF - 1Z0-116 Real Exam Questions Answers: https://drive.google.com/open?id=1IW98Pj3T0sShEo7epfWMtaloSJndRKdS