Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the

recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

A. statistics recommendations

B. SQL Profile recommendations

C. Index-related recommendations

D. restructuring of SQL recommendations

stance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

A. statistics recommendations

B. SQL profile recommendations

C. index-related recommendations

D. restructuring of SQL recommendations

Your organization has an Active Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2.You need to deploy Microsoft Application Virtualization (App-V) 4.6 in a stand-alone configuration.Which should you install？（）

A.Microsoft Application Virtualization Database

B.Microsoft Application Virtualization Desktop Client

C.Microsoft System Center Application Virtualization Streaming Server

D.Microsoft System Center Application Virtualization Management Server

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（）

A. Create two custom ADDM tasks.

B. Modify the AWR snapshot time interval to two hours.

C. Create a new scheduler window for a time period of two hours.

D. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

ing application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.

You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.

You cannot make any changes to the database, but you need to implement replication. Which two actions should you take？ (Each correct answer presents part of the solution. Choose two)

A．Implement merge replication.

B．Implement snapshot replication.

C．Implement transactional replication.

D．Schedule replication to run continuously.

E．Schedule replication to run during off-peak hours.

aded.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.

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file.Which option must you consider for this task？（）

A. using only the RMAN SWITCH command to set the new location for the data file

B. placing the database in the MOUNT state for the restore and recovery operations.

C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

D. configuring two channels: one for the restore operation and the other for the recovery operation

ently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance？（）

A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B. Run the Automatic Workload Repository Monitor (ADDM).

C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

named TK1 contains a mirrored volume that consists of two 36-GB disks.Both disks are used for data storage. TK1 also contains a third unallocated dynamic disk. Next week, a database that currently requires 45 GB of disk space will be installed on TK1. This database will grow at a rate of 10 percent every 6 months.You need to realocate disk space on TK1. Your realocation must satisfy the space requirements of the new database, and it must also ensure that data will remain available in case of disk failure.First, you break the mirror and delete all volumes on the disks.What should you do next？（）

A. Create a spanned volume.

B. Create a stripped volume.

C. Create a mirrored volume.

D. Create a RAID-5 volume.

following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:Which statement describes the consequence？（）

A. The command produces an error.

B. The calibration process runs successfully and populates all the bind variables.

C. The calibration process runs successfully but the latency time is not computed.

D. The calibration process runs successfully but only the latency time is computed.Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles.

r 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.

During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.

You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.

What should you do？

A．Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.

B．Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.

C．Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.

D．Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.