Free Practice Questions for Oracle 1Z0-116 Exam

Question 1

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 Answer: D. The HR_ADMIN role must be granted to user PSMITH.

Question 2

An audit administrator wants to log Client Context variables In the audit trail.

Examine this query and the output:

AAUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

BAUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES
current:_user( db_name BY hr;

CCREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

DAUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

EAUDIT POLICY hr_emp_pol BY hr;

FCREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

GAUDIT POLICY hr_emp_pol EXCEPT hr;

Correct Answer: A. AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

Question 3

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

AALTER DATABASE DICTIONARY REKEY CREDENTIALS;

BSELECT * FROM DBA_OBJECTS;

CSELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = 'YES*;

DADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:

EALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;

FALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;

Correct Answer: B. SELECT * FROM DBA_OBJECTS;; C. SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = 'YES*;

Question 4

Examine this output:

Which three are true?

AJohn must connect as system to perform backup and recovery operations.

BJohn can query dba tables.

CJohn can perform backup and recovery operations by using SQL.

DJohn can perform backup and recovery operations by using RMAN.

EJohn must connect as sys to perform backup and recovery operations.

FJohn Is not able to perform startup and shutdown operations.

GJohn can query other user's data.

Correct Answer: A. John must connect as system to perform backup and recovery operations.; B. John can query dba tables.; G. John can query other user's data.

Question 5

A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table.

Which two arguments are passed to the function?

Athe table name

Bthe schema owning the table

Cthe policy type

Dthe policy name

Ethe policy group to which the policy belongs

Correct Answer: B. the schema owning the table; D. the policy name

Question 6

Which type of attack attempts to find data by repeatedly trying similar SQL with a modified predicate?

Atiming attack

BInference attack

Cdata remanence attack

Dcache attack

Eside-channel attack

Fknown-plaintext attack

Correct Answer: D. cache attack

Question 7

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 ORA-12638 Credential retrieval failed.

Where must you make a change to sqlnet.ora to allow the database link to use its stored credentials Instead of trying to use Kerberos?

Aon client side of server B

Bon client side of server A

Con server side of server B

Don server side of server A

Correct Answer: B. on client side of server A

Question 8

Examine this list:

1. You must monitor access to email column or salary column In the employees table.

2. If any activity is detected, the action must be audited and a notification sent out by email.

3. The database has Unified Auditing enabled.

4. You have created and successfully tested the email sending procedure, sysadmin_fga.emaii._ai.ert.

You create the audit policy:

A user with select privilege on hr.employees executes this :

SELECT email FROM HR.EMPLOYEES;

What will be the result?

AThe query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.

BThe query will be executed, an entry will be created In FGA_LOG$ table, and the mall will be sent.

CThe query will be executed, but no audit entry will be created nor any mail sent.

DThe query will be executed, no audit entry will be created but the mall will be sent.

Correct Answer: C. The query will be executed, but no audit entry will be created nor any mail sent.

Question 9

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 Answer: A. Password credentials are stored on the database server.; D. Wallet usage secures deployments that rely on password credentials for connecting to databases Instances.

Question 10

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 Answer: A. SESSION_CSER