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

On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）

A、 Flashback Drop

B、 Flashback Table

C、 Flashback Database

D、 Flashback Version Query

E、 Flashback Transaction Query

查看正确答案
更多“On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）”相关的问题
第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题
[单选题] Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 archivelog 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  

点击查看答案
第3题
[] Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

A、A.recovery cannot be performed because a backup was not performed after the last incomplete recovery  B、B.restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday  C、C.restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday  D、D.restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday  

点击查看答案
第4题
[单选题] Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）

A、 recovery cannot be performed because a backup was not performed after the last incomplete recovery  B、 restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday  C、 restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday  D、 restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday  

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

点击查看答案
第6题
[单选题] You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).You need to implement a backup schedule on Server1 to meet the following requirements:·Everyday, back up all files and folders to disk.·Every Friday, back up all files and folders to tape.·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since theprevious Friday’s backup to tape.Which backup jobs should you create?（）

A、·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and Thursday  B、·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and Thursday  C、·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, Thursday  D、·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday  

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

点击查看答案
第8题
[单选题] A customer has an LPAR with 4 dedicated cores on a POWER7 server with SMT4 enabled. How many logical processors are presented to an application running on this LPAR?（）

A、4  B、8  C、16  D、32  

点击查看答案
第9题
[单选题] You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to implement a backup schedule on Server1 to meet the following requirements: ·Everyday, back up all files and folders to disk. ·Every Friday, back up all files and folders to tape. ·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since the previous Friday’s backup to tape. Which backup jobs should you create? （）

A、·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and Thursday  B、·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and Thursday  C、·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, Thursday  D、·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday  

点击查看答案
第10题
[单选题] On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）

A、Flashback Drop  B、Flashback Table  C、Flashback Database  D、Flashback Version Query  E、Flashback Transaction Query  

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

请使用微信扫码支付

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