1z0-082: Oracle Database Administration I Tablespace Practice Questions

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

Select 2 answers.

• AA. Add the SEGMENT SPACE MANAGEMENT AUTO clause
• BB. Set UNDO_TABLESPACE to UNDOTBS01
• CC. Add the NOLOGGING clause
• DD. Make certain that the database operates in automatic undo management mode
• EE. Add the ONLINE clause

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

Select 2 answers.

• AA. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least50 Mb of available space.
• BB. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• CC. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• DD. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• EE. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.