Which of the following statements is true concerning subqueries?

A Involves the use of an inner and outer query
B Cannot return the same result as a query that is not a subquery
C Does not start with the word SELECT
D All of the mentioned

Correct Answer: Involves the use of an inner and outer query

Subquery—also referred to as an inner query or inner select—is a SELECT statement embedded within a data manipulation language (DML) statement or nested within another subquery.
Bissoy MCQ
#SQL Server #Joins

Related Questions

Which of the following statements concerning business rules is true?
A It should be complex.
B It should not be convertible to computer code.
C It may include restrictions.
D All of the Mentioned
Which of the following statements is true concerning JDBC?
A It is language independent.
B It is similar in concept to ODBC.
C It is useful for all object-oriented languages.
D It consists of three main layers.
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
A Each vendor desiring to be ODBC-complaint provides an ODBC driver.
B Requires certain criteria to be met in order to establish an ODBC connection.
C Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
D All of the above.
Which of the following statements is true concerning routines and triggers?
A Both consist of procedural code.
B Both have to be called to operate.
C Both run automatically.
D Both are stored in the database.
Out of the following statements, concerning an electric field, which statement is not true?
A The electric intensity is a vector quantity
B The electric field intensity at a point is numerically equal to the force exerted upon a charge placed at that point
C An electric field is defined as a point in space at which an electric charge would experience a force
D Unit field intensity in the exertion of a force of one newton on a charge of one coulomb
The following statements are true concerning gastric carcinoma
A It can metastasis to the ovaries
B It is twice as common in females as in males
C It is linked to patients with type 'O' blood group
D It often presents with a major gastrointestinal haemorrhage
E It is sited mainly on the lesser curvature of the stomach
Which of the following is true concerning the following statement: class Manager extends Employee
A Manager is a concrete class and a superclass.
B Manager is a concrete class and a subclass.
C Manager is an abstract class and a superclass.
D Manager is an abstract class and a subclass.
Which of the following is true concerning QBE?
A An official standard has been defined for QBE.
B QBE cannot be used for client/server systems.
C QBE does not give the programmer a visual programming environment.
D Complete applications can be written using QBE.
Which of the following is true concerning a global transaction?
A The required data are at one local site and the distributed DBMS routes requests as necessary.
B The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
C The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
D The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.
Which of the following is true concerning an ODBMS?
A They have the ability to store complex data types on the Web.
B They are overtaking RDBMS for all applications.
C They are most useful for traditional, two-dimensional database table applications.
D All of the above.

Next steps