Which two statements are true about Oracle Managed Files (OMF)?

• A.OMF cannot be used in a database that already has data files created with user-specified directions.
• B.The file system directions that are specified by OMF parameters are created automatically.
• C.OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• D.OMF automatically creates unique file names for table spaces and control files.
• E.OMF may affect the location of the redo log files and archived log files.

Comment: *

Name: *

Email: *

Verification: *

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)

• A.Increase the size of the temporary tablespace.
• B.Enable temporary undo for the database.
• C.Enable undo retention guarantee.
• D.Increase the size of the redo log buffer.
• E.Enable Automatic Memory Management (AMM).

Comment: *

Name: *

Email: *

Verification: *

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

Which two statements are true? (Choose two.)

• A.A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
• B.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• C.An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
• D.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E.An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.

Comment: *

Name: *

Email: *

Verification: *

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id)
INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?

• A.Only the ORD_CUSTOMER_IX1 index created.
• B.Both the indexes are updated when a row is inserted, updated, or deleted in the
  ORDERS table.
• C.Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• D.The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the
  OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• E.Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• F.Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Comment: *

Name: *

Email: *

Verification: *

You execute the following PL/SQL:

Which two statements are true? (Choose two.)

• 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.
• B.FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with
  PRICE > 10000 is accessed.
• C.FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D.FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in
  the FGA audit trial.

Comment: *

Name: *

Email: *

Verification: *