You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）
- A、Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
- B、Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
- C、Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
- D、Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
相关考题：
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）A. An error is returned.B. You are prompted to enter a new value.C. A report is produced that matches the first report produced.D. You are asked whether you want a new value or if you want to run the report based on the previous value.
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run.The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs.How do you accomplish this?（）A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
You have a computer that runs Windows 7. You manually create a system restore point. You need torestore a copy of a file stored on drive C from two days ago. You must achieve this goal in the minimumamount of time. What should you do?（）A、From Recovery, select System Restore.B、From Backup and Restore, select Restore my files.C、From the command prompt, run Wbadmin get items.D、From the properties of the file, select Previous Versions.
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest named Company.com containing three sites named KingSite1， KingSite2 and KingSite3.The Company.com organization makes use of Microsoft Exchange Server 2007 Service Pack 1 （SP1） as their messaging solution.Company.com has additionally configured each site with two Client Access server， Mailbox server and Hub Transport Server.During the course of the business week you receive instruction from Company.com to install Microsoft Exchange Server 2010 in KingSite1 whilst ensuring that you use the least amount of administrative effort.What should you do？（）A、You should consider having all Exchange servers in the organization upgraded to Microsoft Exchange Server 2007 Service Pack 2 （SP2）.B、You should consider having all Exchange servers in KingSite1 and all Client Access servers in the organization upgraded to Microsoft Exchange Server 2007 Service Pack 2 （SP2）.C、You should consider having all Client Access servers in the organization upgraded to Microsoft Exchange Server 2007 ServicePack 2 （SP2）D、You should consider having all Exchange servers in KingSite1 upgraded to Microsoft Exchange Server 2007 ServicePack 2 （SP2）.
You just purchased a refurbished router that contains a configuration from a previous deployment. What should you do, before entering a new configuration into the router?（）A、RAM should be erased and the router restarted.B、Flash should be erased and the router restarted.C、NVRAM should be erased and the router restarted.D、The new configuration should be entered and saved.
An application fails to start after a Technology Level upgrade. The application vendor recommends that two filesets upgraded as part of the new Technology Level be rejected. What is the recommended method for performing this task?（）A、Run instfix -u to reject the filesets.B、Run installp -r to reject the filesets.C、Run installp -u to uninstall the filesets.D、Restore the system to previous state from the system backup.
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
In which scenario will you perform a user-managed incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period
What does it mean if a backup is expired?（）A、The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B、The backup set has one or more invalid blocks in it and is not usable for recovery. C、The backup set contains one or more tablespaces no longer in the database. D、The backup set contains one or more missing backup set pieces.E、The backup set is from a previous version of RMAN and was not upgraded.
You have a computer that runs Windows XP Professional. You download new video card driver from the Internet, and then install the driver. You restart the computer. You discover that the newly loaded video driver is named VgaSave. You need to restore the previous version of the video card driver.What should you do?（） A、From the Device Manger, scan for hardware changes. B、From the Device Manager, access the video card properties, and then select Roll Back. C、From the Device Manager, access the VgaSave properties, and then run the Hardware Troubleshooter. D、Restart the computer. From the Advanced Startup Options menu, select Last Known Good Configuration.
Your network consists of a single Active Directory domain. You have two file servers named Server1 and Server2 that run Windows Server 2003 Service Pack 2 (SP2). Both servers have a shared folder named Data. You have a computer named Computer1 that runs Windows XP Professional Service Pack 3 (SP3). From Computer1, you view the properties of //server1/data and discover a Previous Versions tab. From Computer1, you view the properties of //server2/data and discover that the Previous Versions tab is missing. You need to ensure that you can access previous versions of files from //server2/data. What should you do? （）A、On Server2, enable Shadow Copies for all volumes.B、On Server2, create an Automated System Recovery (ASR) backup.C、Assign your user account the Full Control share permission to //server2/data.D、On the Customize tab in the //server2/data properties, click Restore Default.
You are the administrator of a Windows Server 2003 computer named Server1. You log on to Server1 and attempt to access the network. You discover that the server is not communicating on the network. You discover that a service pack and an updated network adapter driver were installed on Server1 the previous night. A complete backup, including the System State data, was performed before the service pack and the driver were installed. You need to restore network communications. What should you do first? （）A、Use Roll Back Driver to reinstall the previous driver for the network adapter.B、Use the Backup or Restore Wizard to restore the backup from the previous night.C、Restart Server1 by using the Last Known Good Configuration option.D、Use the Registry Editor to delete the registry settings for the network adapter driver.
You have a file server that runs windows server 2008. A user restores a large file by using the previous versions tab.You need to view the progress of the file restoration. What should you do?（）A、From the command prompt, run shadow.exe /v.B、From the command prompt, run vssadmin.exe query reverts.C、From computer managerment, click on the shared folders node and then click on sessions.D、From computer managerment, click on the shared folders node and then click on open files.
All client computers on your company network were recently upgraded from Windows Vista to Windows7. Several employees use a scanner to import document images into a database. They install a new scanning application on their computers. The application updates the device driver for the scanners as part of the installation process. Employees report that the application can no longer connect to the scanner. You need to ensure that the employees can use the scanner. What should you do?（）A、Roll back the device driver to the previous version.B、Reinstall the application in Windows Vista compatibility mode.C、Set the application compatibility properties to run the application as an administrator.D、Restart the computer by using the System Configuration tool to load only basic devices and services.
You install an application named App1.exe on a computer. After the installation, the computer becomesunresponsive. You restart the computer and attempt to uninstall App1.exe. The uninstallation of App1.exefails. You need to restore the computer to its previous functional state. You must achieve this goal by usingthe minimum amount of administrative effort. What should you do?（）A、From Recovery， restore a system restore point.B、From the Previous Versions tab of App1.exe， click the Restore button.C、Start the computer， press F8 and then use the Last Known Good Configuration.D、Create a system repair disc and then start the computer from the system repair disc.
You have an Exchange Server 2010 Mailbox server.The server is a member of a database availability group （DAG）.The server fails.You install the operating system on a new server and use the same computer name.You join the server to the domain.You need to reinstall Exchange Server 2010 on the server.The solution must ensure that previous Exchange server configurations are applied to the new server.What should you do？（）A、Run setup /RecoverCMSB、Run setup /m：RecoverServerC、Restore the system state from the previous serverD、Install the Exchange management tools and then run the Restore-Computer cmdlet
You have a file server that runs Windows Server 2008. A user restores a large file by using the Previous Versions tab. You need to view the progress of the file restoration what should you do（）？ A、From the command prompt， rum shadow.exe /vB、From the command prompt， run vssadmin.exe query revertsC、From Computer management， click on the shared folders node and then click on sessionsD、From computer management， click on the shared folders node and then click on open files.
You have a computer that runs Windows 7. You add a new hard disk drive to the computer and create anew NTFS partition. You need to ensure that you can use the Previous Versions feature on the new drive. What should you do?（）A、From Disk Management, convert the new disk to a dynamic disk.B、From System Properties, configure the System Protection settings.C、From System and Security, enable BitLocker Drive Encryption (BitLocker).D、From the properties of the new drive, create a share and modify the caching settings.
单选题You have a computer that runs Windows 7. You perform regular data backups and system image backups.The computer experiences a hard disk failure. You replace the failed hard disk. You need to recover thecomputer to the previous Windows 7 environment. You start the computer from the Windows 7 installationmedia. Which recover option should you select?（）ACommand PromptBStartup RepairCSystem Image RecoveryDSystem Restore
单选题You just purchased a refurbished router that contains a configuration from a previous deployment. What should you do, before entering a new configuration into the router?（）ARAM should be erased and the router restarted.BFlash should be erased and the router restarted.CNVRAM should be erased and the router restarted.DThe new configuration should be entered and saved.
单选题You have a computer that runs Windows XP Professional. You download new video card driver from the Internet, and then install the driver. You restart the computer. You discover that the newly loaded video driver is named VgaSave. You need to restore the previous version of the video card driver.What should you do?（）AFrom the Device Manger, scan for hardware changes. BFrom the Device Manager, access the video card properties, and then select Roll Back. CFrom the Device Manager, access the VgaSave properties, and then run the Hardware Troubleshooter. DRestart the computer. From the Advanced Startup Options menu, select Last Known Good Configuration.
单选题You are the network administrator for . You are the administrator of a Windows Server 2003 computer named TestKing8. You log on to TestKing8 and attempt to access the network. You discover that the server is not communicationg on the network. You discover that a service pack and an updated network adapter driver were installed on TestKing8 the previous night. A complete backup, including the System State data, was performed before the service pack and the driver were installed. You need to restore network communications. What should you do first?（）AUse Roll Back Driver to reinstall the previous driver for the network adapter.BUse the Backp or Restore Wizard to restore the backup from the previous night.CRestart TestKing8 by using Last Known Good Configuration option.DUse the Registry Editor to delete the registry settings for the network adapter driver.
单选题In which scenario will you perform a user-managed incomplete recovery？（）A when a table is dropped and stored in the Recycle BinBwhen a table is dropped and purged from the Recycle BinC when you are required to recover an existing table to its previous stateD when you are required to view all the versions of a row of an existing table between a specific time period
单选题Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（）A 13：00 on Tuesday.B 15：00 on Tuesday.C Up until the last available archived redo log on Sunday.D To any point； all the redo should still be available in the online redo logs.E The database is not recoverable.
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）ASet OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.BCapture the plans from the previous version using STS and then load them into the stored outline.CCapture the plans from the previous version using STS and then load them into SQL Management Base (SMB).DSet OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
单选题Your network consists of a single Active Directory domain. You have two file servers named Server1 and Server2 that run Windows Server 2003 Service Pack 2 (SP2). Both servers have a shared folder named Data. You have a computer named Computer1 that runs Windows XP Professional Service Pack 3 (SP3). From Computer1, you view the properties of //server1/data and discover a Previous Versions tab. From Computer1, you view the properties of //server2/data and discover that the Previous Versions tab is missing. You need to ensure that you can access previous versions of files from //server2/data. What should you do? （）AOn Server2, enable Shadow Copies for all volumes.BOn Server2, create an Automated System Recovery (ASR) backup.CAssign your user account the Full Control share permission to //server2/data.DOn the Customize tab in the //server2/data properties, click Restore Default.
单选题Your computer runs Microsoft Windows Vista Home Basic edition. When you attempt to upgrade your computer to Microsoft Windows Vista Ultimate edition by booting from the DVD-ROM， you receive the following warning message： "The partition you selected might contain files from a previous Microsoft Windows installation. If it does， these files and folders will be moved to a folder named Microsoft Windows.old. You will be able to access the information in Microsoft Windows.old， but you will not be able to use your previous version of Microsoft Windows." You need to complete the upgrade. What should you do？ （）ABoot into safe mode. Launch the setup.exe application from the Windows Vista Ultimate edition DVD-ROM.BBoot from the Windows Vista Ultimate edition DVD-ROM and click the command prompt option. Use the diskpart utility to create a new primary partition for the Windows Vista Ultimate edition installation.CLog on to the Windows Vista Home Basic edition installation. Launch the setup.exe application from the Windows Vista Ultimate edition DVD-ROM， and then click the Custom （Advanced） option.DLog on to the Windows Vista Home Basic edition installation. Launch the setup.exe application from the Windows Vista Ultimate edition DVD-ROM， and then click the Upgrade option.
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.