Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE `undotbs_01.dbf' SIZE 100M AUTOEXTEND

By Singh | January 1, 2023

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.)

A. Add the ONLINE clause

B. Set UNDO_TABLESPACE to UNDOTBS01

C. Add the NOLOGGING clause

D. Add the SEGMENT SPACE MANAGEMENT AUTO clause

E. Make certain that the database operates in automatic undo management mode

Correct Answer: B,E

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this
Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to