多选题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? （）
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.
参考解析
解析：
暂无解析
相关考题：
Which two statements are true about pool－based source NAT? ()(Choose two.) A. PAT is not supported.B. PAT is enabled by default.C. It supports the address-persistent configuration option.D. It supports the junos-global configuration option.
Which two statements are true about AH?() (Choose two.) A. AH provides data integrity.B. AH is identified by IP protocol 50.C. AH is identified by IP protocol 51.D. AH cannot work in conjunction with ESP
Which two statements are true about precedence values in policy?() (Choose two.) A. 1 is the default precedence.B. A lower number is preferred.C. A higher number is preferred.D. 100 is the default precedence.
Which two statements about VACLs on Cisco Nexus 7000 Series Switches are true？ （）A、 A single VACL can be shared across two or more VDCs.B、 Use of VACLs requires no special license to be installed.C、 VACLs make use of IP or MAC ACLs.D、 Only options drop and forward are permitted.
Which two statements are true about L2TP tunnels?（） (Choose two.)A、Traffic is clear textB、Traffic is encryptedC、They are initiated by the LNSD、They are initiated by the LAC
Which two statements are true about traffic shaping？（）A、Out-of-profile packets are queued.B、It causes TCP retransmits.C、Marking/remarking is not supported.D、It does not respond to BECN and ForeSight Messages.E、It uses a single/two-bucket mechanism for metering.
Which two statements about the Cisco Nexus 1000V VSM are true?（）A、It performs switching decisions and forwarding for the VEMB、It can be run on a virtual machineC、It can be used for remote VEM switching Iine cards
Which two statements about OSPF IPv6 routing are true？（）A、It requires OSPF version 3.B、automatically detects neighbors over NHMA interfacesC、It supports encryption usingD、It uses LSA type 9E、It uses LSA type 8
Which two statements about VPLS are true？ （）A、There is a full mesh of pseudowires.B、There is a partial mesh of pseudowires.C、Only L2TPv3 can be used for pseudowire establishment.D、There is split-horizon to avoid loops.
Which two statements are true about pool-based source NAT? （）(Choose two.)A、PAT is not supported.B、PAT is enabled by default.C、It supports the address-persistent configuration option.D、It supports the junos-global configuration option.
Which two statements are true about precedence values in policy?（） (Choose two.)A、1 is the default precedence.B、A lower number is preferred.C、A higher number is preferred.D、100 is the default precedence.
Which two statements are true about WHERE and HAVING clauses? （）A、A WHERE clause can be used to restrict both rows and groups.B、A WHERE clause can be used to restrict rows only.C、A HAVING clause can be used to restrict both rows and groups.D、A HAVING clause can be used to restrict groups only.E、A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.F、A HAVING clause CANNOT be used in subqueries.
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
Which two statements are true about standard database auditing（）A、DDL statements can be audited.B、Statements that refer to stand-alone procedure can be audited.C、Operations by the users logged on as SYSDBA cannot be audited.D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
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.
Which two statements are true about record groups?（）A、They are stored in the database. B、They are stored in local Forms memory. C、The type is specified explicitly at design time. D、The type is implied by when and how it is created.
Which three statements about subqueries are true? （）A、Asinglerowsubquerycanretrieveonlyonecolumnandonerow.B、Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.C、Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.D、Amultiplerowsubquerycanbecomparedusingthe"；；"；operator.E、AsinglerowsubquerycanusetheINoperator.F、Amultiplerowsubquerycanusethe"；="；operator.
Which two statements about creating constraints are true?（）A、Constraint names must start with SYS_CB、All constraints must be defines at the column levelC、Constraints can be created after the table is createdD、Constraints can be created at the same time the table is createdE、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view
多选题Which two statements are true about L2TP tunnels?（） (Choose two.)ATraffic is clear textBTraffic is encryptedCThey are initiated by the LNSDThey are initiated by the LAC
多选题By default, which two statements are true about export routing polices?（）AExport polices can evaluate only active routesBExport polices can evaluate all routesCExport polices can be applied to the forwarding tableDExport polices can be applied to interfaces
多选题Which two statements are true about AH?（） (Choose two.)AAH provides data integrity.BAH is identified by IP protocol 50.CAH is identified by IP protocol 51.DAH cannot work in conjunction with ESP
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view
多选题Which two statements about SCSI are true？ （）AThe bus is limited to 32 devicesBIt is a full duplex serial standardCIt is a half-duplex serial standardDIt allows up to 320 MB/s of shared channel bandwidth
多选题Which three statements about subqueries are true? （）AAsinglerowsubquerycanretrieveonlyonecolumnandonerow.BAsinglerowsubquerycanretrieveonlyonerowbutmanycolumns.CAmultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.DAmultiplerowsubquerycanbecomparedusingthe；；；operator.EAsinglerowsubquerycanusetheINoperator.FAmultiplerowsubquerycanusethe；=；operator.
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
多选题Which two statements are true about WHERE and HAVING clauses? （）AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING clause can be used to restrict groups only.EA WHERE clause CANNOT be used in a query of the query uses a HAVING clause.FA HAVING clause CANNOT be used in subqueries.
多选题Which two statements are true about traffic shaping？（）AOut-of-profile packets are queued.BIt causes TCP retransmits.CMarking/remarking is not supported.DIt does not respond to BECN and ForeSight Messages.EIt uses a single/two-bucket mechanism for metering.