单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）Aflash back the databaseBperform point-in-time recoveryCperform a full database recoveryDdrop and re-create the tablespaceEuse Recovery Manager （RMAN） to recover the database
单选题
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
A
flash back the database
B
perform point-in-time recovery
C
perform a full database recovery
D
drop and re-create the tablespace
E
use Recovery Manager （RMAN） to recover the database
参考解析
解析：
暂无解析
相关考题：
单选题Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）APMONBSMONCMMNLDMMANEMMON
单选题You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）AThe Oracle kernel will be placed in this location.BThe Oracle software will be placed in this location.CThe server parameter file （SPFILE） will be placed in this location.DThe database files will be placed in this location， if not specified explicitly.EThe location will be considered for the base of Oracle Managed Files （OMF）.FThe location will be considered for the base of Optimal Flexible Architecture （OFA）.
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）AThe modified data are not available on disk.BThe modified data have been flushed out from memory.CThe modified rows of the SupportCenter STAFF table have been locked.DJack has not committed the changes after modifying the value.EBoth users are accessing the database from two different machines.
单选题Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）AThe modified data are not available on disk.BThe modified data have been flushed out from memory.CThe modified rows of the SupportCenter STAFF table have been locked.DJack has not committed the changes after modifying the value.EBoth users are accessing the database from two different machines.
单选题You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）AControl fileBPassword fileCParameter fileDOnline redo log fileEListener controller fileFServer parameter file
单选题You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）AYou performed rollback after commit.BIf a log switch occurs in your database.CThearchiverfails to generate an archived log file.DInstance recovery fails to find one of the redo log files.EA long-running query is unable to get read-consistent image.FIf you perform manual undo management operations in auto mode.
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility