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

You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.

B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.

C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.

D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

查看正确答案
更多“You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）”相关的问题
第1题
[单选题] Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

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

点击查看答案
第2题
[单选题] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）

A、For the database, you should turn on the TRUSTWORTHY database option  B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM  C、For the database, the database compatibility level option should be set to 10  D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.   

点击查看答案
第3题
[单选题] You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

A、 target database  B、 auxiliary database  C、 third-party database  D、 recovery catalog database  

点击查看答案
第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题
[单选题] What RMAN command must you use before you can back up a database using the recovery catalog？（）

A、 create catalog  B、 install database  C、 catalog database  D、 merge Catalog with database  E、 register database  

点击查看答案
第6题
[单选题] 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  

点击查看答案
第7题
[单选题] You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

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

点击查看答案
第8题
[单选题] You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）

A、You must have started the database instance in restricted mode.  B、You must have started the database instance inNORMALmode.  C、You must have started the database instance with server parameter file.  D、You must have started the database instance but must not have mounted.  E、You must have started the database instance but must not have opened.  

点击查看答案
第9题
[单选题] You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

A、Multiplex all database files.  B、Configure the Flash Recovery Area.  C、Configure the database instance for ARCHIVELOG mode.  D、Configure the FAST_START_MTTR_TARGET initialization parameter  

点击查看答案
第10题
[单选题] You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

A、Database Control  B、Management Server  C、Management Repository  D、Application Server Control  E、Oracle Management Agent  

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

请使用微信扫码支付

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