One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used.
Which two can cause better plans to be used for a statement? (Choose two.)
You create and enable a unified audit policy on a database that has the default auditing configuration.
The OE user, who has the DBA role, executes these statements.
What is true about the SELECT statement and why?
Which statement is true about transportable tablespaces?
You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?
Which three types of database objects can have their columns stored in the In-Memory column store? (Choose two.)
You plan to execute this command:
Which statement is true and why?
Examine these parameters in a PFILE used to start database instance.
Which two statements are true after an instance restart is attempted and why? (Choose two.)
In which situation can the optimizer choose a hash join?