Jul-2023 Realistic 1Z0-116 Accurate & Verified Answers As Experienced in the Actual Test!
Latest Oracle 1Z0-116 Practice Test Questions, Oracle Database Security Administration Exam Dumps
NEW QUESTION # 33
Examine this statement and its result:
You issue this statement and then restart the database instance:
Which Is true about generated audit records?
- A. Information is now populated in auds .commentstext.
- B. They now Include SQL statements and any bind variables.
- C. They now Include all application context attribute values.
- D. They are now written to XML files as well as the database.
Answer: C
NEW QUESTION # 34
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. Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.
- D. Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.
Answer: A
NEW QUESTION # 35
Database Vault Is configured and enabled In the Oracle database.
Three users are granted the dba, dv_omneb, and dv_acctmgb roles.
There is a requirement to create a user who can:
1. Connect to the database Instance
2. Select from dictionary views
Which users can complete the operation to meet the requirement?
- A. users granted DV_OWNER role
- B. users granted DBA and DV_OWNER roles
- C. users granted DV_ACCTMGR and DBA roles
- D. users granted DV_ACCTMGR and DV_OWNER roles
Answer: C
NEW QUESTION # 36
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 dba2.
- B. Grant sysdba to both users.
- C. Grant imp_full_database and exp_full_database to dbai and dba2.
- D. Grant sysoper to both users.
- E. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
- F. Grant become user to dbai.
- G. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
Answer: E,F,G
NEW QUESTION # 37
Which three authentication methods are available with Centrally Managed Users (CMU)?
- A. username/password authentication
- B. SSH authentication
- C. public key Infrastructure (PKT) authentication
- D. remote Access Services authentication
- E. smart key authentication
- F. kerberos authentication
Answer: A,D,F
NEW QUESTION # 38
Which statement can be used to force password complexity in the password file?
- A. orapwd file=orapwORCL force=yes format=legacy
- B. orapwd file=orapwOPCL forcaat=12
- C. orapwd file=orapwORCL format=12 force-yes
- D. orapwd file=orapwOBCL forroat=12.2
Answer: D
NEW QUESTION # 39
Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?
- A. It runs only on UNIX/Linux systems.
- B. It runs only on Windows systems.
- C. It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.
- D. It must be run on the server that contains the database.
- E. It must connect to the database using a SYSDBA connection.
Answer: B,C
NEW QUESTION # 40
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 policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.
- C. The policy Is not Included In export and Import operation.
- D. The actual data in the tables is copied to the Data Pump target system without being redacted.
- E. The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.
Answer: C,D
NEW QUESTION # 41
Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?
- A. user-defined functions
- B. table privileges
- C. column privileges
- D. column comments
- E. column names
- F. encrypted masks
- G. column data
Answer: B,F,G
NEW QUESTION # 42
Which two authorization rights does a Database Vault realm owner have that a realm participant does not have?
- A. Add or remove participants to or from the realm.
- B. Grant or revoke realm-secured database roles.
- C. Add or remove realm-secured database roles to or from the realm.
- D. Add or remove realm-protected objects to or from the reaim.
- E. Add or remove owners to or from the realm.
- F. Grant or revoke system privileges to access objects protected by the realm.
- G. Grant or revoke privileges on realm-protected objects to or from other users.
Answer: C,F
NEW QUESTION # 43
When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?
- A. The master key has not been created.
- B. The master key has been corrupted.
- C. This is expected behavior for this view.
- D. You do not have select privileges on this database view.
- E. The key store is not open.
Answer: E
NEW QUESTION # 44
Which two are true about Database Privilege Analysis?
- A. It must have the Database Vault option enabled.
- B. Privilege analysis data for dropped objects are kept.
- C. If a privilege is captured during run time, it is saved under the run-time capture name.
- D. It shows the grant paths to the privileges and suggests which grant path to keep.
- E. It can be used after you install the Oracle Database without any additional database configuration steps.
- F. It cannot be used to capture the privileges that have been exercised on precompiled database objects.
Answer: D,E
NEW QUESTION # 45
For which two are Oracle Label Security policies not applied?
- A. conventional path exports
- B. objects in the SYS schema
- C. partitioned tables
- D. direct path exports
- E. users with the SYSDA privilege other than sys
Answer: B,C
NEW QUESTION # 46
Examine these commands and the output used to configure Real Application Security:
What does this output mean?
- A. You created a realm and an access control list that reference a non-existent policy.
- B. You created an access control list that references a non-existent realm.
- C. You created a realm that references a non-existent policy.
- D. You created a policy that references a non-existent access control list.
- E. You treated an access control list that references a non-existent policy.
- F. You created a policy that references a non-existent realm.
Answer: C
NEW QUESTION # 47
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 A
- B. Option E
- C. Option B
- D. Option D
- E. Option C
Answer: E
NEW QUESTION # 48
......
Free 1Z0-116 Exam Files Downloaded Instantly 100% Dumps & Practice Exam: https://passleader.torrentvalid.com/1Z0-116-valid-braindumps-torrent.html