Oracle: Modifying Data & Multiple Databases MCQs

56 MCQs  (Page 6 of 6)

In a materialized view, what does a FAST refresh use?
Materialized view logs to apply only changes
A full re-run of the defining query
The recycle bin
Flashback logs
Which statement creates the directory object needed by Data Pump?
CREATE DIRECTORY dp_dir AS '/u01/dump';
CREATE FOLDER dp_dir AT '/u01/dump';
MKDIR dp_dir '/u01/dump';
ALTER SYSTEM ADD DIRECTORY '/u01/dump';
What is an external table?
A table whose data lives in operating system files and is read through SQL
A table stored in another database
A table with no columns
A table in the recycle bin
What is a transportable tablespace?
A tablespace stored in memory
A tablespace that cannot be backed up
A tablespace moved between databases by copying its datafiles and exporting its metadata
A tablespace shared by all users