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

Create groups of data

Sort data in a specific order

Convert data to a different format

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.vertical partitioning and horizontal replication
B.vertical replication and horizontal partitioning
C.integration and distribution
D.partitioning and replication

答案：D

解析：

应用架构说明了实现一个或多个信息系统所使用的技术，它作为详细设计、构造和实现的一个大纲。给定了包括逻辑数据流图和实体联系图在内的模型和详细资料，我们可以分配数据和过程以创建应用架构的一个概要设计。概要设计通常会受到架构标准、项目目标和所使用技术的可行性的制约。需要绘制的第一个物理数据流图是网络架构数据流图。接下来是分配数据存储到不同的处理器。数据分区和复制是大多数关系型数据库支持的两种分布式数据形式。有许多分配方法用于数据分布。在不同服务器上存储特定表的情况下，我们应该将每个表记为物理数据流图中的一个数据存储，并将其连接到相应的服务器。

第2题：

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

第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.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

正确答案：A,B,C,D,B

第4题：

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

第5题：

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

第6题：

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

答案：B

解析：

第7题：

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

第8题：

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

第9题：

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

第10题：

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

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

题目

相似问题和答案

更多相关问题

相关内容