Download Free Oracle 1Z0-116 Real Exam Questions Download
Latest Oracle 1Z0-116 Real Exam Dumps PDF
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 the normal assault focuses for a data set
- Survey security needs (hazard decrease, administrative consistence)
NEW QUESTION 29
For which two reasons would you define Network ACLs?
- A. to Improve the performance of the database applications that require access to remote network services
- B. for configuring fine-grained access control for users and roles that need to access external network services from the database
- C. to block network attacks or denial of service attacks directed at the database
- D. to create auditing policies regarding the usage of network services from the database
- E. for configuring fine-grained access control to Oracle wallets to make HTTP requests that require password or client-certificate authentication
Answer: B,C
NEW QUESTION 30
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 upper_port may be null but the lower_port must specify a value.
- C. The port range must not overlap with any other port ranges for host01.
- D. The port range may not include values larger than or equal to 1024.
- E. Both lower_port and upper_port must not be NULL
- F. The lower_port may be null but the upper_port must specify a value.
Answer: A,D,F
NEW QUESTION 31
If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?
- A. none of the columns
- B. columns with any type of constraint
- C. the primary and foreign key columns
- D. foreign key columns only
- E. the primary key column only
Answer: C
NEW QUESTION 32
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. The first statement falls because the database Is not set up with Enterprise User Security.
- B. All statements succeed even without Enterprise User Security configuration, but the role is not effective.
- C. The second statement falls because granting a global role can be completed only by using a central authority.
- D. The third statement falls because global roles can be granted only by using a central authority.
Answer: A
NEW QUESTION 33
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 client side of server A
- D. on server side of server B
Answer: C
NEW QUESTION 34
You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.
Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?
- A. OBJECT_NAME=>'CHECKPOINT'
- B. OBJECT_OWNER=>'SYS
- C. PARAMETER_NAM£=>'CHECKPOINT'
- D. CLAUSE_NAME=>'SYSTEM'
- E. COMMANI>=>' ALTER SYSTEM'
- F. CLAUSE_NAME=>'CHECKPOINT'
- G. COMMAND=>'ALTER'
Answer: D,F
NEW QUESTION 35
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. Shuffle
- B. Substitute
- C. Auto Mask
- D. Random Strings
- E. Array List
Answer: A
NEW QUESTION 36
Examine this command :
GRANT EXEMPT ACCESS POLICY TO PUBLIC;
Which Transparent Sensitive Data Protection functionality will be affected when this command is executed?
- A. Data Redaction
- B. Transparent Data Encryption
- C. Bind Masking
- D. Virtual Private Database
Answer: B
NEW QUESTION 37
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. 1, 2, 3, 5
- C. 2, 4, 6
- D. 1, 4, 6
- E. 3, 5, 6
Answer: E
NEW QUESTION 38
You check the Risk Matrix of the latest Critical Patch Update (CPU).
One of the " Common Vulnerability and Exposure'' reports (CVEs) has Base Score that is above 9 in the Risk Matrix.
Which one is not a supported method to address this CVE?
- A. Upgrade to a new Release.
- B. Request a one off patch exception from Oracle Support.
- C. Install a new Release Update.
- D. Install a new Release Update Revision.
- E. Implement a workaround recommended by Oracle Support.
Answer: B
NEW QUESTION 39
Examine this list:
1. You must monitor access to email column or salary column In the employees table.
2. If any activity is detected, the action must be audited and a notification sent out by email.
3. The database has Unified Auditing enabled.
4. You have created and successfully tested the email sending procedure, sysadmin_fga.emaii._ai.ert.
You create the audit policy:
A user with select privilege on hr.employees executes this :
SELECT email FROM HR.EMPLOYEES;
What will be the result?
- A. The query will be executed, but no audit entry will be created nor any mail sent.
- B. The query will be executed, no audit entry will be created but the mall will be sent.
- C. The query will be executed, an entry will be created In FGA_LOG$ table, and the mall will be sent.
- D. The query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.
Answer: A
NEW QUESTION 40
Which statement can be used to force password complexity in the password file?
- A. orapwd file=orapwOPCL forcaat=12
- B. orapwd file=orapwORCL format=12 force-yes
- C. orapwd file=orapwOBCL forroat=12.2
- D. orapwd file=orapwORCL force=yes format=legacy
Answer: C
NEW QUESTION 41
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. names.ora
- B. init. era
- C. aqlnet.ora
- D. listener.ora
- E. server.xml
- F. tnsnaroes.ora
Answer: D
NEW QUESTION 42
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 DBA and DV_OWNER roles
- B. users granted DV_OWNER role
- C. users granted DV_ACCTMGR and DV_OWNER roles
- D. users granted DV_ACCTMGR and DBA roles
Answer: D
NEW QUESTION 43
Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?
- A. column privileges
- B. column names
- C. table privileges
- D. column data
- E. column comments
- F. encrypted masks
- G. user-defined functions
Answer: C,D,F
NEW QUESTION 44
......
PDF (New 2022) Actual Oracle 1Z0-116 Exam Questions: https://www.pdf4test.com/1Z0-116-dump-torrent.html
