Create Next App

Exam contains 381 questions

Page 14 of 64

Question 79 🔥

You execute the following PL/SQL:Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

Highly voted

B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

Highly voted

C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

Highly voted

D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Highly voted

Discussion of the question

Question 80 🔥

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?

Which database solution meets these requirements?

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.

Highly voted

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.

Highly voted

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.

Highly voted

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.

Highly voted

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

Highly voted

Discussion of the question

Question 81 🔥

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? (Choose three.)

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 82 🔥

To enable the Database Smart Flash Cache, you configure the following parameters:DB_FLASH_CACHE_FILE = /dev/flash_device_1 , /dev/flash_device_2DB_FLASH_CACHE_SIZE=64G -What is the result when you start up the database instance?

Which database solution meets these requirements?

A. It results in an error because these parameter settings are invalid.

Highly voted

B. One 64G flash cache file will be used.

Highly voted

C. Two 64G flash cache files will be used.

Highly voted

D. Two 32G flash cache files will be used.

Highly voted

Discussion of the question

Question 83 🔥

You executed this command to create a password file:$ orapwd file = orapworcl entries = 10 ignorecase = NWhich two statements are true about the password file? (Choose two.)

Which database solution meets these requirements?

A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

Highly voted

B. It contains username and passwords of database users who are members of the OSOPER operating system group.

Highly voted

C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

Highly voted

D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

Highly voted

E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Highly voted

Discussion of the question

Question 84 🔥

Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?

Which database solution meets these requirements?

A. Undo data is written to flashback logs after 1200 seconds.

Highly voted

B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

Highly voted

C. You can perform a Flashback Database operation only within the duration of 1200 seconds.

Highly voted

D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_062

Exam contains 381 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us