Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using OracleDatabase Resource Manager? (Choose three.)
You created an encrypted tablespace:You then closed the encryption wallet because you were advised that this is secure.Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.Which is true about the result?
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.)
Which two statements are true when row archival management is enabled? (Choose two.)
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitionsThe table has a local prefixed, range partitioned index.Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.Which three methods could transparently help to achieve this result? (Choose three.)
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?
