单项选择题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:
Which is the recommended sequence of operations you need to perform for the query successfully?（）
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.
相关考题
-
多项选择题
TomanuallyconfiguretheSGAcomponentsusingOracleEnterpriseManagerMemoryAdvisor，youcansetvaluesforwhichofthefollowinginitializationparameters？（）
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE -
多项选择题
Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（） (Choose two.)
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. -
单项选择题
ForOracle11g，Oraclestronglyrecommendsthatyouconfigureyourdatabasetousewhichofthefollowingmemory-managementfeatures？（）
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above
