In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully?
(Choose two.)
Which three statements are true about dropping and unused columns in an Oracle database?
(Choose three.)
Examine the description of the PRODUCT_STATUS table:
The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?
Which three statements are true about Deferred Segment Creation in Oracle databases?