Oracle Database 19c: Administration Workshop Quiz Questions and Answers
Answer :
- A normal shutdown waits for all connected users to disconnect before shutting down, while an immediate shutdown aborts all active transactions and disconnects all users immediately.
Answer :
- When you want to shut down the database instance immediately without waiting for connected users to disconnect.
Answer :
- ALTER PLUGGABLE DATABASE CLOSE
Answer :
- When you want to shut down the database instance cleanly and ensure that all transactions are committe
Answer :
- To modify the properties of a tablespace
Answer :
- To specify the location of the PDB data files
Answer :
- When you want to reclaim wasted space from tables and indexes
