You execute the following PL/SQL:

Which two statements are true?

• A.Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only whena 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: *

Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose
two.)

• A.It records checkpoint information in the control file.
• B.It frees unused temporary segments.
• C.It kills sessions that exceed idle time.
• D.It registers database services with all local and remote listeners known to the database instance.
• E.It frees resources held by abnormally terminated processes.

Comment: *

Name: *

Email: *

Verification: *

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output? (Choose three.)

• A.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
• B.The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• C.The C # # A_ADMIN user can perform wallet operations.
• D.The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage
  Management (ASM).
• E.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Comment: *

Name: *

Email: *

Verification: *

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING 'sales1';
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

• A.Only the user creating the database link must have an account and the required privileges in the remote database.
• B.The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.
• C.The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.
• D.Local database users who use this database link should have accounts and the required privileges in the remote database.
• E.The SALES1 net service name should be known to both the local and remote databases.

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

• 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: *