搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）

A、 Start the database in OPEN mode， and create a new index tablespace.

B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.

C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.

D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

查看正确答案
更多“At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）”相关的问题
第1题
[单选题] You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

A、 incomplete recovery  B、 complete recovery  C、 recovery using the Flashback Database feature  D、 recovery using the export/import utility  

点击查看答案
第2题
[] You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE&#8

A、A. Start the database in the MOUNT stage.  B、B. Back up the control file to trace.  C、C. Set the DBID  D、D. Issue the RECOVER DATABASE command.  

点击查看答案
第3题
[单选题] You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

A、 Window  B、 Program  C、 Job class  D、 Window group  

点击查看答案
第4题
[单选题] RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

A、’SQL ALTER DATABASE OPEN’；  B、SQL ALTER DATABASE ’OPEN’；  C、OPEN DATABASE；  D、DATABASE OPEN  

点击查看答案
第5题
[] You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

A、A. UNTIL SEQUENCE  B、B. UNTIL SCN  C、C. UNTIL CHANGE  D、D. UNTIL CANCEL  

点击查看答案
第6题
[单选题] A company wants to replace an existing UNIX database server with a new application running on Microsoft SQL Server.  Sizing analysis shows that a system with at least eight Xeon MP processors and 24GB RAM will be required for the central database server. Which of the following will meet the requirements at the lowest cost？（）

A、8-way x445 with Microsoft Windows Server 2003 Standard Edition  B、8-way x445 with Microsoft Windows Server 2003 Datacenter Edition  C、8-way x445 with Microsoft Windows Server 2003 Enterprise Edition  D、16-way x445 with VMWare ESX with SMP and Windows Server 2003 Standard Edition VMs  

点击查看答案
第7题
[多选题] Which two database operations can be performed at the MOUNT stage of database startup？（）

A、renaming of data files  B、dropping the database user  C、renaming of control files  D、multiplexing of control files  E、configuring the database in ARCHIVELOG mode  

点击查看答案
第8题
[] You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should&#

A、A.Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.  B、B.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.  C、C.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.  D、D.Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.  

点击查看答案
第9题
[单选题] You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

A、 V$DATABASE  B、 V$FLASHBACK_DATABASE_STAT  C、 V$FLASHBACK_DATABASE_LOG  D、 V$RECOVERY_FILE_DEST  

点击查看答案
第10题
[单选题] You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

A、The database would open normally.  B、The database would not open， and it would stop at mount stage.  C、The database would open after automatically performing instance recovery.  D、The database would not open， and you have to perform database recovery to open it.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服