Question is ⇒ Which one of the following sorts rows in SQL?, Options are ⇒ (A) SORT BY, (B) ALIGN BY, (C) ORDER BY, (D) GROUP BY, (E) , Leave your comments or Download question paper.

Question is ⇒ Which one of the following sorts rows in SQL?, Options are ⇒ (A) SORT BY, (B) ALIGN BY, (C) ORDER BY, (D) GROUP BY, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	Which one of the following sorts rows in SQL?
A.	SORT BY [Wrong Answer]
B.	ALIGN BY [Wrong Answer]
C.	ORDER BY [Correct Answer]
D.	GROUP 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 -92 wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ What SQL structure is used to limit column values of a table?
The LIMIT constraint
The CHECK constraint
The VALUE constraint
None of the above is correct.

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

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

⇒ How many tables may be included with a join?
One
Two
Three
All of the above.

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

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

⇒ The SQL statement that queries or reads data from a table is ________ .
SELECT
READ
QUERY
None of the above is correct.

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

⇒ The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.

⇒ What is not an advantage of stored procedures?
Greater security
SQL can be optimized
Code sharing
Increased network traffic

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

⇒ ON UPDATE CASCADE ensures which of the following?
Normalization
Data Integrity
Materialized Views
All of the above.

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

⇒ Who invented Java?
Netscape
Microsoft
Sun
None of the above is correct.

⇒ What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ How many JDBC driver types does Sun define?
One
Two
Three
Four

⇒ To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
UNIQUE
DISTINCT
SINGLE

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

⇒ Which of the following is true concerning a procedure?
You do not create them with SQL.
They do not need to have a unique name.
They include procedural and SQL statements.
They are the same thing as a function.

⇒ 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

⇒ How many copies of a JSP page can be in memory at a time?
One
Two
Three
Unlimited

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

⇒ Where is metadata stored in MySQL?
In the MySQL database
In the MySQL database
In the MySQL database
None of the above is correct.

⇒ Which of the following is NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE

⇒ 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

⇒ SQL Server program code that is executed after an SQL command has been processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

⇒ Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above.

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

⇒ To define what columns should be displayed in an SQL SELECT statement:
use FROM to name the source table(s) and list the columns to be shown after SELECT.
use USING to name the source table(s) and list the columns to be shown after SELECT.
use SELECT to name the source table(s) and list the columns to be shown after USING.
use USING to name the source table(s) and list the columns to be shown after WHERE.