# 1Multiple Choice
Which SQL statement is used to modify an existing column in a table?
UPDATE COLUMN
ALTER TABLE MODIFY COLUMN
CHANGE COLUMN
MODIFY TABLE
BASIC MY SQL
Naomi Olivia
Round match
College
Others
BASIC MY SQL
6
College
Others
BASIC MY SQL
6
15 questions
Allow incorrect answer
Always show answer
public quiz
# 2Multiple Choice
Which SQL clause is used to filter groups based on a specified condition?
WHERE
HAVING
GROUP BY
ORDER BY
# 3Multiple Choice
What is the purpose of a foreign key in SQL?
To uniquely identify each record in a table.
To enforce data integrity by linking tables.
To sort data in ascending order.
To aggregate data from multiple rows.
# 4Multiple Choice
Which SQL statement is used to add a column to an existing table?
ADD COLUMN
INSERT COLUMN
ALTER TABLE ADD COLUMN
CREATE COLUMN
# 5Multiple Choice
What is a primary key in SQL?
A column that can contain NULL values.
A column that uniquely identifies each record in a table.
A column used for sorting data.
A column that links two tables together.
# 6Multiple Choice
Which SQL clause is used to combine rows that have the same data into one row?
JOIN
GROUP BY
ORDER BY
WHERE
# 7Multiple Choice
What does the `*` symbol represent in a SQL SELECT statement?
It selects only the first row.
It selects all columns.
It selects all rows.
It selects a specific column.
# 8Multiple Choice
Which SQL statement is used to delete a table from a database?
DELETE TABLE
REMOVE TABLE
DROP TABLE
ALTER TABLE
# 9Multiple Choice
Which SQL statement is used to create a new table in a database?
NEW TABLE
CREATE TABLE
MAKE TABLE
ADD TABLE
# 10Multiple Choice
Which SQL keyword is used to sort the result-set?
SORT BY
ORDER
ORDER BY
GROUP BY
# 11Multiple Choice
Which SQL keyword is used to specify the condition for selecting data?
FROM
WHERE
SELECT
ORDER BY
# 12Multiple Choice
Which SQL statement is used to delete data from a database?
REMOVE
DELETE
ERASE
DROP
# 13Multiple Choice
Which SQL statement is used to insert new data into a database?
ADD
INSERT
NEW
APPEND
# 14Multiple Choice
Which SQL statement is used to update data in a database?
SAVE
MODIFY
UPDATE
CHANGE
# 15Multiple Choice
Which SQL statement is used to extract data from a database?
GET
SELECT
OPEN
FETCH
Share to Google Classroom