Question is ⇒ A subquery in an SQL SELECT statement:, Options are ⇒ (A) can only be used with two tables., (B) can always be duplicated by a join., (C) has a distinct form that cannot be duplicated by a join., (D) cannot have its results sorted using ORDER BY., (E) , Leave your comments or Download question paper.

Question is ⇒ A subquery in an SQL SELECT statement:, Options are ⇒ (A) can only be used with two tables., (B) can always be duplicated by a join., (C) has a distinct form that cannot be duplicated by a join., (D) cannot have its results sorted using ORDER BY., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	A subquery in an SQL SELECT statement:
A.	can only be used with two tables. [Wrong Answer]
B.	can always be duplicated by a join. [Wrong Answer]
C.	has a distinct form that cannot be duplicated by a join. [Correct Answer]
D.	cannot have its results sorted using ORDER BY. [Wrong Answer]
View Answer 1 -2 Explanation:- Answer : C Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.

⇒ SQL can be used to:
create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

⇒ What is the full form of SQL?
Simple Query Language
Structured Query Language
Structured Query List
None of these

⇒ The Microsoft Access wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
VBScript only
Jscript only
Java only
All of the above are supported

⇒ To run a compiled Java program, the machine must have what loaded and running?
Java virtual machine
Java compiler
Java bytecode
A Web browser

⇒ A JSP is transformed into a(n):
Java applet.
Java servlet.
Either 1 or 2 above.
Neither 1 nor 2 above.

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Complete backup
Transaction Log
Differential backup
None of the above is correct.

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
Type 1
Type 2
Type 3
Type 4

⇒ Which of the following is one of the basic approaches for joining tables?
Subqueries
Union Join
Natural join
All of the above

⇒ Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED

⇒ Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.

⇒ The SQL -92 wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ The wildcard in a WHERE clause is useful when?
An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.

⇒ To sort the results of a query use:
SORT BY.
GROUP BY.
ORDER BY.
None of the above is correct.

⇒ What type of join is needed when you wish to return rows that do have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ For what purposes are views used?
To hide columns only
To hide rows only
To hide complicated SQL statements only
All of the above are uses for SQL views.

⇒ Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

⇒ What servlet processor was developed by Apache Foundation and Sun?
Apache Tomcat
Apache Web server
Sun servlet processor
None of the above is correct.

⇒ What is bytecode?
Machine-specific code
Java code
Machine-independent code
None of the above is correct.

⇒ A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

⇒ When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

⇒ Which of the following is the correct order of keywords for SQL SELECT statements?
SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM,SELECT
SELECT,WHERE,FROM

⇒ With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.

⇒ Which one of the following sorts rows in SQL?
SORT BY
ALIGN BY
ORDER BY
GROUP BY

⇒ A ________ is a stored program that is attached to a table or a view.
pseudofile
embedded SELECT statement
trigger
None of the above is correct.

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints