单选题A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database insta

第1题：

You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）

• A、 Use SQL Server Profiler to identify missing indexes.
• B、 Use the Database Engine Tuning Advisor to identify missing indexes.
• C、 Use a Dynamic Management View to analyze query plans.
• D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.

第2题：

In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

• A、The optimizer statistics are collected automatically.
• B、Only the timed operating system （OS） statistics and plan execution statistics are collected.
• C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
• D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
• E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

第3题：

第4题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

• A、 The time when the last flashback operation in your database was performed.
• B、 The time when the first flashback operation in your database was performed.
• C、 A list of flashback operations performed in your database using SCN and time.
• D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

第5题：

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.

第6题：

You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）

• A、Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.
• B、Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.
• C、Modify the format file to specify the same collation as the Dublin database. Import the table again.
• D、Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.

第7题：

A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

• A、Execute the query and view Active Session History (ASH) for information about the query.
• B、Enable SQL trace for the query.
• C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
• D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

第8题：

第9题：

These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）

• A、BEGIN_TIME is the time at which Flashback logging is enabled.
• B、END_TIME is the time at which the query is executed on the view.
• C、REDO_DATA is the number of bytes of redo data written during the interval.
• D、This view contains information about flashback data pertaining to the last 24 hours.
• E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

第10题：

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 performed
• B、the time when the first flashback operation in your database was performed
• C、a list of flashback operations performed in your database using SCN and time
• D、the approximate time and the lowest system change number （SCN） to which you can flash back your database