The default tablespace is the tablepsace in which the user's objects are created. Generally while creating the user, the default tablespace is mentioned. If by any chance the default tablespace is not mentioned while creating the user, the default tablespace for that user will be system and ...
For a tablespace that uses the data dictionary to manage its extents, Oracle updates the appropriate tables in the data dictionary whenever an extent is allocated or freed for reuse. A tablespace that uses the data dictionary to manage its extents has by default incremental extent sizes, which a...
Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?(Choose ... A. Add the SEGMENT SPACE MANAGEMENT AUTO clause B. Set UNDO_TABLESPACE ...
1:CREATETABLESPACE hyperion 2:LOGGING 3:DATAFILE'D:\app\Administrator\oradata\orcl\hyperion_data1.dbf'SIZE174080K AUTOEXTENDONNEXT1280K MAXSIZE 10485760K 4:EXTENT MANAGEMENTLOCAL 5:ONLINE; 1:createuserhyperion identifiedbypassword 2:defaulttablespace hyperion 3:temporarytablespace temp ; 1:grantcreatese...