logo

CuriousTab

CuriousTab

Discussion


Home Certification Oracle Certification See What Others Are Saying!
  • Question
  • A subquery in an sql select statement.


  • Correct Answer
  • A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause Subqueries are most frequently used with the SELECT statement The basic syntax is as follows:: SELECT column_name [, column_name ] FROM table1 [, table2 ] WHERE column_name OPERATOR (SELECT column_name [, column_name ] FROM table1 [, table2 ] [WHERE]) A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN, etc There are a few rules that subqueries must follow ? 1 Subqueries must be enclosed within parentheses 2 A subquery can have only one column in the SELECT clause, unless multiple columns are in the main query for the subquery to compare its selected columns 3 An ORDER BY command cannot be used in a subquery, although the main query can use an ORDER BY The GROUP BY command can be used to perform the same function as the ORDER BY in a subquery 4 Subqueries that return more than one row can only be used with multiple value operators such as the IN operator 5 The SELECT list cannot include any references to values that evaluate to a BLOB, ARRAY, CLOB, or NCLOB 6 A subquery cannot be immediately enclosed in a set function 7 The BETWEEN operator cannot be used with a subquery However, the BETWEEN operator can be used within the subquery 

  • Tags: Analyst, Database Administrator, IT Trainer, Project Manager

    More questions

    • 1. Which two descriptions are correct about characteristics of IPv6 unicast addressing? (Choose two) A. Global addresses start with 2000::/3. B. Link-local addresses start with FF00::/10. C. Link-local addresses start with FE00:/12. D. There is only one loopback address and it is ::1.
    • Discuss
    • 2. What are the six OSPF route types?
    • Discuss
    • 3. How many non- overlapping channels are available with 802.11b?

    • Options
    • A. 3
    • B. 12
    • C. 23
    • D. 40
    • Discuss
    • 4. Which IEEE committee has been sanctioned by WAP and is called WPA2?
    • Discuss
    • 5. When a station sends a transmission to the MAC address ff : ff : ff : ff : ff : ff, what type of transmission is it?

    • Options
    • A. Unicast
    • B. Multicast
    • C. Anycast
    • D. Broadcast
    • Discuss
    • 6. In the operation of CSMA/CD, which host(s) have priority after the expiration of the backoff algorithm?

    • Options
    • A. All hosts have equal priority
    • B. The two hosts that caused the collision will have equal priority
    • C. The host that sent the jam signal after the collision
    • D. The host with the highest MAC address
    • Discuss
    • 7. What is the Classs A Private IP address space?
    • Discuss
    • 8. What is the Class C private IP address space?
    • Discuss
    • 9. To use VLSM, what capability must the routing protocols in use possess?

    • Options
    • A. Support for multicast
    • B. Multi-protocol support
    • C. Transmission of subnet mask information
    • D. Support for unequal load balancing
    • Discuss
    • 10. If you wanted administrators to see a message when logging into the router, which command would you use?

    • Options
    • A. message banner motd
    • B. banner message motd
    • C. banner motd
    • D. message motd
    • Discuss


    Comments

    There are no comments.

Enter a new Comment