违法和不良信息举报 联系客服
免费注册 登录

A new report process containing a complex query is written,

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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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 database

B．Rebuild the full-text catalog for the Articles database

C．Create a new full-text index on the table that holds the text for the articles

D．Repopulate the full-text index on the table that holds the text for the articles


正确答案：D
解析：Explanation: Backing up a database does not back up full-text index data in full-text catalogs. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. However, if full-text indexes have been defined for tables, the metadata for the full-text index definitions are stored in the system tables in the database containing the full-text indexes. After a database backup is restored, the full-text index catalogs can be re-created and repopulated.

Note 1:
Setting up a full-text search is a three-step procedure:

1. Make sure that the full-text indexing feature has been installed with your SQL Server.
The full-text index is installed as a service in the system. It would not have to be reinstalled after restoring a database.

2. Create a catalog in the operating system to store the full-text indexes.
A catalog can contain the indexes from one or more tables, and it is treated as a unit for maintenance purposes. In general, you shouldn't need more than one catalog per database.
The catalog is saved outside the database on separate files

3. Before you can implement a full-text search in a given database, you must ensure that the full-text search indexes are populated regularly.
In this scenario we must recreate the index by repopulating the full-text catalog.

Note 2: A SQL Server 2000 full-text index provides support for sophisticated word searches in character string data. The full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words. The full-text indexes are contained in full-text catalogs. Full-text catalogs and indexes are not stored in the database to which they belong. The catalogs and indexes are managed separately by the Microsoft Search service. Backing up a database does not back up full-text index data in full-text catalogs. However, if full-text indexes have been defined for tables, the meta. data is backed up when a database backup is created.

Incorrect Answers:
A: The catalog already exists. The catalog is stored outside SQL server and would not be affected by the failure and restoration of the database.

B: Rebuildning the full text catalog will not enable the Journalist to run the full-text queries. The catalogs would have to be repopulated as well.

C: The index should be repopulated since it already exists from the backup. There is no need to recreate it.

第2题：

when a string constant is written in C program, the eompiler creates(75)of characters containing the characters of the string, and terminating it with "\0".

A．a group

B．an array

C．a set

D．a series


正确答案：B
解析：译文：当在C语言中书写一个字符串变量时，编译器创建一个字符数组，它包含了字符串中的字符，并以“\0”结尾。

第3题：

●when a string constant is written in C program，the compiler creates (75) of characters containing the characters of the string，and terminating it with"＼0"．

(75) A．a group

B．an array

C．a set

D．a series


正确答案：B

【解析】译文：当在C语言中书写一个字符串变量时，编译器创建一个字符  数组  ，它包含了字符串中的字符，并以"＼0"结尾。

第4题：

When a string constant is written in C program, the compiler creates ______ of characters containing the characters of the string, and terminating it with "\0".

A．a group

B．an array

C．a set

D．a series


正确答案：B
解析：译文的含义是：在使用C语言编写的字符串常量时，编译器会创建字符()，该数组中包含字符串字符，并使用\0来终止。选项A～D的含义分别是一组、一个数组、一个集合、一个系列。

第5题：

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

第6题：

You ( ) such a long report.The new boss never likes reading a report over 200 words, but you’ve written more than 500

A、needn't have written

B、needn’t write

C、didn't need write

D、didn’t need to write


参考答案：A

第7题：

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?()

A.Mysqlaccess

B.Mysqldump

C.Mysqlshow

D.Mysqlslow

E.Mysqldumpslow


参考答案：E

第8题：

打开报表设计器的命令是（ ）。

A)CREATE REPORT

B)NEW REPORT

C)REPORT FORM

D)START REPORT


正确答案：A

第9题：

In C language，functions are important because they provide a way to(69)code so that a large complex program can be written by combining many smaller parts．

A．modify

B．modularize

C．block

D．board


正确答案：B
解析：在C语言中，函数是很重要的。因为函数具有把代码模块化的功能，通过代码模块化，一个大且复杂的程序能够写成多个小程序的组合。

第10题：

In C language, functions are important because they provide a way to ______ code so that a large complex program can be written by combining many smaller parts.

A．modify

B．modularize

C．block

D．board


正确答案：B
解析：译文的含义是：在C语言中，函数是很重要的，它具有把代码()的功能，因此，一个大而复杂的程序能够由多个小程序组合而成。很显然，这里应该填的是“模块化”，英文应写为modularize，故本题应该选择B。

更多相关问题
相关内容