You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:<br /> 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.<br /> 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.<br /> What is the reason for performing these activities? （）..

第1题

[单选题] You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. A member server named TK1 contains a large number of files that are frequently accessed by network users. Users report unacceptable response times on TK1. You compare the current performance of TK1 to a system performance baseline that you created several weeks ago. You decide that TK1 needs a higher-performance network adapter. After you add the appropriate network adapter, users report satisfactory performance. You need to gather new server performance data so you can establish a new performance baseline for TK1. You open the Performance console. What should you do next?（）

A、Add all counters for the Network Interface object to the System Monitor object. B、Create a new trace log object. Under Events logged by system provider in the new object, select the Network TCP/IP setting. Start the trace log. C、Create a new counter log object. Add all counters for the Network Interface object to the new object. Start the counter. D、Create a new alert object.

点击查看答案

第2题

[单选题] Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

A、Perform Export before TSPITR and Import after TSPITR B、Move objects to another schema that has the same tablespace assigned C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN) D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

点击查看答案

第3题

[单选题] Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

A、Perform Export before TSPITR and Import after TSPITR B、Move objects to another schema that has the same tablespace assigned C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN) D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

点击查看答案

第4题

[单选题] The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

A、You should perform a log switch B、You should make a backup of the database C、You should switch the database to the NONARCHIVELOG mode D、You should shut down the database instance and perform a complete database recovery

点击查看答案

第5题

[] Your network contains an application server named Server1 that runs Windows Server 2003 Service Pack (SP2). You open the Performance tab in Task Manager as shown in the exhibit. (Click the Exhibit button.) You need to improve the performance of Server1. What should you do? （） Your network contains an application server named Server1 that runs Windows Server 2003 Service Pack (SP2). You open the Performance tab in Task Manager as shown in the exhibit. (Click the Exhibit button.) You need to improve the performance of Server1. What should you do? （）

A、A. Install additional RAM. B、B. Install a second processor. C、C. Decrease the size of the paging file. D、D. Add the /PAE switch to the Boot.ini file.

点击查看答案

第6题

[单选题] The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

A、You should perform a log switch B、You should make a backup of the database C、You should switch the database to the NONARCHIVELOG mode D、You should shut down the database instance and perform a complete database recovery

点击查看答案

第7题

[] You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（） You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）

A、A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup. B、B. RMAN reads the block change tracking file when it performs both incremental backups. C、C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup. D、D. RMAN does not read the block change tracking file when it performs either incremental backup.

点击查看答案

第8题

[] You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（） You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）

A、A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup. B、B. RMAN reads the block change tracking file when it performs both incremental backups. C、C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup. D、D. RMAN does not read the block change tracking file when it performs either incremental backup.

点击查看答案

第9题

[单选题] You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003. A server named TestKing2 functions as an application server. Users in the TestKing marketing department use an application on TestKing2 to analyze data. The application produces a high volume of disk activity. You give access to 15 new users for the application on TestKing2. Users in the TestKing marketing department report unacceptable delays when they use the application during periods of peak activity. You use System Monitor to analyze the performance of TestKing2. You need to ensure that TestKing2 can support the new users. Which counter should you monitor?（）

A、The % Disk Time counter for the PhysicalDisk performance object B、The Current Disk Queue Length counter for the PhysicalDisk performance object C、The Free Megabytes counter for the LogicalDisk performance object D、The Disk Transfers/sec counter for the LogicalDisk performance object

点击查看答案

第10题

[单选题] You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 runs a custom application. Users report that the performance of Server1 has dropped significantly during the last month. You monitor the server and obtain the data shown in the exhibit. (Click the Exhibit button.) You need to increase the performance of Server1. What should you do?（）

A、Increase the server memory. B、Install an additional processor. C、Install a high performance disk. D、Install an additional network adapter.

点击查看答案

请使用微信扫码支付