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

You are working on a 24X7 database. You want to design a bac

题目
单选题
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.  Which statement about performing user-managed backups in a 24x7 environment is true？（）
A

 You must have change tracking enabled in your database

B

 Your database must be running in NOARCHIVELOG mode

C

 To back up a tablespace，it must be in backup mode

D

 To back up a tablespace，it must first be taken offline

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

第1题：

You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?

A．Increase the maximum file size of Sales_Data to 1,500MB.

B．Use the DBCC SHRINKDATABASE statement.

C．Set automatic file growth to 10 percent.

D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.


正确答案：A
解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

Incorrect Answers:
B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

C: The database is already set to automatic file growth, but it has reached the maximum size.

D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.

第2题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第3题：

is a measurable, verifiable work product such as a specification, feasibility study report, detail design document, or working prototype.

A．Milestone

B．Deliverable

C．ETC

D．BAC


正确答案：B
解析：可交付物是指像规格说明书、可行性研究报告、详细设计文档或可运转的原型之类的可测量、可验证的工作产品。

第4题：

In which two cases would you perform only consistent backup？（）

  • A、You are working on a database where downtime is not tolerated.
  • B、You are working on a database where downtime can be tolerated.
  • C、You are working on a database that operates in ARCHIVELOG mode.
  • D、You are working on a database that operates in NOARCHIVELOG mode.
  • E、You are working on a database where all the tablespaces are locally managed.
  • F、You are working on a database where control files and redo log files are multiplexed.
  • G、You are working on a database where control files and redo log files are not multiplexed.

正确答案:B,D

第5题：

If an existing script is uploaded to the CRS, what does it ask?（）

  • A、Do you want to debug the script?  
  • B、Do you want to refresh the script?  
  • C、Do you want to save the application?  
  • D、Do you want to return to Script Management? 

正确答案:B

第6题：

Your personal history says you've been working at the ** company for the past two years. Why do you want to change jobs?


正确答案：
       

第7题：

When you want to saw metal, （）will be used.

  • A、the hack saw
  • B、the hand saw
  • C、the wood working saw
  • D、wood saw

正确答案:A

第8题：

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do?

A．Enable the torn page detection database option for each database.

B．Disable write caching on all disk controllers.

C．Ensure that write caching disk controllers have battery backups.

D．Create a database maintenance plan to check database integrity and make repairs each night.


正确答案：C
解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.

第9题：

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

  • A、 SQL Tuning Advisor
  • B、 Undo Advisor
  • C、 ADDM
  • D、 Memory Advisor

正确答案:D

第10题：

You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）

  • A、FULL
  • B、SCHEMAS
  • C、REMAP_SCHEMA
  • D、REMAP_DATAFILES
  • E、REMAP_TABLESPACE

正确答案:C

更多相关问题
相关内容