单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）ASet the STATISTICS_LEVEL initialization parameter to ALL.BCreate a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.CDecrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.
单选题
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）
A
Set the STATISTICS_LEVEL initialization parameter to ALL.
B
Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
D
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.
参考解析
解析：
暂无解析
相关考题：
共用题干Energy CycleDo you find getting up in the morning so difficult that it's painful?This might be called laziness, but Dr. Kleitman has a new explanation.He has proved that everyone has a daily energy cycle.During the hours when you labor through your work you may say that you are"hot".That's true.The time of day when you feel most energetic is when your cycle of body temperature is at this peak.For some people the peak comes during the morning. For others it comes in the afternoon or evening. No one has discovered why this is so,but it leads to such familiar words as:"Get up, John!You'll be late for work again!"The possible explanation to the trouble is he is at his tempera-ture-and-energy peak in the evening. Much family quarrelling ends when husbands and wives realize what these energy cycles mean,and which cycle each member of the family has.You can't change your energy cycle,but you can learn to make your life fit it better. Habit can help,Dr. Kleitman believes.Maybe you're sleepy in the evening but feel you must stay up late anyway.Counteract your cycle to some extent by habitually staying up later than you want to.If your energy is low in the morning but you have an important job to do early in the day,rise before your usual hour. This won't change your cycle,but you'll get up steam and work better at your low point.Get off to a slow start,which saves your energy.Get up with a leisurely yawn and stretch.Sit on the edge of the bed a minute before putting your feet on the floor. Avoid the troublesome search for clean clothes by laying them out the night before.Whenever possible,do routine work in the afternoon and save tasks requiring more energy for your sharper hours.If your energy peak is in the evening,you might like to get up late.A:Right B:Wrong C:Not mentioned
共用题干Energy CycleDo you find getting up in the morning so difficult that it's painful?This might be called laziness, but Dr. Kleitman has a new explanation.He has proved that everyone has a daily energy cycle.During the hours when you labor through your work you may say that you are"hot".That's true.The time of day when you feel most energetic is when your cycle of body temperature is at this peak.For some people the peak comes during the morning. For others it comes in the afternoon or evening. No one has discovered why this is so,but it leads to such familiar words as:"Get up, John!You'll be late for work again!"The possible explanation to the trouble is he is at his tempera-ture-and-energy peak in the evening. Much family quarrelling ends when husbands and wives realize what these energy cycles mean,and which cycle each member of the family has.You can't change your energy cycle,but you can learn to make your life fit it better. Habit can help,Dr. Kleitman believes.Maybe you're sleepy in the evening but feel you must stay up late anyway.Counteract your cycle to some extent by habitually staying up later than you want to.If your energy is low in the morning but you have an important job to do early in the day,rise before your usual hour. This won't change your cycle,but you'll get up steam and work better at your low point.Get off to a slow start,which saves your energy.Get up with a leisurely yawn and stretch.Sit on the edge of the bed a minute before putting your feet on the floor. Avoid the troublesome search for clean clothes by laying them out the night before.Whenever possible,do routine work in the afternoon and save tasks requiring more energy for your sharper hours.One can change his energy cycle once he make up his mind.A:Right B:Wrong C:Not mentioned
共用题干Energy CycleDo you find getting up in the morning so difficult that it's painful?This might be called laziness,but Dr. Kleitman has a new explanation. He has proved that everyone has a daily energy cycle.During the hours when you labor through your work you may say that you're“hot”.That's true .The time of day when you feel most energetic is when your cycle of body temperature is at its peak .For some people the peak comes during the morning. For others it comes in the afternoon or evening.No one has discovered why this is so,but it leads to such familiar monologues as:“Get up,John!You'll be late for work again!”The possible explanation to the trouble is that John is at his temperature-and-energy peak in the evening. Much family quarrelling ends when husbands and wives realize what these energy cycles mean,and which cycle each member of the family has.You can't change your energy cycle,but you can learn to make your life fit to it better. Habit can help,Dr. Kleitman believes. Maybe you're sleepy in the evening but you must stay up late anyway .Counteract your cycle to some extent by habitually staying up later than you want to. If your energy is low in the morning but you have an important job to do early in the day,rise before your usual hour. This won't change your cycle,but you'll get up steam and work better at your low point.Get off to a slow start which saves your energy .Get up with a leisurely yawn and stretch.Sit on the edge of the bed a minute before putting your feet on the floor. Avoid the trouble of searching for clean clothes by laying them out the night before .Whenever possible,do routine work in the afternoon and save tasks requiring more energy or concentration for your sharper hours. Which of the following statements is NOT TRUE?A: Getting off to work with a minimum effort helps save one's energy.B: Dr. Kleitman explains why people reach their peak at different hours of day.C: Habit helps a person adapt to his own energy cycle.D: Children have energy cycles,too.
共用题干Energy CycleDo you find getting up in the morning so difficult that it's painful?This might be called laziness,but Dr. Kleitman has a new explanation. He has proved that everyone has a daily energy cycle.During the hours when you labor through your work you may say that you're“hot”.That's true .The time of day when you feel most energetic is when your cycle of body temperature is at its peak .For some people the peak comes during the morning. For others it comes in the afternoon or evening.No one has discovered why this is so,but it leads to such familiar monologues as:“Get up,John!You'll be late for work again!”The possible explanation to the trouble is that John is at his temperature-and-energy peak in the evening. Much family quarrelling ends when husbands and wives realize what these energy cycles mean,and which cycle each member of the family has.You can't change your energy cycle,but you can learn to make your life fit to it better. Habit can help,Dr. Kleitman believes. Maybe you're sleepy in the evening but you must stay up late anyway .Counteract your cycle to some extent by habitually staying up later than you want to. If your energy is low in the morning but you have an important job to do early in the day,rise before your usual hour. This won't change your cycle,but you'll get up steam and work better at your low point.Get off to a slow start which saves your energy .Get up with a leisurely yawn and stretch.Sit on the edge of the bed a minute before putting your feet on the floor. Avoid the trouble of searching for clean clothes by laying them out the night before .Whenever possible,do routine work in the afternoon and save tasks requiring more energy or concentration for your sharper hours.If a person finds getting up early a problem,most probably______.A: he is a lazy personB: he refuses to follow his own cycleC: he is not sure when his energy is lowD: he is at his peak in the afternoon or evening
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid， so would have to be aborted.D、The instance would remain open， but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode. E、The database operates in NOARCHIEVELOG mode.
Your archive-log destination directory runs out of space. What is the impact of this on the database？（） A、 None. The database will switch over to the stand-by archive-log destination directory.B、 A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.C、 The database will shut down，and will not restart until you correct the out-of-space situation.D、 The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.E、 Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A、 ALTER DATABASE DROP LOGFILE GROUP 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）A、Upgrade the hardware/memory to accommodate the data.B、Load the data into your database by using the PARALLEL clause.C、Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.D、Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A、One tablespace has only one datafileB、Many tablespaces can share one datafileC、One tablespace can have many datafilesD、One datafile can contain many tablespaces
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$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do？（）A、Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.B、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.C、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.D、Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.
单选题On a Windows 2000 Professional computer， you run a shipping application that prints packing labels to a laser printer for every outgoing shipment， 24 hours per day. During peak hours， your company ships more than 1，000 packages per hour. You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer. What must you do next？ （）AEnable bi-directional support.BEnable printer pooling.CConfigure print spooling.DConfigure print sharing.
单选题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）AInsert finding directives for ADDM tasks in the future.BCreate a baseline on a pair of snapshots spanning the peak-load period.CDecrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
单选题Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future. What action would you take to achieve this task（）AInsert finding directives for ADDM tasks in the future.BCreate a baseline on a pair of snapshots spanning the peak-load period.CDecrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.
单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）ASet the STATISTICS_LEVEL initialization parameter to ALL.BCreate a baseline on a pair of snapshots that have the statistics of the peakload period in the database.CDecrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
单选题You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）AUse the external table population.BUse the Oracle Data Pump export and import utility.CUse the conventional path data load of the SQL*Loader utility.DUse the INSERT INTO...SELECT command to load the data.
单选题Your archive-log destination directory runs out of space. What is the impact of this on the database?（）ANone. The database will switch over to the stand-by archive-log destination directory. BA warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced. CThe database will shut down, and will not restart until you correct the out-of-space situation. DThe database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. EOnce Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
多选题Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）AUse only the first address.BTry one address，selected at random.CTry each address，in order，until one succeeds.DTry each address，randomly，until one succeeds.
单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）ASet the STATISTICS_LEVEL initialization parameter to ALL.BCreate a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.CDecrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.DSet the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）AUpgrade the hardware/memory to accommodate the data.BLoad the data into your database by using the PARALLEL clause.CGive analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.DUse an external table so you can have the metadata available in your database， but leave the data in the operating system files.
单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）AThe instance would normally abort.BThe instance would not be affected.CThe instance would be invalid， so would have to be aborted.DThe instance would remain open， but the LGWR process would fail.EThe instance would remain open and would automatically create the missing file
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility