SQL for Data Manipulation: Interactive Learning Quizzes for Web Developers

Question 1

Which of the following is NOT a Data Manipulation Language (DML) statement?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 2

Which SQL statement is used to create a new table and define its structure?

Accepted Answer

CREATE TABLE

Answer

ALTER TABLE

Answer

DROP TABLE

Answer

INSERT INTO

Question 3

Which of the following data types is used to store dates and times in SQL?

Accepted Answer

TIMESTAMP

Answer

VARCHAR

Answer

INTEGER

Answer

BOOLEAN

Question 4

What is the purpose of the WHERE clause in an SQL statement?

Accepted Answer

To filter rows based on a specified condition

Answer

To sort the results in ascending or descending order

Answer

To group the results by a specified column

Answer

To limit the number of rows returned

Question 5

Which of the following is a relational operator that compares two values for equality in SQL?

Accepted Answer

=

Answer

AND

Answer

OR

Answer

<>

Question 6

Which of the following is a common SQL function used to calculate the total of a numeric column?

Accepted Answer

SUM

Answer

COUNT

Answer

MIN

Answer

MAX

Question 7

What is the purpose of a JOIN statement in SQL?

Accepted Answer

To combine rows from two or more tables based on a common column to establish relationships between data.

Answer

To filter rows from a table based on a specified condition

Answer

To sort the results of a query in ascending or descending order

Answer

To group the results of a query by a specified column

Question 8

Which of the following is a disadvantage of using SQL for data management?

Accepted Answer

Complexity in managing large and complex datasets

Answer

Increased data security

Answer

Improved data integrity

Answer

Reduced data redundancy

Question 9

What is a transaction in SQL?

Accepted Answer

A set of database operations that are executed as a single unit of work, ensuring data integrity.

Answer

A single operation that modifies data in a database

Answer

A collection of tables that are related to each other

Answer

A query that retrieves data from a database

Question 10

Which SQL clause is used to filter data based on a specified condition?

Accepted Answer

WHERE

Answer

HAVING

Answer

FILTER

Answer

SELECT

Question 11

Which SQL operator is used to combine two or more conditions using an OR condition?

Accepted Answer

OR

Answer

AND

Answer

NOT

Answer

XOR

Question 12

Which SQL command is used to modify data in a table?

Accepted Answer

UPDATE

Answer

MODIFY

Answer

CHANGE

Answer

ALTER

Question 13

Which SQL keyword is used to specify the columns to be included in the result set of a query?

Accepted Answer

SELECT

Answer

SHOW

Answer

DISPLAY

Answer

GET

Question 14

Which SQL function is used to find the largest value in a set of data?

Accepted Answer

MAX

Answer

MIN

Answer

AVG

Answer

SUM

Question 15

Which SQL clause is used to group data by one or more columns?

Accepted Answer

GROUP BY

Answer

ORDER BY

Answer

HAVING

Answer

DISTINCT

Question 16

Which SQL operator is used to compare two values for equality?

Accepted Answer

=

Answer

>

Answer

<

Answer

<>

Question 17

Which SQL keyword is used to specify the table to be modified in an UPDATE or DELETE statement?

Accepted Answer

FROM

Answer

INTO

Answer

ON

Answer

WHERE

Question 18

Which SQL statement is used to create a new table named 'customers' with columns 'customer_id', 'name', 'email', and 'phone_number'?

Accepted Answer

CREATE TABLE customers (customer_id INT, name VARCHAR(255), email VARCHAR(255), phone_number VARCHAR(255))

Answer

CREATE customers (customer_id INT, name VARCHAR(255), email VARCHAR(255), phone_number VARCHAR(255))

Answer

Table customers (customer_id INT, name VARCHAR(255), email VARCHAR(255), phone_number VARCHAR(255))

Answer

CREATE TABLE customers AS (customer_id INT, name VARCHAR(255), email VARCHAR(255), phone_number VARCHAR(255))

Question 19

Which SQL statement would you use to update the 'email' column for the customer with 'customer_id' equal to 101 to 'new.email@example.com'?

Accepted Answer

UPDATE customers SET email = 'new.email@example.com' WHERE customer_id = 101

Answer

UPDATE customers (email) = 'new.email@example.com' WHERE customer_id = 101

Answer

CHANGE customers SET email = 'new.email@example.com' WHERE customer_id = 101

Answer

ALTER customers SET email = 'new.email@example.com' WHERE customer_id = 101

Question 20

Which SQL statement would you use to delete the customer with 'customer_id' equal to 102 from the 'customers' table?

Accepted Answer

DELETE FROM customers WHERE customer_id = 102

Answer

REMOVE FROM customers WHERE customer_id = 102

Answer

DROP customers WHERE customer_id = 102

Answer

TRASH customers WHERE customer_id = 102

Question 21

Which SQL operator is used to compare two values for equality?

Accepted Answer

=

Answer

==

Answer

!=

Answer

<

Question 22

Which SQL function would you use to find the number of rows in the 'customers' table?

Accepted Answer

COUNT()

Answer

SIZE()

Answer

LENGTH()

Answer

NUMROWS()

Question 23

Which SQL keyword is used to sort the results of a SELECT statement?

Accepted Answer

ORDER BY

Answer

SORT BY

Answer

ASC

Answer

DESC