Which two are true about aggregate functions? ()A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameters to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.

Which two are true about aggregate functions? ()

  • A、You can use aggregate functions in any clause of a SELECT statement.
  • B、You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
  • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
  • D、You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
  • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
  • F、You cannot group the rows of a table by more than one column while using aggregate functions.

相关考题:

Which of the following about the African bush elephant and the African elephant is true?A.The WCU are interbreeding those elephants.B.They are interbreeding species.C.They are two genetically distant species.D.They depend on each other for survival.

Which of the following is NOT true about the centrifugal separator? A.It can be applied to separate two liquidsB.It cannot separate solids which contaminated in the oil.C.It consists of purifier and clarifierD.The centrifuge arranged to separate two liquids is known as purifier

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 statement about two lines spliced together is TRUE ________.A.Splicing is used to increase the circumference of each lineB.Splicing two lines together is stronger than knotting two lines togetherC.Splicing is used to increase the overall strength of the lineD.Splicing is used to prevent rotting of the lines bitter end

Which statement about Belgium is NOT true?A.it is twice as big as Beijing.B.it has two major ethnic groups.C.it has gone through quite a few threats of division.D.it has no government.

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 static NAT translations are true?()A、They are always present in the NAT table.B、They allow connection to be initiated from the outside.C、They can be configured with access lists, to allow two or more connections to be initiated from the outside.D、They require no inside or outside interface markings because addresses are statically defined.

Which statement about WSA user authentication is true?() A、 a single WSA can have multiple LDAP realmsB、 WSA supports LDAP but not NTLMC、 WSA supports NTLM but not LDAPD、 a single WSA can have up to two authentication realms: one for LDAP and for NTLM

Which statement is true about the digital to analog conversion process?()A、the two steps of digital to analog conversion are decompression and reconstruction of the analog signalB、the two steps of digital to analog conversion are decoding and filteringC、the two steps of digital to analog conversion are decompression and filtering of the analog signalD、the two steps of digital to analog conversion are quantization and decoding

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 using the isUserInRole method to implement security in a Java EEapplication?()A、It can be invoked only from the doGet or doPost methods.B、It can be used independently of the getRemoteUser method.C、Can return "true" even when its argument is NOT defined as a valid role name in the deployment descriptor.D、Using the isUserInRole method overrides any declarative authentication related to the method in which it is invoked.

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

单选题Which statement is true about the digital to analog conversion process?()Athe two steps of digital to analog conversion are decompression and reconstruction of the analog signalBthe two steps of digital to analog conversion are decoding and filteringCthe two steps of digital to analog conversion are decompression and filtering of the analog signalDthe two steps of digital to analog conversion are quantization and decoding

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