CMS专题
单选题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 back
题目
You must have change tracking enabled in your database
Your database must be running in NOARCHIVELOG mode
To back up a tablespace，it must be in backup mode
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.
解析：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
解析：可交付物是指像规格说明书、可行性研究报告、详细设计文档或可运转的原型之类的可测量、可验证的工作产品。
第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.
解析：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