Tested & Approved 1Z0-116 Study Materials Download Free Updated 92 Questions [Q40-Q57]

Rate this post

Tested & Approved 1Z0-116 Study Materials Download Free Updated 92 Questions

Regular Free Updates 1Z0-116 Dumps Real Exam Questions Test Engine

QUESTION 40
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?

Configure liscener.oia with an endpolnt for tcps

Configure sqinet.ora with parameter sq.lnet.encrypt70N_server

Download the root certificate from the Certificate Authority In Base64 format

Configure sqlnet. ora with parameter tcp . invited_nodes

Download the trusted certificate of the web server in Base64 format a

Configure an Oracle wallet using mkstore or Wallet Manager

Configure access control lists using DBMS_NETWORK_ACL._ADMIN

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

You do not have select privileges on this database view.

The master key has been corrupted.

The key store is not open.

The master key has not been created.

This is expected behavior for this view.

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

It can bo used for tables in encrypted tablcspaces.

encrypted columns cannot have an Index.

All encrypted columns of a table use the same encryption key.

Column level encrypted data remains encrypted in the buffer cache.

Column-level encryption keys are not encrypted by the master key.

QUESTION 43
Examine this command:

Which two statements are true?

Opening the software keystore from remote computers is possible.

Opening the software keystore from the local computer Is possible.

Opening the software keystore from remote computers is not possible.

Opening the software keystore must always be done manually on the local computer.

Opening the software keystore from the local computer is not possible.

QUESTION 44
Examine these commands and responses:

Which object privilege must be granted to allow execution of the stored procedure?

grant EXECUTE ON MARY.PBOC2 Co U1;

grant INHERIT PRIVILEGES ON USER U1 TO MARY;

grant INHERIT PRIVILEGES ON USER MARY TO Ul ;

grant EXECUTE ON Ul.PROC2 TO MARY;

QUESTION 45
Which CVSS Version 3.1 metric indicates how close an attacker needs to be to the vulnerable component?

Privileges Required

User Interaction

Attack Vector

Scope

Availability

Attack Complexity

QUESTION 46
A DBA user created and configured this secure application role:

Why does the error occur?

User psmith Is connecting outside of the SYSDATE specified.

The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.

user psmith is connecting remotely.

The HR_ADMIN role must be granted to user PSMITH.

The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

The HR.ROLE_CHECK procedure must be created without the AUTHID clause.

QUESTION 47
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 statements are true about the redaction policy?

The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.

The policy Is not Included In export and Import operation.

The actual data in the tables is copied to the Data Pump target system without being redacted.

The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.

The policy is included in the export and import operation and applied by default to the objects in the target system.

QUESTION 48
Which statement is true about Network ACLs?

They ate used to control access by users to external network services and resources from the database through PL/SQL.

They are used to provide access to database packages.

They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.

They are used to configure proxy for PL/SQL network utility packages.

QUESTION 49
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?

Grant become user to dbai.

Grant sysoper to both users.

Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.

Grant imp_full_database and exp_full_database to dbai and dba2.

Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.

Grant become user to dba2.

Grant sysdba to both users.

QUESTION 50
Which two privileges can be restricted at the column level?

SELECT

INSERT

REVOKE

UPDATE

GRANT

DELETE

QUESTION 51
Examine these commands and responses:

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

GRANT CREATE SESSION TO karan;

CREATE USER guest IDENTIFIED BY karen;

CREATE USER karen IDENTIFIED BY guest;

CREATE USER guest IDENTIFIED GLOBALLY as ”;

GRANT CREATE SESSION TO guest;

QUESTION 52
Examine this statement and its result:

You issue this statement and then restart the database instance:

Which Is true about generated audit records?

They now Include all application context attribute values.

They are now written to XML files as well as the database.

They now Include SQL statements and any bind variables.

Information is now populated in auds .commentstext.

QUESTION 53
Which two are true about Database Privilege Analysis?

It can be used after you install the Oracle Database without any additional database configuration steps.

It must have the Database Vault option enabled.

Privilege analysis data for dropped objects are kept.

If a privilege is captured during run time, it is saved under the run-time capture name.

It shows the grant paths to the privileges and suggests which grant path to keep.

It cannot be used to capture the privileges that have been exercised on precompiled database objects.

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

ALTER DATABASE DICTIONARY REKEY CREDENTIALS;

SELECT * FROM DBA_OBJECTS;

SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = ‘YES*;

ADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:

ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;

ALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;

QUESTION 55
For which two reasons would you define Network ACLs?

for configuring fine-grained access control for users and roles that need to access external network services from the database

for configuring fine-grained access control to Oracle wallets to make HTTP requests that require password or client-certificate authentication

to create auditing policies regarding the usage of network services from the database

to block network attacks or denial of service attacks directed at the database

to Improve the performance of the database applications that require access to remote network services

QUESTION 56
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?

Credential Data Is automatically encrypted using aes2S6.

The credential data encryption process does not de-obfuscate the obfuscated passwords before re-encrypts begin.

Both sys. links and sys . SCHEDULER_CREDENTIAL tables are rekeyed.

The rekey process prompts the user to provide a new key algorithm If needed.

The process of rekeylng does not automatically open the keystore.

The rekey process only applies to the sys.ltnks CREDENTUIALS table.

The rekey process only applies to the SYS.SCHEDULES$ credential table.

QUESTION 57
Examine these commands and the output used to configure Real Application Security:

What does this output mean?