AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-062





Question ID 2412

You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;

Which statement is true about the audit record that generated when auditing after instance restarts?
 

Option A

A.    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
 

Option B

B.    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
 

Option C

C.    One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
 

Option D

D.    One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
 

Option E

E.    One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
 

Correct Answer A
Explanation


Question ID 2413

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?
 

Option A

A.    The ASM compatibility attribute controls the format of the disk group metadata.
 

Option B

B.    RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
 

Option C

C.    The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
 

Option D

D.    The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

 

Option E

E.    The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Correct Answer A,B,D
Explanation

Send email to admin@getfreedumps for new dumps request!!!