Best Oracle 1z1-116 Exam Practice Material Updated on Sep 17, 2022 [Q54-Q74]

NO.54 Examine this command that Is executed:

What is the result?

NO.55 What Is the first step when analyzing security within a database?

NO.56 Which two are true about Database Privilege Analysis?

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

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

NO.59 As an Autonomous Transaction Processing (ATP) database administrator, you want to extend the storage capacity In the database.
Examine this command and output from the database:

What is the reason for the error?

NO.60 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?

NO.61 When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?

NO.62 Which two statements are true about Database Vault factors?

NO.63 For which two are Oracle Label Security policies not applied?

NO.64 The sqinet.oia file on the client contains this parameter setting:
SQLNET.ENCRYPTION_CLIEKT = REQUESTED
What value for the parameter sQLNET.ENCRYPTION _server In the sqlnet.ora file on the server will disable Encryption and Data Negotiation?

NO.65 Examine these commands and responses:

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

NO.66 A DBA user created and configured this secure application role:

Why does the error occur?

NO.67 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?

NO.68 Examine this query:

Why is this account in this status?

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

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

NO.71 Examine this command:

Which two statements are true?

NO.72 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.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = “/*tc/ORACLE/WALLETS/orcl/external_Btore” SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET ‘password’
FOR CLIENT ‘TDE_WALLET’
TO LOCAL AUTO_LOGIH KEYSTORE ‘/etc/0RACLE/WALLETS/orcl/extemal_store’;
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT ‘TDE_WALLET’
TO LOCAL AUTO_L0GIN KEYSTORE ‘ /etc/ORACLE/WALLETS/orcl/external_store’ ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.

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

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

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