Oracle 1Z0-116 Practice Questions| TestInsights

Question 1

Which two statements are true about Database Vault rules and rule sets?

AYou must create a rule set for a rule, before creating the rule.

BYou con reference Oracle-supplied rules In rule sets that you create.

CIf a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.

DA given rule can be added to only one rule set.

EDeleting a rule set also deletes all the rules that have been added to It.

Correct : C, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AYou must create a rule set for a rule, before creating the rule.

BYou con reference Oracle-supplied rules In rule sets that you create.

CIf a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.

DA given rule can be added to only one rule set.

EDeleting a rule set also deletes all the rules that have been added to It.

0 / 1500

Question 2

Examine this security parameter and Its value:

SEC_USER_ONAUTHORIZED_ACCESS_BANNER=/opt/oracla/admin/data/unauthwarninq.txt In which file must you include this parameter?

Ainit. era

Blistener.ora

Caqlnet.ora

Dtnsnaroes.ora

Enames.ora

Fserver.xml

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Ainit. era

Blistener.ora

Caqlnet.ora

Dtnsnaroes.ora

Enames.ora

Fserver.xml

0 / 1500

Question 3

Examine these statements which execute successfully:

Which are the two reasons that no rows Are returned from the query?

AOnly DBA users can query SESSION_CONTEXT view contents.

BAn administrator issues the ALTER SYSTEM FLUSH global context statement.

CThe set_empno_crx_proc procedure must be in a package.

DThe application context is global.

EEnterprise User Security is not configured and used for the user.

Correct : D, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AOnly DBA users can query SESSION_CONTEXT view contents.

BAn administrator issues the ALTER SYSTEM FLUSH global context statement.

CThe set_empno_crx_proc procedure must be in a package.

DThe application context is global.

EEnterprise User Security is not configured and used for the user.

0 / 1500

Question 4

A DBA user created and configured this secure application role:

Why does the error occur?

AUser psmith Is connecting outside of the SYSDATE specified.

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

Cuser psmith is connecting remotely.

DThe HR_ADMIN role must be granted to user PSMITH.

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

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

Correct : D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AUser psmith Is connecting outside of the SYSDATE specified.

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

Cuser psmith is connecting remotely.

DThe HR_ADMIN role must be granted to user PSMITH.

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

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

0 / 1500

Question 5

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

ASYS

Busers with the DV_ACCTMGR role

Cusers with the DV_OWNER role

Dusers with the DV_ADMIN role

ESYSTEM

Correct : C, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASYS

Busers with the DV_ACCTMGR role

Cusers with the DV_OWNER role

Dusers with the DV_ADMIN role

ESYSTEM

0 / 1500

Curious about Actual Oracle Database (1Z0-116) Exam 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: