违法和不良信息举报 联系客服
免费注册 登录

单选题Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the 

题目
单选题
Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment， you performed the workload capture on the production database to record the peak workload. You set up the test RAC databaseand want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload：   1） Preprocess the captured workload.  2） Restart the database in RESTRICTED mode. 3） Set up the Replay Clients.  4） Restore the test database to the point when the capture started.  5） Remap connections.   Arrange the steps required in the correct sequence to accomplish this task on the test machine.（）
A

 1，4，5，3 （2 is not required.）

B

 1，4，3，5 （2 is not required.）

C

 1，2，4，5 （3 is not required.）

D

 2，1，5，3，4 

E

 1，2，4，5，3

参考答案和解析
正确答案： A
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

  • A、create baseline metrics for today’s performance
  • B、write the current database metrics to a database table and create a trigger to compare with future database statistics
  • C、write the current database metrics to a flat file and create an operating script to compare with future database statistics
  • D、write the current database metrics to a database table and create a procedure to compare with future database statistics
  • E、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

正确答案:A

第2题：

You work as a database administrator for Certkiller .com. 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.

正确答案:C

第3题：

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.

第4题：

Which two statements about workload capture and replay operations are true?（）

  • A、The clients must be created manually on the test machines to perform more realistic testing.
  • B、Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
  • C、Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
  • D、The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

正确答案:C,D

第5题：

You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

  • A、 0
  • B、 1
  • C、 NONE
  • D、 DEFAULT

正确答案:A

第6题：

You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

  • A、 Reregistering the target database in recovery catalog
  • B、 Transporting the new tablespaces to the recovery catalog database
  • C、 Syncronizing the recovery catalog with the target database control file
  • D、 Performing a fresh backup of the target database to include the new data files in the catalog database

正确答案:C,D

第7题：

You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）

  • A、owner
  • B、touser
  • C、include
  • D、schemas
  • E、fromuser
  • F、transform
  • G、remap_schema
  • H、remap_datafile
  • I、reuse_datafiles
  • J、remap_tablespace

正确答案:G

第8题：

You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  • A、 mount the new disk group in the ASM instance
  • B、 restart the ASM instance and the production database instance
  • C、 register the new disk groups in the production database instance
  • D、 restart the ASM instance without restarting the production database instance
  • E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

正确答案:A

第9题：

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

  • A、Open the database in NORMAL mode
  • B、Open the database in read-only mode
  • C、Open the database in RESTRICTED mode
  • D、Open the database with the RESETLOGS option

正确答案:D

第10题：

You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

  • A、 BACKUP AS BACKUPSET
  • B、 BACKUP AS COPY
  • C、 BACKUP AS COMPRESSED BACKUPSET
  • D、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

正确答案:B

更多相关问题
相关内容