In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
Correct Answer :
C. ORDER BY
ORDER BY clause is used to sort the records according to the columns. By default, sorting by ORDER BY clause is done in ascending order.
Related Questions
Select the statement which is TRUE?
In case a transaction is rolled back, the data allied with table variable also get rolled back.
In case a transaction is rolled back, the data allied with table variable does not roll back.
In case a transaction is not rolled back, the data allied with table variable get rolled back.
None of the above.
Which of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
Which of the following is/are transaction control commands in SQL?
Commit
Rollback
Both A. and B.
None of the above
Select the correct statement.
TRUNCATE TABLE is faster than DELETE TABLE statement.
TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
Both A) and B)
None of the above
What does the ALTER TABLE Statement do?
By deleting the stored data, this SQL statement deletes the database.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
A new table in SQL is created using this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
A SELECT statement is intersected to use it as a join, but it only returns the records that are ________ between both statements.
Distinct
Common
Shared
Both B and C
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
Which of the following statement is TRUE about SQL Injection?
SQL Injection is an Object Penetration Technique
SQL Injection is a Function Penetration Technique
SQL Injection is a Code Penetration Technique
SQL Injection is a Database Penetration Technique
Which of the following is the feature(s) of SQL Auto Increment?
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
All of the above
Which of the following statement is TRUE?
Web API is the part of HTML5
Web API is not the part of HTML5
Web API is the part of HTML
Web API is the part of XHTML
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
In how many parts are the SQL functions are divided into?
1
2
3
4
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
Which of the following is SQL Server Numeric Data Type?
image
nchar
money
cursor
At which of the following stage does SQL Injection occurs?
When the user is asked to logout
When the user is asked to input password
When the user is asked to input captcha
When the user is asked to input username
GROUP BY clause is placed before which clause in SQL?
HAVING
WHERE
ORDER BY
FROM
ORDER BY clause comes ____ the EXCEPT clause in SQL statement?
Before
After
Flexible to before or after
None of the above
Global Temp Variable is used with which sign?
###
####
#
##
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
Numbers of operand used by Binary Operators are?
1
2
3
4
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
Which statement is true about the SQL?
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above