题目
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
第1题
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
第2题
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
第3题
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
第4题
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.
第5题
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.
第6题
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.
第7题
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
第8题
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.
第9题
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.
第10题
A. Create a spanned volume.
B. Create a stripped volume.
C. Create a mirrored volume.
D. Create a RAID-5 volume.
第11题
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.
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!