WorksheetsSQL Multiple Choice Questions
Total questions: 25
Worksheet time: 13mins
What does SQL stand for?
Structured Question Language
Structured Query Language
Simple Query Language
None of the above
Which SQL command is used to retrieve data?
GET
FETCH
SELECT
RETRIEVE
Which SQL clause is used to filter records?
FROM
SELECT
WHERE
ORDER
Which SQL keyword is used to sort the result-set?
ORDER
SORT
ORDER BY
SORT BY
What type of data is stored using INT data type?
Characters
Dates
Text
Whole Numbers
Which data type is used to store decimal numbers?
CHAR
INT
DECIMAL
TEXT
Which SQL statement is used to insert new data?
ADD
APPEND
INSERT INTO
PUSH
Which SQL command is used to delete records from a table?
REMOVE
DELETE
DROP
ERASE
What is the use of the LIKE operator in SQL?
To sort data
To join tables
To match a pattern
To delete data
Which of the following is not a SQL data type?
TEXT
BOOLEAN
DOUBLE
STRING
Which SQL command removes the entire table and its data?
REMOVE
ERASE
DELETE
DROP
What keyword is used to eliminate duplicate rows in SQL?
UNIQUE
DISTINCT
FILTER
REMOVE
What does the WHERE clause do?
Sorts the result
Deletes a table
Filters the rows
Defines a column
Which clause is used to group rows with the same values?
ORDER BY
GROUP BY
SORT
JOIN
Which operator is used to combine multiple conditions in WHERE?
THEN
IF
AND/OR
ELSE
Which SQL function is used to count rows?
TOTAL()
SUM()
COUNT()
NUMBER()
Which of the following is a temporal data type?
VARCHAR
TIME
TEXT
BOOLEAN
Which keyword is used to update existing data?
MODIFY
CHANGE
UPDATE
EDIT
What symbol is used for wildcard matching in SQL?
#
*
%
&
Which command is used to create a new table?
NEW TABLE
MAKE TABLE
CREATE TABLE
BUILD TABLE
Which clause specifies the table to retrieve data from?
SELECT
WHERE
FROM
IN
Which of the following is a constraint in SQL?
TEXT
PRIMARY KEY
DATE
SELECT
Which function is used to find the highest value?
MAX()
HIGH()
TOP()
LARGEST()
What does NULL represent in SQL?
Zero
Empty string
No value
False
Which SQL command is used to give a name to a column or table in the result?
ALIAS
RENAME
AS
NAME
