Online Questions - Valid Practice To your 1z1-116 Exam (Updated 92 Questions)
Practice To 1z1-116 - Remarkable Practice On your Oracle Database Security Administration Exam
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:
- Send the Maximum Security Architecture
- Survey security needs (hazard decrease, administrative consistence)
- Survey the normal assault focuses for a data set
Average Salary of Oracle Database Security Administration Exam Number: 1Z0-116 Certified Professionals
The average salary is between $69k and $127k.
NEW QUESTION 39
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 server side of server A
- C. on server side of server B
- D. on client side of server A
Answer: D
NEW QUESTION 40
Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?
- A. It runs only on Windows systems.
- B. It must be run on the server that contains the database.
- C. It runs only on UNIX/Linux systems.
- D. It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.
- E. It must connect to the database using a SYSDBA connection.
Answer: A,D
NEW QUESTION 41
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 sysoper to both users.
- B. Grant sysdba to both users.
- C. Grant become user to dbai.
- D. Grant imp_full_database and exp_full_database to dbai and dba2.
- E. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
- F. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
- G. Grant become user to dba2.
Answer: C,E,F
NEW QUESTION 42
Examine these steps:
1. Run the DBSAT Collector
2. Run the DBSAT Discoverer
3. Run the DBSAT Reporter
Identify the minimum required steps for producing a report of schemas with sensitive data.
- A. 0
- B. 1,2,3
- C. 1,2
- D. 2,3
Answer: B
NEW QUESTION 43
Examine this command that Is executed:
What is the result?
- A. The salary column is redacted when queried by database users.
- B. The salary column is encrypted using TDE column encryption.
- C. The salary column is fine grain audited.
- D. The salary column is nullified when queried by the database users.
- E. The bind variables for the salary column are masked In trace files and vS views.
Answer: A
NEW QUESTION 44
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. Only grant other users access to the 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 PDBI pluggable database.
- E. Grant other users access to the database link In the PDB2 pluggable database.
Answer: C,E
NEW QUESTION 45
You connect to the database Instance over a network to change the password of user scott.
Which two methods avoid the new password for user scott from being compromised by network sniffing?
- A. Use the SQL"PIus command password SCOTT.
- B. Use ALTER USER SCOTT IDENTIFIED BY VALUES '<value>*.
- C. Set the server side sqlnet.ora parameter SQLNET.ENCRYPTION_SERVER=REQUESTED.
- D. Set the server side sqlnet.ora parameter SQLNET.CRYPTO_CHECKSUM_SERVER-REQUESTED.
- E. Use ALTER USER SCOTT IDENTIFIED BY <password>.
- F. Use ALTER USER SCOTT PASSWORD EXPIRE.
Answer: B,D
NEW QUESTION 46
You must mask data consistently In three database copies such that data relations across the databases remain In place.
Which Data Masking Format allows this?
- A. Array List
- B. Substitute
- C. Random Strings
- D. Shuffle
- E. Auto Mask
Answer: D
NEW QUESTION 47
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 alter system set AUDIT_SYS_OPERATION= TRUE;
- B. Use grant audit_admin to Jane;
- C. Use create audit policy.
- D. Use grant audit_viewer to Jane;
Answer: C
NEW QUESTION 48
You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?
- A. CREATE CONTEXT global_hr USING hr_pkg;
- B. CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;
- C. CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;
- D. CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;
Answer: A
NEW QUESTION 49
Which statement can be used to force password complexity in the password file?
- A. orapwd file=orapwOBCL forroat=12.2
- B. orapwd file=orapwORCL force=yes format=legacy
- C. orapwd file=orapwORCL format=12 force-yes
- D. orapwd file=orapwOPCL forcaat=12
Answer: A
NEW QUESTION 50
A DBA user created and configured this secure application role:
Why does the error occur?
- A. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.
- B. User psmith Is connecting outside of the SYSDATE specified.
- C. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
- D. user psmith is connecting remotely.
- E. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
- F. The HR_ADMIN role must be granted to user PSMITH.
Answer: F
NEW QUESTION 51
Examine this list of capabilities:
1. You can automatically restrict common users from accessing pluggable database (PDB).
2. Enabling Database Vault Operations Control In cdbsroot does not automatically enable It In PDBs.
3. Any common user granted the dv_admin role can enable Database Vault Operations Control.
4. To enable Database Vault Operations Control, use the dbms_macadm.enable_app_protection.
5. Common users' and Invokers' right procedures that must access PDB local data can be added to an exception list.
6. To disable Database Vault Operations Control, use the dbms_macadm.disable_app_protection.
Which statements describe Database Vault Operations Control?
- A. 2, 3. 6
- B. 3, 5, 6
- C. 1, 4, 6
- D. 1, 2, 3, 5
- E. 2, 4, 6
Answer: B
NEW QUESTION 52
Which two commands can a user with the syskm privilege execute?
- A. ALTER DATABASE DICTIONARY REKEY CREDENTIALS;
- B. SELECT * FROM DBA_OBJECTS;
- C. ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;
- D. ALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;
- E. SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = 'YES*;
- F. ADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:
Answer: B,E
NEW QUESTION 53
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 parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.
- B. One rule set contains two rules OR'ed together.
- C. The rule set must be defined as is_static.
- D. The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.
- E. The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.
Answer: C,D
NEW QUESTION 54
Which two statements are true about Database Vault rules and rule sets?
- A. If a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.
- B. Deleting a rule set also deletes all the rules that have been added to It.
- C. You con reference Oracle-supplied rules In rule sets that you create.
- D. You must create a rule set for a rule, before creating the rule.
- E. A given rule can be added to only one rule set.
Answer: A,E
NEW QUESTION 55
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 a package or procedure associated with the role definition.
- B. It can be set only by users with the grant any bole privilege.
- C. It Is In effect only when configured as a default role for the user.
- D. It can be set only by a package or procedure that is created with deflner's rights.
- E. It requires a password to be set.
Answer: B
NEW QUESTION 56
Examine these commands and responses:
User Karen is an enterprise user.
Which two commands are used to allow this login?
- A. GRANT CREATE SESSION TO guest;
- B. CREATE USER guest IDENTIFIED GLOBALLY as '';
- C. CREATE USER guest IDENTIFIED BY karen;
- D. CREATE USER karen IDENTIFIED BY guest;
- E. GRANT CREATE SESSION TO karan;
Answer: B
NEW QUESTION 57
......
True 1z1-116 Exam Extraordinary Practice For the Exam: https://www.actual4exams.com/1z1-116-valid-dump.html
Get 100% Passing Success With True 1z1-116 Exam: https://drive.google.com/open?id=1wStR4akT2166R6gcp4zm2Kd6bB3biGM2