单选题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
题目
Execute the query and view Active Session History (ASH) for information about the query.
Enable SQL trace for the query.
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
Use 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 insta”相关问题
-
第1题：
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.
正确答案:D -
第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.
正确答案:D -
第3题：
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.
正确答案:D -
第4题：
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.
正确答案:B -
第5题：
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.
正确答案:B -
第6题：
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.
正确答案:D -
第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？（）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.
正确答案： C解析： 暂无解析 -
第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. 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.
正确答案： A解析： 暂无解析 -
第9题：
单选题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 performed
Bthe time when the first flashback operation in your database was performed
Ca list of flashback operations performed in your database using SCN and time
Dthe approximate time and the lowest system change number （SCN） to which you can flash back your database
正确答案： D解析： 暂无解析 -
第10题：
单选题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？（）AUse SQL Server Profiler to identify missing indexes.
BUse the Database Engine Tuning Advisor to identify missing indexes.
CUse a Dynamic Management View to analyze query plans.
DUse a DynamicManagement View to ascertain the number of pending I/O requests.
正确答案： A解析： 暂无解析 -
第11题：
单选题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？（）AThe time when the last flashback operation in your database was performed.
BThe time when the first flashback operation in your database was performed.
CA list of flashback operations performed in your database using SCN and time.
DThe approximate time and the lowest system change number （SCN） to which you can flash back your database.
正确答案： D解析： 暂无解析 -
第12题：
单选题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.
正确答案： D解析： 暂无解析 -
第13题：
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.
正确答案:C -
第14题：
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.
正确答案:C,D -
第15题：
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
正确答案:D -
第16题：
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
正确答案:B -
第17题：
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.
正确答案:C -
第18题：
单选题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 Advisor
Brun SQL Tuning Advisor on top SQL statements
Crun the Automatic Workload Repository （AWR） report
Drun the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
正确答案： B解析： 暂无解析 -
第19题：
单选题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解析： 暂无解析 -
第20题：
单选题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.
正确答案： B解析： 暂无解析 -
第21题：
单选题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.
正确答案： C解析： 暂无解析 -
第22题：
单选题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？（）AQuery the V$FLASHBACK_DATABASE_LOG view.
BQuery the V$FLASHBACK_DATABASE_STAT view.
CCheck the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
DQuery the V$RECOVERY_FILE_DEST view.
正确答案： D解析： 暂无解析 -
第23题：
单选题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.
正确答案： A解析： 暂无解析 -
第24题：
单选题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.
正确答案： D解析： 暂无解析