QUESTION 125 Examine this command : CREATE UNDO TABLESPACE undotbs01 DATAFILE ‘ undotbs_01.dbf’ SIZE 10 0 M AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two .)

QUESTION 126 Which three statements are true about views in an Oracle database? (Choose four.)

QUESTION 129 Choose three . Which three statements are true about views in an Oracle Database?

QUESTION 130 Choose two . Which two tasks can be performed in the NOMOUNT state?

QUESTION 131 Choose three . Which three statements are true about dynamic performance views?

QUESTION 132 Choose two . Which two are benefits of external tables?

QUESTION 133 Choose two. DAT ADIR1 and DATADIR2 are database directory objects. Examine this command: [orac1e@ host01 ~] expdp system/oracle \ > FULL=Y \ > DUMPFILE=datadir1:full% U .dmp, Datadir2:full% U. dmp \ > FILESIZE=2G \ > PARALLEL=4 \ > LOGFILE=datadir1:/expfull. 1og \ > JOB_NAME=expfull Which two statements are true about the expdp operation?

QUESTION 134 Choose three. Which three actions are ways to apply the principle of least privilege?

QUESTION 135 Choose two . Which two statements are true about the configuration and use of UNDO_RETENTION with no GUARANTEED RETENTION?

QUESTION 136 Choose two . Which two statements are true about a full outer join?

QUESTION 137 Choose two . Examine these SQL statements which execute successfully: CREATE TABLE emp ( emp_ no NUMBER(2 ) CONSTRAINT emp_ emp_ no_pk PRIMARY KEY, ename VARCHAR2 ( 15) , salary NUMBER (8 , 2 ) , mgr_ no NUMBER(2 )) ; ALTER TABLE emp ADD CONSTRAINT emp_ mgr_fk FOREIGN KEY (mgr_no) REFERENCES emp (emp_no) ON DELETE SET NULL; ALTER TABLE Emp DISABLE CONSTRAINT emp_emp_no_pk CASCADE; ALTER TABLE emp ENABLE CONSTRAINT emp_emp_no_pk; Which two statements are true after execution?

QUESTION 138 Choose three . Which three statements are true about row chaining and row migration done by Oracle database block space management?

QUESTION 139 Choose two . Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?

QUESTION 140 Choose two . Which two statements are true about the PMON background process?

QUESTION 141 Choose two . A script abc.sql must be executed to perform a certain task. User HR password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/ hr@ orc1 @ abc What will happen and why?