What should you do for a Scheduler to start a job when a file arrives on a remote system?

• A. Install the Scheduler agent on the remote system and register the agent with the database on the local system.
• B. Shutdown the file watcher on the local system.
• C. Ensure dedicated server is enabled on both the local and remote databases.
• D. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

• A. The PDB data files are automatically removed from disk.
• B. The PDB must be dosed.
• C. The PDB must be open in read only mode.
• D. The unplugged PDB becomes a non-CDB.
• E. The unplugged PDB can be plugged into another CDB.
• F. The unplugged PDB can be plugged into the same multitenant container database (CDB)

In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:

Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

• A. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.
• B. These users can never reuse a password
• C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
• D. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

• A. the optimizer_mode initialization parameter
• B. fixed baselines
• C. cardinality estimates
• D. operating system (OS) statistics
• E. object statistics in the data dictionary

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. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• 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_IX2 is used by the optimizer for queries on the ORDERS table.
• D. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• E. Only the ORD_CUSTOMER_IX1 index created.
• F. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.