Updated Nov-2022 Test Engine or PDF for the Oracle 1Z0-116 test to help you quickly prepare for the Oracle exam!
Full 1Z0-116 Practice Test and 92 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 49
If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?
- A. the primary and foreign key columns
- B. none of the columns
- C. columns with any type of constraint
- D. foreign key columns only
- E. the primary key column only
Answer: A
NEW QUESTION 50
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 included in the export and import operation and applied by default to the objects in the target system.
- B. The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.
- C. The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.
- D. The policy Is not Included In export and Import operation.
- E. The actual data in the tables is copied to the Data Pump target system without being redacted.
Answer: D,E
NEW QUESTION 51
Examine the statement:
CREATE BOLE hr_admin IDENTIFIED USING pac_mgr.hr_admin_rola_ch9ck;
Which three are true about the sec_mgr. hr_admin_role_check procedure?
- A. It must use only one security check to validate the user.
- B. It can use only the DBMS_SESSION. SET_ROLE procedure.
- C. It must use the deflner's rights to enable the role.
- D. Its owner SEC_MGR must be granted the execute any procedure role.
- E. It must use the invokcr's rights to enable the role,
- F. It can Include one or more security checks to validate the user.
- G. It must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.
Answer: B,C,D
NEW QUESTION 52
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,2,5,4
- B. 3,5,2,4,1
- C. 1,4,5,2
- D. 1,2,3,5
Answer: A
NEW QUESTION 53
An audit administrator wants to log Client Context variables In the audit trail.
Examine this query and the output:
- A. AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;
- B. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr
- C. CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;
- D. AUDIT POLICY hr_emp_pol BY hr;
- E. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;
- F. CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;
- G. AUDIT POLICY hr_emp_pol EXCEPT hr;
Answer: A
NEW QUESTION 54
A DBA user created and configured this secure application role:
Why does the error occur?
- A. user psmith is connecting remotely.
- B. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
- C. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
- D. The HR_ADMIN role must be granted to user PSMITH.
- E. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.
- F. User psmith Is connecting outside of the SYSDATE specified.
Answer: D
NEW QUESTION 55
Oracle Database Vault is enabled In the database. You have these requirements:
1. Database administrator dbai must export and import data from and to a non-protected schema.
2. Database administrator dba2 must export and Import data from and to a protected schema.
Which three options together satisfy these requirements?
- A. Grant become user to dbai.
- B. Grant sysdba to both users.
- C. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
- D. Grant become user to dba2.
- E. Grant imp_full_database and exp_full_database to dbai and dba2.
- F. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
- G. Grant sysoper to both users.
Answer: A,C,F
NEW QUESTION 56
Which two are true about Database Privilege Analysis?
- A. It shows the grant paths to the privileges and suggests which grant path to keep.
- B. It can be used after you install the Oracle Database without any additional database configuration steps.
- C. If a privilege is captured during run time, it is saved under the run-time capture name.
- D. It must have the Database Vault option enabled.
- E. Privilege analysis data for dropped objects are kept.
- F. It cannot be used to capture the privileges that have been exercised on precompiled database objects.
Answer: A,B
NEW QUESTION 57
Which three authentication methods are available with Centrally Managed Users (CMU)?
- A. kerberos authentication
- B. public key Infrastructure (PKT) authentication
- C. SSH authentication
- D. smart key authentication
- E. remote Access Services authentication
- F. username/password authentication
Answer: A,E,F
NEW QUESTION 58
Examine these commands and responses:
User Karen is an enterprise user.
Which two commands are used to allow this login?
- A. CREATE USER guest IDENTIFIED BY karen;
- B. GRANT CREATE SESSION TO guest;
- C. CREATE USER karen IDENTIFIED BY guest;
- D. CREATE USER guest IDENTIFIED GLOBALLY as '';
- E. GRANT CREATE SESSION TO karan;
Answer: D
NEW QUESTION 59
Which CVSS Version 3.1 metric indicates how close an attacker needs to be to the vulnerable component?
- A. Availability
- B. Attack Complexity
- C. Attack Vector
- D. Scope
- E. User Interaction
- F. Privileges Required
Answer: D
NEW QUESTION 60
When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?
- A. This is expected behavior for this view.
- B. The key store is not open.
- C. The master key has been corrupted.
- D. The master key has not been created.
- E. You do not have select privileges on this database view.
Answer: B
NEW QUESTION 61
Which two tasks should you perform initially to Implement native network encryption without disrupting client applications?
- A. Upgrade all OCI-basod clients to match the database version.
- B. Modify all JDBC Thin based clients to include network encryption parameters in Java.
- C. Verify which clients have encrypted connections using the view vSsession_CONNECT_INFO.
- D. Configure the listener with an endpoint for protocol TCPS.
- E. Set the client side sqinec.ora parameter SQLNET.ENCRYPTION _client = required.
- F. Set the server side sqinet.oia parameter sqlnet.encryption_server = requested.
- G. Set the server side sqinot.ora parameter SQLNET.CRYPTO_CHECKSOM_SERVER - accepted.
Answer: D
NEW QUESTION 62
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 client side of server B
- B. on client side of server A
- C. on server side of server A
- D. on server side of server B
Answer: B
NEW QUESTION 63
Examine this security parameter and Its value:
SEC_USER_ONAUTHORIZED_ACCESS_BANNER=/opt/oracla/admin/data/unauthwarninq.txt In which file must you include this parameter?
- A. server.xml
- B. tnsnaroes.ora
- C. names.ora
- D. listener.ora
- E. init. era
- F. aqlnet.ora
Answer: D
NEW QUESTION 64
Examine this command:
Which two statements are true?
- A. Opening the software keystore from the local computer is not possible.
- B. Opening the software keystore from remote computers is possible.
- C. Opening the software keystore must always be done manually on the local computer.
- D. Opening the software keystore from remote computers is not possible.
- E. Opening the software keystore from the local computer Is possible.
Answer: B,C
NEW QUESTION 65
Examine this sqlnet.ora file used by a client application:
Which three are found in the wallet specified by the directory parameter?
- A. the username, password, and service name required to connect to the database
- B. the trusted certificates of the database service
- C. the private key of the database service
- D. the trusted certificates of the Certification Authority
- E. the user certificate used to uniquely Identify the database service
- F. the private key of the client application
- G. the user certificate used to uniquely Identify the client application
Answer: D,F,G
NEW QUESTION 66
......
Get Latest 1Z0-116 Dumps Exam Questions: https://drive.google.com/open?id=1m-effI3kn27Zup_SMMJFz_vvOEGpuxWJ
Full 1Z0-116 Practice Test and 92 unique questions with explanations waiting just for you, get it now: https://www.briandumpsprep.com/1Z0-116-prep-exam-braindumps.html
