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 instanc

第1题：

You can control instance recover performance by setting parameters to define targets for（）

• A、The size of the redo buffer in SGA. 
• B、The instance that will perform recovery in Real Application Cluster database. 
• C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 
• D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

第2题：

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.

第3题：

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.

第4题：

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

第5题：

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

• A、run Segment Advisor
• B、run SQL Tuning Advisor on top SQL statements
• C、run the Automatic Workload Repository （AWR） report
• D、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

第6题：

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

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

第7题：

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）

• A、Configure a Linked Server connection to the application database.
• B、Write a query that uses an OPENDATASOURCE command.
• C、Write a query that uses an OPENQUERY command.
• D、Configure a Remote Server connection to the application database.

第8题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）

• A、To achieve the goal， a Linked Server connection should be configured to the application database.
• B、To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.
• C、To achieve the goal， a Remote Server connection to the application database should be configured.
• D、To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

• A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
• B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
• C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
• D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.

第15题：

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.

第16题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

• A、 Query the V$FLASHBACK_DATABASE_LOG view.
• B、 Query the V$FLASHBACK_DATABASE_STAT view.
• C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• D、 Query the V$RECOVERY_FILE_DEST view.

第17题：

Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）

• A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
• B、The optimizer can re optimize a query only once using cardinality feedback.
• C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.
• D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
• E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

第18题：

A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）

• A、The Query Cache is pruning queries due to an increased number of requests
• B、Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
• C、Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
• D、The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution

第19题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）

• A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.
• B、In a query execution plan， you should look for queries with missing or out-of-date statistics.
• C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.
• D、In a query execution plan， you should look for queries with a large number of table scans.

第20题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

• A、You should configure the database for Read Committed Snapshot isolation. 
• B、You should modify the stored procedure to use the Snapshot isolation level 
• C、You should configure the database for Auto Update Statistics asynchronously 
• D、You should modify the stored procedure to use the Repeatable Read isolation level

第21题：

第22题：

第23题：