1Z0-116 Exam Questions

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 rang...

Which two are true about auditing in an Oracle Database?

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

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?

An audit administrator wants to log Client Context variables In the audit trail. Examine this query and the output:

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?

Examine this output: Which three are true?

Which two tasks should you perform initially to Implement native network encryption without disrupting client applications?

Examine these commands and responses: Which object privilege must be granted to allow execution of the stored procedure?

Database Vault realm r protects all tables In the fin schema from DBA access User fin is configured as the owner in realm R. You must also prevent access to realm r protected table...

Which two privileges can be restricted at the column level?

For which two are Oracle Label Security policies not applied?

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

Which four products, features, or methods can help facilitate compliance with various privacy- related regulatory requirements such as PCI-DSS and the EU GDPR?

Examine these commands that execute successfully: What must be done to allow the index to be used?

Which two authorization rights does a Database Vault realm owner have that a realm participant does not have?

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

Which two statements are true about column-level transparent data encryption?

Which two commands can a user with the syskm privilege execute?

Which type of masking directly masks and subsets data In a nonproduction database with minimal or no Impact on production environments?

Examine this statement and its result: You issue this statement and then restart the database instance: Which Is true about generated audit records?

As the SYSKM user you must create the password-based keystore, which will be used for TDE. Examine this list: Identify the sequence that Oracle uses to search for the keystore and...

Examine this sqlnet.ora file used by a client application: Which three are found in the wallet specified by the directory parameter?

Examine these commands and the output used to configure Real Application Security: What does this output mean?

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?

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 Matr...

A DBA user created and configured this secure application role: Why does the error occur?

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

Which three are true concerning command rules?

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

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 ab...

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 sen...

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 p...

Which two represent the set of users that are never affected by connect command rules?

Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

You are the Service Consumer In the Cloud Shared Responsibility Model. Which three are your responsibility when using the Infrastructure as a Service (IaaS)?

Examine this query: Why is this account in this status?

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

Which two statements are true about the Secure External Password Store (SEPS)?

What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?

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 d...

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. AL...

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. Dat...

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

If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?

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

When creating labels using Oracle Label Security, which is required?

Examine this command: GRANT EXEMPT ACCESS POLICY TO PUBLIC; Which Transparent Sensitive Data Protection functionality will be affected when this command is executed?

While upgrading your Oracle database server from 10g to 19c, you want to ensure that the users can still connect with their current passwords after the upgrade. What do you need to...

For which two reasons would you define Network ACLs?