Free Oracle 1z1-116 Exam Dumps Questions & Answers

Examine this parameter In sqinet.ora:
SQLNET.ADTHENTICATION_SEBVICES=(NONE)
For which two cases do you need a password file?

• A.  to authenticate nonprivileged database users remotely
• B.  to authenticate externally Identified users remotely
• C.  to authenticate administrative privileged users locally
• D.  to authenticate administrative privileged users remotely
• E.  to authenticate nonprivllegcd database users locally
• F.  to authenticate externally Identified users locally

User jane must report on who has done RMAN backups on a database that has Unified Auditing enabled.
What is the minimum that must be done to allow JANE to generate these reports?

• A.  Use alter system set AUDIT_SYS_OPERATION= TRUE;
• B.  Use grant audit_viewer to Jane;
• C.  Use create audit policy.
• D.  Use grant audit_admin to Jane;

Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?

• A.  column privileges
• B.  column comments
• C.  user-defined functions
• D.  column names
• E.  column data
• F.  encrypted masks
• G.  table privileges

A DBA user created and configured this secure application role:

Why does the error occur?

• A.  user psmith is connecting remotely.
• B.  The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
• C.  User psmith Is connecting outside of the SYSDATE specified.
• D.  The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
• E.  The HR_ADMIN role must be granted to user PSMITH.
• F.  The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

Examine this output:

Which three are true?

• A.  John must connect as system to perform backup and recovery operations.
• B.  John can query dba tables.
• C.  John can perform backup and recovery operations by using RMAN.
• D.  John can perform backup and recovery operations by using SQL.
• E.  John can query other user's data.
• F.  John Is not able to perform startup and shutdown operations.
• G.  John must connect as sys to perform backup and recovery operations.