网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
One of the difficulties in building an SQL,like query language for the Web is the absence of a database(71) for this huge, heterogeneous repository of information. However, if we are interested in HTML documents only, we can construct a virtual schema from the implicit structure of these files. Thus, at the highest level of(72) , every such document is identified by its Uniform. Resource Locator(URL), has a(73) and a text. Also, Web servers provide some additional information such as the type, length, and the last modification date of a document. So, for data mining purposes, we can consider the set of all HTML documents as a relation:Document(url, title, text, type, length, modif)Where all the(74) are character strings. In this framework, an individual document is identified with a(75) in this relation. Of course, if some optional information is missing from the HTML document, the associate fields will be left blank, but this is not uncommon in any database.
A．schema
B．platform
C．module
D．relation
参考答案
更多 “ One of the difficulties in building an SQL,like query language for the Web is the absence of a database(71) for this huge, heterogeneous repository of information. However, if we are interested in HTML documents only, we can construct a virtual schema from the implicit structure of these files. Thus, at the highest level of(72) , every such document is identified by its Uniform. Resource Locator(URL), has a(73) and a text. Also, Web servers provide some additional information such as the type, length, and the last modification date of a document. So, for data mining purposes, we can consider the set of all HTML documents as a relation:Document(url, title, text, type, length, modif)Where all the(74) are character strings. In this framework, an individual document is identified with a(75) in this relation. Of course, if some optional information is missing from the HTML document, the associate fields will be left blank, but this is not uncommon in any database.A．schemaB．platformC．moduleD．relation ” 相关考题
考题
WebSQL is a SQL-like （71） language for extracting information from the web. Itscapabilities for performing navigation of web （72） make it a useful tool for automatingseveral web-related tasks that require the systematic processing of either all the links in a（73） , all the pages that can be reached from a given URL through （74） that match apattern, or a combination of both. WebSQL also provides transparent access to index servers thatcan be queried via the Common （75） Interface.（71）A. query B. transaction C. communication D. programming（72）A. browsers B. servers C. hypertexts D. clients（73）A. hypertext B. page C. protocol D. operation（74）A. paths B. chips C. tools D. directories（75）A. Router B. Device C. Computer D. Gateway
考题
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.
考题
Which three functions are performed by the SQL Tuning Advisor? ()
A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans
考题
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)
A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans
考题
Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?()
A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.
考题
One of the difficulties in building an SQL-like query lange for the Web is the absence of a database schema for this huge, heterogeneous repository of information. However, if we are interested in HTML documents only, we can construct a virtual(66)from the implicit structure of these files. Thus, at the highest level of(67), every such document is identified by its Uniform. Resource Locator(URL), has a title and a text Also, Web servers provide some additional information such as the type, length, and the last modification date of a document. So, for data mining purposes, we can consider the site of all HTML documents as arelation:Document(url,(68), text, type, length, modify)Where all the(69)are character strings. In this framework, anindividual document is identified with a(70)in this relation. Of course, if some optional information is missing from the HTML document, the associate fields will de left blank, but this is not uncommon in any database.A．schemaB．relationC．platformD．module
考题
One of the difficulties in building an SQL-like query language for the Web is the absence of a database(131)for this huge, heterogeneous repository of information. However, if we are interested in HTML documents only, we can construct a virtual schema from the implicit structure of these files. Thus, at the highest level of(132), every such document is identified by its Uniform. Resource Locator(URL), and a(133)and a text. Also, Web severs provide some additional information such as the type, length, and the last modification date of a document. So for data mining purposes, we can consider the set of all HTML documents as a relation:Document(url, rifle, text, type, length, modif)Where all the(134)are character strings. In this framework, an individual document is identified with a(135)in this relation. Of course, if some optional information is missing from the HTML document, the associate fields will be left blank, but this is not uncommon in any database.A．schemaB．platformC．moduleD．relation
考题
The Semantic Web will be superior to today’s web in that it _____.［A］surpasses people in processing numbers［B］fulfills user’s original expectations［C］deals with language and reason as well as number［D］responds like a rebellious adult
考题
Which two statements about subqueries are true? （）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
考题
Which three functions are performed by the SQL Tuning Advisor? （）A、Building the SQL profileB、Recommending optimization of materialized viewsC、Checking query objects for missing and stale statisticsD、Recommending bitmap, function-based, and B-tree indexesE、Recommending restructuring SQL queries that are using bad plans
考题
Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)A、Building the SQL profileB、Recommending optimization of materialized viewsC、Checking query objects for missing and stale statisticsD、Recommending bitmap, function-based, and B-tree indexesE、Recommending restructuring SQL queries that are using bad plans
考题
Which three functions are performed by the SQL Tuning Advisor?（）A、Building and implementing SQL profilesB、Recommending the optimization of materialized viewsC、Checking query objects for missing and stale statisticsD、Recommending bitmap, function-based, and B-tree indexesE、Recommending the restructuring of SQL queries that are using bad plans
考题
关系数据库标准语言SQL是哪一项的缩写形式？（）A、Structured Query LanguageB、Standard Query LanguageC、Selected Query LanguageD、Seeking Query Language
考题
Which statement is true when you run the SQL Tuning Advisor with limited scope？（）A、Access path analysis is not performed for the SQL statements.B、SQL structure analysis is not performed for the SQL statements.C、SQL Profile recommendations are not generated for the SQL statements.D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
考题
Which two statements about subqueries are true? （）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
考题
Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
考题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）A、one that uses an internal SQL Server Web service endpointB、one that runs a SQL Server Integration Services （SSIS） packageC、one that uses Service BrokerD、one that runs a user-defined function
考题
单选题Which statement is true when you run the SQL Tuning Advisor with limited scope？（）A
Access path analysis is not performed for the SQL statements.B
SQL structure analysis is not performed for the SQL statements.C
SQL Profile recommendations are not generated for the SQL statements.D
The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
考题
单选题WebSQL is a SQL-like （1） language for extracting information from the web. Its capabilities for performing navigation of web （2） make it a useful tool for automating several web-related tasks that require the systematic processing of either all the links in a （3）, all the pages that can be reached from a given URL through （4） that match a pattern, or a combination of both. WebSQL also provides transparent access to index servers that can be queried via the Common （5） Interface.A
queryB
transactionC
communicationD
programming
考题
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.CA SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
考题
单选题You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（ ）;You need to execute a method named Do Work（ ） that takes one second to run while the SQL query is executing. DoWork（ ） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）A
while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；B
while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；C
while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；D
while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
考题
多选题Which two statements about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
考题
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
考题
填空题SQL是Structured Query Language（）的缩写。
热门标签
最新试卷