What does SQL stand for?
A
Structured Query Language B
Simple Query Language C
Sequential Query Language D
Standard Question Language
Analysis & Theory
SQL stands for *Structured Query Language*. It is used to manage and manipulate relational databases.
Which SQL statement is used to retrieve data from a database?
A
GET B
SELECT C
EXTRACT D
FETCH
Analysis & Theory
The *SELECT* statement is used to query and retrieve data from tables.
Which clause is used to filter records returned by a query?
A
ORDER BY B
GROUP BY C
WHERE D
HAVING
Analysis & Theory
The *WHERE* clause filters rows before grouping or aggregation.
Which SQL keyword is used to sort the result set?
A
SORT BY B
ORDER BY C
GROUP BY D
ARRANGE BY
Analysis & Theory
*ORDER BY* is used to sort the results in ascending or descending order.
What is the default sorting order when using ORDER BY?
A
Descending B
Random C
Ascending D
None
Analysis & Theory
By default, ORDER BY sorts results in *ascending* order (smallest to largest).
Which SQL statement is used to insert new data into a table?
A
APPEND B
INSERT INTO C
ADD ROW D
NEW RECORD
Analysis & Theory
The *INSERT INTO* statement adds new rows to a table.
Which clause groups rows that have the same values in specified columns?
A
GROUP BY B
ORDER BY C
WHERE D
HAVING
Analysis & Theory
*GROUP BY* groups rows sharing a common value into summary rows (e.g., totals).
Which SQL statement is used to remove records from a table?
A
REMOVE B
DELETE C
DROP D
ERASE
Analysis & Theory
The *DELETE* statement removes rows from a table.
What does the *AS* keyword do in a SQL query?
A
Assigns an alias to a column or table B
Adds a new column C
Specifies a condition D
Sorts the results
Analysis & Theory
*AS* is used to provide an *alias* (temporary name) for a column or table.
Which statement will remove an entire table and its data?
A
DELETE TABLE B
DROP TABLE C
REMOVE TABLE D
ERASE TABLE
Analysis & Theory
*DROP TABLE* deletes both the structure and all the data in the table.