单选题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?()AExecute the query and view Active Session History (ASH) for information about the query.BEnable SQL trace for the query.CCreate a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.DUse the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

单选题
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.


参考解析

解析: 暂无解析

相关考题:

You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.You want to ensure that the journalists can query the database. What should you do?A.Create a new full-text catalog for the Articles databaseB.Rebuild the full-text catalog for the Articles databaseC.Create a new full-text index on the table that holds the text for the articlesD.Repopulate the full-text index on the table that holds the text for the articles

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.

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.

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.

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.

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.

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.

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.

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.

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 performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number (SCN) to which you can flash back your database

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.

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 AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository (AWR) reportD、run the Automatic Database Diagnostic Monitor (ADDM)on top SQL statements

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.

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.

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.

单选题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?()Arun Segment AdvisorBrun SQL Tuning Advisor on top SQL statementsCrun the Automatic Workload Repository (AWR) reportDrun the Automatic Database Diagnostic Monitor (ADDM)on top SQL statements

单选题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?()AConfigure a Linked Server connection to the application database.BWrite a query that uses an OPENDATASOURCE command.CWrite a query that uses an OPENQUERY command.DConfigure a Remote Server connection to the application database.

单选题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?()AExecute the query and view Active Session History (ASH) for information about the query.BEnable SQL trace for the query.CCreate a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.DUse the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

单选题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?()AIn a SQL Trace log file, you should look for queries with low duration values and high read and write values.BIn a query execution plan, you should look for queries with missing or out-of-date statistics.CIn a SQL Trace log file, you should look for queries with high duration values and low read and write values.DIn a query execution plan, you should look for queries with a large number of table scans.

单选题You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number (SCN) to which you can flash back your database

单选题In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()AThe optimizer statistics are collected automatically.BOnly the timed operating system (OS) statistics and plan execution statistics are collected.CThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.DThe snapshots for the Automatic Workload Repository (AWR) are not generated automatically. ESnapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

单选题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.

单选题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.

单选题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.

单选题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?()AUse 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.BUse 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.CModify the format file to specify the same collation as the Dublin database. Import the table again.DModify 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.

单选题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?()AExamine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.BEnable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.CEnable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.DEnable 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.

单选题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?()ATo achieve the goal, a Linked Server connection should be configured to the application database.BTo achieve the goal, a query should be written, and an OPENQUERY command is utilized by the query.CTo achieve the goal, a Remote Server connection to the application database should be configured.DTo achieve the goal, a query should be written, and an OPENDATASOURCE command is utilized by the query.