单选题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.W

题目

单选题

You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.Which type of backup should you perform?（）

standard backup set

image copy

compressed backup

user-managed backup

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）

A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
B、 Just back up the database datafiles without shutting down the database.
C、 You will have to wait until you can shut down the database to perform the backup.
D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

正确答案:C

第2题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）

A、to enable operating system authentication for a remote client
B、to restrict the scope of administration to identical operating systems
C、to allow the start up and shut down of the database from a remote client
D、to enable the administration of the operating system from a remote client
E、to disable the administration of the operating system from a remote client

正确答案:A

第3题：

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）

A. 8, 1, 3, 2, 4, 5, 7, 6

B. 1, 8, 3, 4, 2, 5, 7, 6

C. 1, 3, 4, 2, 8, 5, 6, 7

D. 1, 3, 2, 4, 6, 5, 7, 8

参考答案：A

第4题：

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

正确答案:C

第5题：

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

A、 redo log files
B、 password file
C、 control file
D、 change tracking file

正确答案:D

第6题：

As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）

A、 Shut down the database
B、 Clear the online redo log
C、 Back up the database
D、 Checkpoint the database
E、 Call Oracle support

正确答案:D

第7题：

If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
C、 The next time you connect RMAN to just the recovery catalog
D、 The next time you connect to the recovery catalog and the target database with RMAN
E、 Connecting to the recovery catalog and issuing the resync all databases command

正确答案:A,B

第8题：

You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.

To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.

You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)

A．Perform. a combination of full database and filegroup backups.

B．Perform. a combination of full database and file backups.

C．Perform. a combination of full database, differential, and transaction log backups.

D．Back up the data to a local tape drive.

E．Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.

正确答案：CE
解析：Explanation:
C: Most OLTP backup schemes include a full database, differential, and transaction log backups

E: In order to recover the data as quickly as possibly we backup the data to network share, and then backup that share to tape. This minimizes the impact of the backup process on the SQL Server computer.

Note 1: SQL Server 2000 provides three database recovery models. These are the Simple recovery model, the Full Recovery Model and the Bulk-Logged Recovery model. Simple Recovery requires the least administration. In the Simple Recovery model, data is recoverable only to the last full database or differential backup. Transaction log backups are not used, and consequently, minimal transaction log space is required.

This Recovery Model is not an appropriate choice for production systems where loss of recent changes is unacceptable. Full Recovery and Bulk-Logged Recovery models provide the greatest protection for data. These models rely on the transaction log to provide full recoverability and to prevent work loss in the broadest range of failure scenarios.

The Full Recovery model provides the most flexibility for recovering databases to an earlier point in time. The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations. It does this at the expense of some flexibility of pointin- time recovery. In this scenario we would want to implement the Full Recovery model as this Recovery model provides complete protection against media failure and provides the ability to recover the database to the point of failure or to a specific point in time.

To guarantee this degree of recoverability, all operations are fully logged. The backup strategy for full recovery consists of database backups, differential backups, which are optional, and transaction log backups. The differential backups are optional but have less of an effect on the system while they run, as they are smaller than full database backups.

This is because a differential backup creates a copy of all the pages in a database modified after the last database backup. A transaction log backup makes a copy only of the log file and backs up the changes made to the database after the last full or differential database backup. A log file backup cannot be used by itself to restore a database. A log file is used after a database restore to recover the database to the point of the original failure. The full database, differential, and transaction log backups can be written to a hard disk or other disk storage media such as a tape drive.

Disk backup devices can be defined on a local disk of a server or on a remote disk on a shared network resource. Tape backup devices are used in the same way as disk devices, with the exception that the tape device must be connected physically to the computer running an instance of SQL Server. SQL Server 2000 thus does not support backing up to remote tape devices.

Note 2, file backup, filegroup backup: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database. This is a complex backup and the restore process that is usually reserved for large databases with high availability requirements. If the time available for backups is not long enough to support backing up the full database, subsets of the database can be backed up at different times. If a disk holding database files or filegroups fails, the site can restore just the lost files or filegroups. This allows for a quicker recovery because only the damaged files or filegroups are restored in the first step, not the entire database.

Incorrect Answers:
A: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.

B: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.

D: Backing up to a local tape device would minimize cost but it would compared to a backup to a network it would decrease performance of the server more, and it would take more time to recover.

第9题：

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

A、 backup database all
B、 backup compressed database
C、 backup as compressed backupset database
D、 backup as compressed backup database plus archivelog all
E、 backup as compressed backupset database plus compress archivelog all

正确答案:C

第10题：

You want to perform a backup of your database to tape. Which backup format can you use？（）

A、backup set only
B、image copy only
C、only user-managed backup
D、both image copy and backup set
E、only incremental image copy backup

正确答案:A

You want to back up your 100-GB database on a remote tape de

题目

相似问题和答案

更多相关问题

相关内容