Oracle 1Z0-116 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

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

AYou do not have select privileges on this database view.

BThe master key has been corrupted.

CThe key store is not open.

DThe master key has not been created.

EThis is expected behavior for this view.

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AYou do not have select privileges on this database view.

BThe master key has been corrupted.

CThe key store is not open.

DThe master key has not been created.

EThis is expected behavior for this view.

0 / 1500

Question 2

Which two are true about Database Privilege Analysis?

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

BIt must have the Database Vault option enabled.

CPrivilege analysis data for dropped objects are kept.

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

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

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

Correct : A, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

BIt must have the Database Vault option enabled.

CPrivilege analysis data for dropped objects are kept.

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

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

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

0 / 1500

Question 3

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?

AIt must use only one security check to validate the user.

BIt must use the invokcr's rights to enable the role,

CIt must use the deflner's rights to enable the role.

DIt can Include one or more security checks to validate the user.

EIt must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.

FIt can use only the DBMS_SESSION. SET_ROLE procedure.

GIts owner SEC_MGR must be granted the execute any procedure role.

Correct : C, F, G

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt must use only one security check to validate the user.

BIt must use the invokcr's rights to enable the role,

CIt must use the deflner's rights to enable the role.

DIt can Include one or more security checks to validate the user.

EIt must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.

FIt can use only the DBMS_SESSION. SET_ROLE procedure.

GIts owner SEC_MGR must be granted the execute any procedure role.

0 / 1500

Question 4

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?

ASESSION_CSER

BCURRENT_OSER

CCURRENT SCHEMA

DCLIENT_INFO

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASESSION_CSER

BCURRENT_OSER

CCURRENT SCHEMA

DCLIENT_INFO

0 / 1500

Question 5

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

APassword credentials are stored on the database server.

BBypassing database authentication adds significant performance benefits to middle-tier applications.

CThe database does not need to authenticate the connection because the password credentials are stored in a wallet.

DWallet usage secures deployments that rely on password credentials for connecting to databases Instances.

EPassword rotation policies can be enforced without changing application code.

Correct : A, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

APassword credentials are stored on the database server.

BBypassing database authentication adds significant performance benefits to middle-tier applications.

CThe database does not need to authenticate the connection because the password credentials are stored in a wallet.

DWallet usage secures deployments that rely on password credentials for connecting to databases Instances.

EPassword rotation policies can be enforced without changing application code.

0 / 1500

Master Oracle 1Z0-116 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: