单选题You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）AEnable Memory Access Mode, which reads performance data from SGA.BUse emergency monitoring to fetch data directly from SGA analysis.CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.ERun ADDM in diagnostic mode.
单选题
You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）
A
Enable Memory Access Mode, which reads performance data from SGA.
B
Use emergency monitoring to fetch data directly from SGA analysis.
C
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
D
Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
E
Run ADDM in diagnostic mode.
参考解析
解析：
暂无解析
相关考题：
The following except ( ) are the ones that you will notice as you continue to heal. () A、changes in the appearance of your skin at the surgical siteB、changes in the temperature of your skin around your incisionsC、changes in the feeling of your skin at the surgical siteD、changes in the color of your skin around your incisions
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, 6B. 1, 8, 3, 4, 2, 5, 7, 6C. 1, 3, 4, 2, 8, 5, 6, 7D. 1, 3, 2, 4, 6, 5, 7, 8
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?() A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot
In what courses did your worst grades? Why? How do you think that will affect your performance on the job?
Your company network has 500 client computers that run Windows 7. Your team consists of 20 desktop support technicians. Two technicians troubleshoot a hardware-related performance issue on a computer. The technicians obtain different results by using their own User Defined Data Collector Sets. You need to create a standardized Data Collector Set on a network share that is accessible to your team. What should you create?（）A.Event Trace Data Collector SetB.Performance Counter Data Collector SetC.Performance Counter Alert Data Collector SetD.System Configuration Information Data Collector Set
You need to identify if malware is causing performance issues on your computer.What should you do?() A.AB.BC.CD.D
You have a computer that runs Windows Vista Ultimate.You open the Windows System Performance Rating tool and receive a Windows Experience Index base score of 1.0. The subscores are as follows:·Processor: 4.7·Memory (RAM): 3.6·Graphics: 1.0·Gaming Graphics: 1.0·Primary Hard Disk: 3.0You upgrade your video adapter card with a new card that meets the minimum requirements for Windows Aero.You open the System Performance and Rating tool and notice the base score and subscores have not changed.You need to enable Windows Aero.What should you do?（）A.AB.BC.CD.D
When you notice oil on the water near your vessel while taking on fuel, you should FIRST ______.A.stop loadingB.notify the senior deck officerC.notify the terminal superintendentD.determine whether your vessel is the source
Directions:Suppose you are a librarian in your university.Write a notice of about 100 words,providing the newly-enrolled international students with relevant information about the library.You should write neatly on the ANSWER SHEET.Do not sign your own name at the end of the notice.Use“LI Ming”instead.Do not write the address.
In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？（）A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.
Your organization has 20 servers that run Windows Server 2003 Service Pack 2 (SP2). You need to monitor all 20 servers for a period of 24 hours by using the same performance counters. You must achieve this goal by using the least amount of administrative effort. What should you do first? （）A、In System Monitor, add counters.B、In System Monitor, create a Taskpad.C、In Performance Logs and Alerts, create a trace log.D、In Performance Logs and Alerts, create a counter log.
Your company network has 500 client computers that run Windows 7. Your team consists of 20 desktop support technicians. Two technicians troubleshoot a hardware-related performance issue on a computer. The technicians obtain different results by using their own User Defined Data Collector Sets. You need to create a standardized Data Collector Set on a network share that is accessible to your team. What should you create?（）A、Event Trace Data Collector SetB、Performance Counter Data Collector SetC、Performance Counter Alert Data Collector SetD、System Configuration Information Data Collector Set
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.
问答题Practice 7 Thank you for choosing our restaurant during your visit to London. Services to guests of the restaurant are a large part of our tasks, and we are grateful for the opportunity to serve you. We would like to invite your comments on our performance and to learn from your experiences. Please take a few moments to complete our customer response form so that we may serve you better in the future.
多选题Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）AARCHIVELOG mode.BNOARCHIVELOG mode.COpen database backups.DConsistent whole backups.
单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking a new snapshot and comparing it with a preserved snapshot
多选题In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server？（）Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
单选题The external flotation bladder on an immersion suit should be inflated（）.Abefore you enter the waterBafter you enter the waterCafter one hour in the waterDafter you notice that your suit is losing buoyancy
单选题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？（）Acreate baseline metrics for today’s performanceBwrite the current database metrics to a database table and create a trigger to compare with future database statisticsCwrite the current database metrics to a flat file and create an operating script to compare with future database statisticsDwrite the current database metrics to a database table and create a procedure to compare with future database statisticsEwrite the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
单选题You notice oil on the water near your vessel while taking on fuel. You should first（）.Astop fuelingBnotify the senior deck officerCnotify the terminal superintendentDdeterm ne whether your vessel is the source
单选题When you notice oil on the water near your vessel while taking on fuel, you should FIRST （）.Astop loadingBnotify the senior deck officerCnotify the terminal superintendentDdetermine whether your vessel is the source
单选题You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）AThe database performance would be enhanced.BThe redo log files would be get filled more frequently.CThe overall database performance would be degraded.DThe mean time to recover （MTTR） would be increased.
多选题You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.
问答题You have been asked to organize a special event as part of the school’s English Book Week. Suggestions include a book sale, poetry readings and an opportunity to meet the author of one of your English course books. Write a notice for the school notice board to advertise the event. In your notice: ★ describe the kind of event you are planning ★ state exactly where and when it will be held ★ ask for volunteers to help with preparations ★ say how you can be contacted You should write no fewer than 100 words on the answer sheet.
单选题Your Windows 2000 Professional computer contains a 166 MHz processor 64 MB of RAM and 750 MB of free disk space. You have installed a number of applications on your computer including a word processing program， a spreadsheet program， a third party scientific application and a multimedia player. You notice that when you have several of these applications open simultaneously the performance of your computer is noticeably slower. You run system monitor notice that the processor time and queue counters are showing high readings was blue and red line touching 100%. What should you do to solve this problem？（）AUse diskprode to modify existing disk sector values.BUpgrade your processor.CIncrease the amount of free disk space.DIncrease the amount of RAM.
多选题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.（）AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database