Oracle Related Exams
1z0-082 Exam

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE ‘undotbs_01.dbf’
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
Which three statements are true regarding single row subqueries?
Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)