单选题A subquery can be used to （）.A Create groups of dataB Sort data in a specific orderC Convert data to a different formatD Retrieve data based on an unknown condition

题目
单选题
A subquery can be used to （）.
A

Create groups of data

B

Sort data in a specific order

C

Convert data to a different format

D

Retrieve data based on an unknown condition

相似考题

1.An application architecture specifies the technologies to be used to implement one or more information systems． It serves as an outline for detailed design， construction， and implementation． Given the models and details， include（ ）， we can distribute data and processes to create a general design of application architecture． The design will normally be constrained by architecture standards， project objectives， and （ ）． The first physical DFD to be drawn is the（ ）． The next step is to distribute data stores to different processors． Data（ ） are two types of distributed data which most RDBMSs support． There are many distribution options used in data distribution． In the case of （ ）we should record each table as a data store on the physical DFD and connect each to the appropriate server．A.logical DFDs and ERDB.ideal object model and analysis class modelC.use case models and interface prototypesD.physical DFDs and database schemaA.the database management systemB.the feasibility of techniques usedC.the network topology and technologyD.the user interface and process methodsA.context DFDB.system DFDC.network architecture DFDD.event-response DFDA.vertical partitioning and horizontal replicationB.vertical replication and horizontal partitioningC.integration and distributionD.partitioning and replicationA.storing all data on a single serverB.storing specific tables on different serversC.storing subsets of specific tables on different serversD.duplicating specific tables or subsets on different servers

2.An application architecture specifies the technologies to be used to implement one or more information systems. It serves as an outline for detailed design, construction, and implementation. Given the models and details, include （ ）, we can distribute data and processes to create a general design of application architecture. The design will normally be constrained by architecture standards, project objectives, and （ ）. The first physical DFD to be drawn is the （ ）. The next step is to distribute data stores to different processors. Data（请作答此空）are two types of distributed data which most RDBMSs support. There are many distribution options used in data distribution. In the case of（ ）, we should record each table as a data store on the physical DFD and connect each to the appropriate server.A.vertical partitioning and horizontal replication B.vertical replication and horizontal partitioning C.integration and distribution D.partitioning and replication

3.An application architecture specifies the technologies to be used to implement one or more information systems. It serves as an outline for detailed design, construction, and implementation. Given the models and details, include （ ）, we can distribute data and processes to create a general design of application architecture. The design will normally be constrained by architecture standards, project objectives, and （ ）. The first physical DFD to be drawn is the （ ）. The next step is to distribute data stores to different processors. Data（ ）are two types of distributed data which most RDBMSs support. There are many distribution options used in data distribution. In the case of（请作答此空）, we should record each table as a data store on the physical DFD and connect each to the appropriate server.A.storing all data on a single server B.storing specific tables on different servers C.storing subsets of specific tables on different servers D.duplicating specific tables or subsets on different servers

4.A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.A.OLTPsB.transactionsC.data sartsD.OLAPs

参考答案和解析
正确答案： D
解析： 暂无解析
更多“单选题A subquery can be used to （）.A Create groups of dataB Sort data in a specific orderC Convert data to a different formatD Retrieve data based on an unknown condition”相关问题

  • 第1题：

    A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.

    • A、OLTPs
    • B、transactions
    • C、data sarts
    • D、OLAPs

    正确答案:C

  • 第2题：

    Which three statements are true regarding subqueries?（）

    • A、Subqueries can contain GROUP BY and ORDER BY clauses 
    • B、Main query and subquery can get data from different tables 
    • C、Main query and subquery must get data from the same tables 
    • D、Subqueries can contain ORDER BY but not the GROUP BY clause 
    • E、Only one column or expression can be compared between the main query and subquery
    • F、 Multiple columns or expressions can be compared between the main query and subquery

    正确答案:A,B,E

  • 第3题：

    Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）

    • A、 It can be used to back up all data on ASM disks.
    • B、 It can be used to recover the damaged ASM disk group along with the data.
    • C、 It can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.
    • D、 It can be used to re-create the ASM disk group with its attributes.

    正确答案:C,D

  • 第4题：

    The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）

    • A、The data file cannot be recovered.
    • B、The date file can be restored from theSYSTEMauto backup.
    • C、Take thetablespaceoffline，drop，kand re-create it.
    • D、Recovery Manager （RMAN） is used to recover the data file.
    • E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

    正确答案:A

  • 第5题：

    The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）

    • A、The data file cannot be recovered.
    • B、The date file can be restored from the SYSTEM auto backup.
    • C、Take thetablespaceoffline，drop，kand re-create it.
    • D、Recovery Manager （RMAN） is used to recover the data file.
    • E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

    正确答案:A

  • 第6题：

    You work in a company which 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 management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（） 

    • A、You should create a cached data collection
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection 
    • D、You should create two different SQL Agent jobs that are scheduled stimultaneously

    正确答案:A

  • 第7题：

    单选题
    A subquery can be used to （）.
    A

    Create groups of data

    B

    Sort data in a specific order

    C

    Convert data to a different format

    D

    Retrieve data based on an unknown condition


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）
    A

    Specify a view based on the archival data table and current data tables.

    B

    Specify that the data must be queried by using a stored procedure.

    C

    Specify that both the archival data table and the current data tables must have indexes created on the same columns.

    D

    Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.


    正确答案： A
    解析： 暂无解析

  • 第9题：

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


    正确答案： F,A
    解析： 暂无解析

  • 第10题：

    单选题
    You work in a company which 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 management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（）
    A

    You should create a cached data collection

    B

    You should create an on-demand non-cached data collection 

    C

    You should create a scheduled non-cached data collection 

    D

    You should create two different SQL Agent jobs that are scheduled stimultaneously


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）
    A

    The data file cannot be recovered.

    B

    The date file can be restored from theSYSTEMauto backup.

    C

    Take thetablespaceoffline，drop，kand re-create it.

    D

    Recovery Manager （RMAN） is used to recover the data file.

    E

    The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    Which three statements are true regarding subqueries?（）
    A

    Subqueries can contain GROUP BY and ORDER BY clauses

    B

    Main query and subquery can get data from different tables

    C

    Main query and subquery must get data from the same tables

    D

    Subqueries can contain ORDER BY but not the GROUP BY clause

    E

    Only one column or expression can be compared between the main query and subquery

    F

    Multiple columns or expressions can be compared between the main query and subquery


    正确答案： B,D
    解析： 暂无解析

  • 第13题：

    Which of the following BEST describes a hub?（）

    • A、Determines the best route to transmit data
    • B、Inspects traffic and accepts or declines transmission
    • C、Broadcasts data to specific network devices
    • D、Broadcasts data to all network devices

    正确答案:D

  • 第14题：

    A subquery can be used to（）.

    • A、Create groups of data
    • B、Sort data in a specific order
    • C、Convert data to a different format
    • D、Retrieve data based on an unknown condition

    正确答案:D

  • 第15题：

    Which three statements about subqueries are true? （）

    • A、A main query can have more than one subquery.
    • B、A subquery can have more than one main query.
    • C、The subquery and main query must retrieve data from the same table.
    • D、The subquery and main query can retrieve data from different tables.
    • E、Only one column or expression can be compared between the subquery and main query.
    • F、Multiple columns or expression can be compared between the subquery and main query.

    正确答案:A,C,E

  • 第16题：

    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.

    正确答案:B,D

  • 第17题：

    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.

    正确答案:D,F

  • 第18题：

    You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）

    • A、Specify a view based on the archival data table and current data tables.
    • B、Specify that the data must be queried by using a stored procedure.
    • C、Specify that both the archival data table and the current data tables must have indexes created on the same columns.
    • D、Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

    正确答案:A

  • 第19题：

    多选题
    Which three statements about subqueries are true? （）
    A

    A main query can have more than one subquery.

    B

    A subquery can have more than one main query.

    C

    The subquery and main query must retrieve data from the same table.

    D

    The subquery and main query can retrieve data from different tables.

    E

    Only one column or expression can be compared between the subquery and main query.

    F

    Multiple columns or expression can be compared between the subquery and main query.


    正确答案： C,D
    解析： 暂无解析

  • 第20题：

    多选题
    Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）
    A

    It can be used to back up all data on ASM disks.

    B

    It can be used to recover the damaged ASM disk group along with the data.

    C

    It can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.

    D

    It can be used to re-create the ASM disk group with its attributes.


    正确答案： D,C
    解析： 暂无解析

  • 第21题：

    单选题
    有如下程序：#include int convert(int *data){ 　return (*data)++; }main(){　int data=56; 　convert(&data); 　printf("%d,",data); 　data = convert(&data); 　printf("%d,",data); 　printf(""); }程序运行后的输出结果是（　　）。
    A

    56,57,

    B

    57,58,

    C

    57,57,

    D

    55,57,


    正确答案： D
    解析：
    本题程序执行过程为：调用convert函数，将变量data地址传入函数，返回当前指针指向的变量值56，之后此变量加一，data=57。输出data=57。再次调用函数，返回当前指针指向的变量值57，然后此地址内存中变量加一，data=58，然后将返回值57赋给变量data=57，最后输出data=57。答案选择C选项。

  • 第22题：

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


    正确答案： A,F
    解析： 暂无解析

  • 第23题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment， the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do？（）
    A

     Update the connection string of the DSProduction shared data source to point to the alternate data source.

    B

     Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.

    C

     Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.

    D

     Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    A data warehouse is a subject-oriented data set used for reporting and analusis. Data warehouses can be subdivided into ( ). Which store subsets of data from a warehouse.
    A

    OLTPs

    B

    transactions

    C

    data sarts

    D

    OLAPs


    正确答案： C
    解析： 数据仓库是一个面向主题的用于报告和分析的数据集。数据仓库可以细分为数据集市，即从一个仓库中存储数据的子集。 A：联机事务处理 B：交易 C://数据集市 D://联机分析处理

相关内容