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

Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

A、 The database writer writes to a trace file， indicating that the temporary file is not found.

B、 The database prompts for a database recovery.

C、 The database opens normally.

D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

查看正确答案
更多“Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）”相关的问题
第1题
[单选题] Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）

A、until the last commit  B、cannot be recovered  C、until the last offline backup  D、until the beginning of the last transaction  

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

点击查看答案
第4题
[多选题] You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）

A、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC  B、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit  C、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST  D、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST  

点击查看答案
第5题
[单选题] Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

A、You need to perform the restore and recover operations manually, because the backup was made manually.   B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.   C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.   D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.   

点击查看答案
第6题
[填空题] I （） to see a film with my brother last night. (【go】　　我昨晚和哥哥去看电影了。

点击查看答案
第7题
[单选题] A company has a policy that states that all servers will be fully backed up on the weekend.Additionally， all changed items will be backed up each night. In the event of a server failure， the administrator wants to be able to fully recover the system using two restore jobs. Which of the following backup levels should be used nightly？（）

A、Incremental  B、Normal  C、Differential  D、Full  

点击查看答案
第8题
[单选题] Due to operational commitments， a system has a very short backup window during the week， but is not used from Saturday morning through Sunday at Midnight. Which of the following minimizes backup time， while providing the best data restore coverage？（）

A、Full backups every night  B、Differential backups every night  C、Full backup Saturday night， incremental backups the rest of the week  D、Full backup Saturday night， differential backups the rest of the week  

点击查看答案
第9题
[单选题] Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）

A、Restore the data file for the SYSTEM tablespace then open the database.   B、Restore all redo logs form last night's backup, then restart the database.   C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.   D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.   

点击查看答案
第10题
[单选题] You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）

A、Schedule the full backups to run after the nightly index is rebuilt.  B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.  C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.  D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.  

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

请使用微信扫码支付

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