Regular Free Updates 1Z0-116 Dumps Real Exam Questions Test Engine Feb 20, 2023 [Q44-Q68]

Q44. 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?

Q45. Examine this query:

Why is this account in this status?

Q46. Which three are part of an access control list (ACL) when using Real Application Security?

Q47. Which two statements are true about Valid Node Checking for Registration (VNCR)?

Q48. You are Implementing a security policy that makes use of the USERENV namespace.
Which USERRENV value does not change for the duration of a session?

Q49. 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?

Q50. You must rekey encrypted sensitive credential data In your database.
You run the command alter database dictionary rekey credentials.
Which three options ate true about the bkkey process?

Q51. Users and applications must be able to access a web server of type https using database package UTL_HTTP.
Which three are part of the configuration to make this possible?

Q52. Database Vault is not used in your installation.
Why is a conventional secure application role more secure than a normal role?

Q53. You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?

Q54. 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?

Q55. Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?

Q56. Examine this sqlnet.ora file used by a client application:

Which three are found in the wallet specified by the directory parameter?

Q57. A database link must be created to connect a source Autonomous Database to target on premises database.
Examine this command:

Which two options are true?

Q58. Examine these commands and responses:

User Karen is an enterprise user.
Which two commands are used to allow this login?

Q59. 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?

Q60. 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?

Q61. You must redact the salary column of the HR.EMPLOYEES table to display only the number o. Examine this syntax:

Which function type must be Inserted at the end of line #7?

Q62. What is true about the client identifier?

Q63. 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?

Q64. Which three authentication methods are available with Centrally Managed Users (CMU)?

Q65. You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?

Q66. You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

Q67. 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?

Q68. Which statement can be used to force password complexity in the password file?