Oracle OCA Exam 1Z0-062 Chapter 6 Managing Database Storage Structures 2023/2024

Oracle OCA Exam 1Z0-062 Chapter 6 Managing Database Storage Structures 2023/2024 RENAME TABLESPACE Syntax? - ANSWER-ALTER TABLESPACE oldname RENAME TO newname; TS can be online when renamed RENAME TABLESPACE Syntax? - ANSWER-"ALTER TABLESPACE oldname RENAME TO newname; TS can be online when renamed" OFFLINE a TABLESPACE Syntax? - ANSWER-"ALTER TABLESPACE tablespacename OFFLINE [ NORMAL | IMMEDIATE | TEMPORARY];" Offline NORMAL (does a checkpoint occur?) - ANSWER-"force a checkpoint for all the datafiles (write all buffer blocks to disk first)" offline IMMEDIATE (does a checkpoint occur?) - ANSWER-Does NOT flush db buffer, datafiles will be corrupt, in need of recovery (apply changes from redo log) offline TEMPORARY (does a checkpoint occur?) - ANSWER-"Checkpoint all the files that can be, then take them offline. Any corrupted datafiles will be offlined. This reduces number of corrupted datafiles." ONLINE a tablespace Syntax? - ANSWER-ALTER TABLESPACE tsname ONLINE; READ ONLY tablespace Syntax, and what's allowed? - ANSWER-"ALTER TABLESPACE tablespacename [READ ONLY | READ WRITE]; no DML allowed, obj's can be DROPPED"