Validate your 1z1-116 Exam Preparation with 1z1-116 Practice Test (Online & Offline)
Get all the Information About Oracle 1z1-116 Exam 2022 Practice Test Questions
NEW QUESTION 19
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 must be defined as is_static.
- B. The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.
- C. The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.
- D. One rule set contains two rules OR'ed together.
- E. The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.
Answer: A,C
NEW QUESTION 20
Which two statements are true about Database Vault factors?
- A. You can use a factor to enforce conditions for a command rule.
- B. Changing a factor type can change how factors are evaluated.
- C. You get an error at the time of factor creation If the retrieval method function you have specified does not exist.
- D. A factor can reference a function In another schema to compute its value, provided execute privilege Is granted to the sys user.
- E. You can configure a factor to be evaluated only once per session.
Answer: D,E
NEW QUESTION 21
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. application
- B. guest OS
- C. database
- D. host Infrastructure
- E. network
- F. virtualization
- G. physical
- H. data
Answer: B,D,F
NEW QUESTION 22
You are connected to an Oracle database Instance as a user with privileges to query the hr.employees table.
You are not exempt from any reduction policies.
Examine this query and result:
You implement this Data Redaction policy:
You re-execute the select statement.
What is the result?
A)
B)
C)
D)
E)
- A. Option D
- B. Option A
- C. Option E
- D. Option B
- E. Option C
Answer: E
NEW QUESTION 23
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. TOM can never connect.
- B. JIM can only connect when In the office on weekends.
- C. This has no effect on JIM'S connection attempts.
- D. This has no effect on tom's connect attempts.
- E. JIM con never connect.
Answer: B,E
NEW QUESTION 24
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. tnsnaroes.ora
- B. init. era
- C. names.ora
- D. aqlnet.ora
- E. server.xml
- F. listener.ora
Answer: F
NEW QUESTION 25
You must disable OS authentication for database administrative users on a RAC database.
Which option must you use to do this?
- A. Set REMOTE_OS_AUTHENT = FALSE In the init.ora file.
- B. Set sqlnet.aothentication_sebvices=(NONe» In sqlnet.ora on the database server.
- C. Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.
- D. Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.
Answer: A
NEW QUESTION 26
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. upper_port must be greater than or equal to lower_port.
- B. The port range may not include values larger than or equal to 1024.
- C. The lower_port may be null but the upper_port must specify a value.
- D. The upper_port may be null but the lower_port must specify a value.
- E. Both lower_port and upper_port must not be NULL
- F. The port range must not overlap with any other port ranges for host01.
Answer: A,B,C
NEW QUESTION 27
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. Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.
- B. Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.
- C. Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .
- D. Grant other users access to the database link In the PDB2 pluggable database.
- E. Grant other users access to the database link in the PDBI pluggable database.
Answer: C,D
NEW QUESTION 28
What is true about the client identifier?
- A. The client Identifier cannot be changed during the session.
- B. The client Identifier is automatically set by the SQL-Net layer.
- C. The client Identifier is automatically included In the audit trail.
- D. A session can have multiple client Identifier values set simultaneously.
Answer: B
NEW QUESTION 29
Which four products, features, or methods can help facilitate compliance with various privacy-related regulatory requirements such as PCI-DSS and the EU GDPR?
- A. Real Application Testing
- B. GoldenGate
- C. Data Guard
- D. Data Masking & Subsetting
- E. Transparent Data Encryption
- F. Oracle Sharding
- G. Data Redaction
- H. Table Partitioning
- I. Database Vault
- J. Real Application Clusters
Answer: A,C,D,G
NEW QUESTION 30
Which two represent the set of users that are never affected by connect command rules?
- A. SYS
- B. users with the DV_ADMIN role
- C. SYSTEM
- D. users with the DV_OWNER role
- E. users with the DV_ACCTMGR role
Answer: C,D
NEW QUESTION 31
Which two statements are true about Valid Node Checking for Registration (VNCR)?
- A. It restricts specific instances from registering with the Listener.
- B. It enforces the Listener connectivity through TCPS.
- C. It is a replacement for Class of Secure Transport (COST).
- D. It can only be used with Oracle RAC.
- E. It denies Instance registration through IPC.
Answer: C,E
NEW QUESTION 32
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. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
- B. Grant become user to dba2.
- C. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
- D. Grant sysoper to both users.
- E. Grant become user to dbai.
- F. Grant imp_full_database and exp_full_database to dbai and dba2.
- G. Grant sysdba to both users.
Answer: A,C,E
NEW QUESTION 33
Examine this command :
GRANT EXEMPT ACCESS POLICY TO PUBLIC;
Which Transparent Sensitive Data Protection functionality will be affected when this command is executed?
- A. Virtual Private Database
- B. Transparent Data Encryption
- C. Data Redaction
- D. Bind Masking
Answer: B
NEW QUESTION 34
Which statement is true about Network ACLs?
- A. They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.
- B. They are used to configure proxy for PL/SQL network utility packages.
- C. They are used to provide access to database packages.
- D. They ate used to control access by users to external network services and resources from the database through PL/SQL.
Answer: B
Explanation:
The NETWORK_ACL_ADMIN package provides the interface to administer the network access control lists (ACL). ACLs are used to control access by users to external network services and resources from the database through PL/SQL network utility packages including UTL_TCP, UTL_HTTP, UTL_SMTP andUTL_INADDR.
https://docs.oracle.com/database/121/ARPLS/d_networkacl_adm.htm#ARPLS74568
NEW QUESTION 35
To avoid hard coding passwords in scripts, you have elected to create an external password store-Examine this list of steps:
1. Set the external password store wallet location.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = "/*tc/ORACLE/WALLETS/orcl/external_Btore" SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET 'password'
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_LOGIH KEYSTORE '/etc/0RACLE/WALLETS/orcl/extemal_store';
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_L0GIN KEYSTORE ' /etc/ORACLE/WALLETS/orcl/external_store' ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.
- A. 1,2,5,4
- B. 1,2,3,6,4
- C. 1,2,6,3,5
- D. 2,3,6,4
- E. 1,2,3,4
- F. 2,1,3,4
Answer: C
NEW QUESTION 36
......
Check Real Oracle 1z1-116 Exam Question for Free (2022): https://troytec.dumpstorrent.com/1z1-116-exam-prep.html