When manually configuring the SGA，which of the following parameter changes requires an instance restart to take effect？（）  
"First Test， First Pass" - www.lead2pass.com 97
Oracle 1Z0-053 Exam

A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

A. stored scripts in the recovery catalog.
B. backups that can be deleted from disk.
C. backup sets and image copies are obsolete.
D. backups that do not have the AVAILABLE status in the RMAN repository.