Data Manipulation Language (DML): Interactive Learning Quizzes

Question 1

Which clause is primarily used to insert a new row into a database table?

Accepted Answer

INSERT INTO

Answer

UPDATE

Answer

DELETE

Answer

ALTER TABLE

Question 2

What is the primary purpose of the WHERE clause in an UPDATE statement?

Accepted Answer

To specify the rows that should be modified

Answer

To add new rows to the table

Answer

To delete rows from the table

Answer

To alter the table's schema

Question 3

Which data type is typically used to store both dates and times?

Accepted Answer

DATETIME

Answer

INTEGER

Answer

FLOAT

Answer

VARCHAR

Question 4

What is the key difference between a primary key and a foreign key?

Accepted Answer

A primary key uniquely identifies a row, while a foreign key references another table.

Answer

A foreign key uniquely identifies a row, while a primary key references another table.

Answer

Both primary keys and foreign keys uniquely identify rows.

Answer

There is no distinction between a primary key and a foreign key.

Question 5

Which practice is generally considered beneficial for optimizing the efficiency of SQL queries?

Accepted Answer

Using indexes on appropriate columns

Answer

Employing nested queries

Answer

Including wildcard characters in the WHERE clause

Answer

Retrieving an excessive number of rows

Question 6

What is a primary objective of a database transaction?

Accepted Answer

To execute multiple operations as a single unit, ensuring data integrity

Answer

To allow simultaneous access to the database by multiple users

Answer

To create a backup copy of the database

Answer

To modify the structure of the database

Question 7

What is the primary purpose of a database index?

Accepted Answer

To enhance the speed of data retrieval

Answer

To guarantee data accuracy and consistency

Answer

To serve as a backup mechanism for the database

Answer

To alter the schema or structure of the database

Question 8

Which of the following accurately describes a key characteristic of relational databases?

Accepted Answer

Data is organized into a structure of interconnected tables

Answer

Data is arranged in a hierarchical tree-like format

Answer

Data is stored in a single, flat file

Answer

Data is accessed through a complex network of pointers

Question 9

Which SQL statement is specifically used to add a new row to a table?

Accepted Answer

INSERT

Answer

SELECT

Answer

UPDATE

Answer

DELETE

Question 10

Which SQL statement is used to specifically modify the data in an existing row?

Accepted Answer

UPDATE

Answer

SELECT

Answer

INSERT

Answer

DELETE

Question 11

What is the purpose of the ORDER BY clause in a SELECT statement?

Accepted Answer

To specify the order in which the rows should be retrieved

Answer

To specify the columns to be retrieved

Answer

To filter the rows to be included in the result

Answer

To group the rows by a specified column

Question 12

Which SQL statement is used to specifically group the rows in a table by a specified column?

Accepted Answer

GROUP BY

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 13

What is the purpose of the HAVING clause in a GROUP BY statement?

Accepted Answer

To filter the groups to be included in the result

Answer

To specify the columns to be included in the result

Answer

To specify the order in which the groups should be retrieved

Answer

To group the rows by a specified column

Question 14

Which syntax is correct for the DELETE statement in SQL?

Accepted Answer

DELETE FROM WHERE ;

Answer

REMOVE FROM WHEN ;

Answer

DELETE WHERE ;

Answer

ERASE FROM WITH ;

Question 15

Which of the following is NOT a DML statement in SQL?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 16

The __________ clause in SQL can be used to filter rows from a result set based on a specified condition.

Accepted Answer

WHERE

Answer

ORDER BY

Answer

GROUP BY

Answer

HAVING

Question 17

Which of the following methods can be used to insert multiple rows into a table at once in SQL?

Accepted Answer

INSERT INTO ... SELECT

Answer

INSERT INTO ... VALUES

Answer

UPDATE ... SET

Answer

DELETE FROM ... WHERE

Question 18

The __________ statement in SQL can be used to modify the structure of an existing table by adding, modifying, or removing columns.

Accepted Answer

ALTER TABLE

Answer

CREATE TABLE

Answer

DROP TABLE

Answer

RENAME TABLE

Question 19

The __________ operator in SQL is used to combine two tables based on a common column or expression.

Accepted Answer

JOIN

Answer

WHERE

Answer

AND

Answer

OR

Question 20

Which of the following SQL statements lets you retrieve data from a database table?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 21

In a SELECT statement, what clause is used to filter the rows retrieved?

Accepted Answer

WHERE

Answer

ORDER BY

Answer

GROUP BY

Answer

LIMIT

Question 22

What is the main purpose of a PRIMARY KEY constraint in a database table?

Accepted Answer

To ensure each row has a unique identifier

Answer

To prevent duplicate rows from being inserted

Answer

To specify the data type of a column

Answer

To establish a relationship between tables

Question 23

Which SQL statement is used to modify data in an existing row?

Accepted Answer

UPDATE

Answer

INSERT

Answer

SELECT

Answer

DELETE

Question 24

What is the key difference between a WHERE clause and a HAVING clause in an SQL query?

Accepted Answer

WHERE filters rows prior to grouping, while HAVING filters groups post-grouping

Answer

HAVING filters rows prior to grouping, while WHERE filters groups post-grouping

Answer

WHERE filters columns, while HAVING filters rows

Answer

HAVING filters columns, while WHERE filters rows

Question 25

Which SQL operator can be used to join two strings together?

Accepted Answer

+

Answer

-

Answer

*

Answer

/

Question 26

What is the primary purpose of a FOREIGN KEY constraint in a database table?

Accepted Answer

To establish a relationship between tables

Answer

To ensure each row has a unique identifier

Answer

To prevent duplicate rows from being inserted

Answer

To define the data type of a column

Question 27

Which SQL statement is used to delete a row from a table?

Accepted Answer

DELETE

Answer

SELECT

Answer

UPDATE

Answer

INSERT

Question 28

Which DML statement is used to add a new record to a table?

Accepted Answer

INSERT

Answer

SELECT

Answer

UPDATE

Answer

DELETE

Question 29

What is the purpose of the WHERE clause in a SELECT statement?

Accepted Answer

To filter the rows to be returned

Answer

To specify the columns to be returned

Answer

To sort the rows to be returned

Answer

To group the rows to be returned

Question 30

Differentiate between the UPDATE and DELETE statements.

Accepted Answer

UPDATE modifies existing rows while DELETE removes them

Answer

DELETE modifies existing rows while UPDATE removes them

Answer

They perform the same function

Answer

They cannot be used together

Question 31

Which statement is used to create a view in SQL?

Accepted Answer

CREATE VIEW

Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Question 32

What is the term for a collection of related tables that share a common relationship?

Accepted Answer

Entity-Relationship Model

Answer

Schema

Answer

Database

Answer

Query

Question 33

What is the primary purpose of triggers in database systems?

Accepted Answer

Enforce business rules

Answer

Maintain data security

Answer

Optimize database performance

Answer

Manage user access

Question 34

Which Data Manipulation Language (DML) statement is specifically used to retrieve data from a database table?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 35

In a SELECT statement, what is the primary purpose of the WHERE clause?

Accepted Answer

To filter the retrieved data based on a specified condition

Answer

To arrange the retrieved data in ascending order

Answer

To group the retrieved data by a specified column

Answer

To limit the number of retrieved rows

Question 36

Which DML statement is used to add a new row to a database table?

Accepted Answer

INSERT

Answer

SELECT

Answer

UPDATE

Answer

DELETE

Question 37

In an INSERT statement, what is the purpose of the VALUES clause?

Accepted Answer

To provide the data that will be inserted into the new row

Answer

To specify which columns will be updated in the new row

Answer

To define the primary key value for the new row

Answer

To indicate the table where the new row will be inserted

Question 38

Which DML statement is used to modify the data in an existing row of a database table?

Accepted Answer

UPDATE

Answer

SELECT

Answer

INSERT

Answer

DELETE

Question 39

In an UPDATE statement, what is the purpose of the SET clause?

Accepted Answer

To specify the data that will be updated in the existing row

Answer

To indicate which columns will be updated in the existing row

Answer

To define the condition for row selection during update

Answer

To specify the table where the existing row will be updated

Question 40

In a DELETE statement, what is the purpose of the WHERE clause?

Accepted Answer

To filter the data to be deleted based on a specified condition

Answer

To sort the data to be deleted in ascending order

Answer

To group the data to be deleted by a specified column

Answer

To limit the number of rows to be deleted

Question 41

What is the key difference between using TRUNCATE and DELETE to remove data from a table?

Accepted Answer

TRUNCATE removes data without logging changes, while DELETE logs each row deletion.

Accepted Answer

TRUNCATE reclaims table space, while DELETE keeps it allocated.

Answer

DELETE permanently removes data, while TRUNCATE allows for data recovery.

Question 42

Which SQL statement below uses an INNER JOIN to correctly retrieve all customer records and their corresponding orders?

Accepted Answer

SELECT * FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

Answer

SELECT * FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID

Answer

SELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID

Answer

SELECT * FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID

Question 43

Which DML statement is primarily used to retrieve data from a database?

Accepted Answer

SELECT

Answer

DELETE

Answer

CREATE

Answer

UPDATE

Question 44

Which DML statement is used to add a new row of data to a specified table?

Accepted Answer

INSERT

Answer

DELETE

Answer

SELECT

Answer

UPDATE

Question 45

Which DML statement is primarily used to modify existing data in a table?

Accepted Answer

UPDATE

Answer

INSERT

Answer

SELECT

Question 46

Which DML statement is used to remove a specific row of data from a table?

Accepted Answer

DELETE

Answer

INSERT

Answer

SELECT

Answer

UPDATE

Question 47

Which operator is commonly used to compare two values in a DML statement?

Accepted Answer

=

Answer

-

Answer

*

Answer

+

Question 48

Which keyword is used to specify the condition for a DML statement?

Accepted Answer

WHERE

Answer

OR

Answer

AND

Answer

NOT

Question 49

Which function can be used to count the number of rows in a table?

Accepted Answer

COUNT()

Answer

SUM()

Answer

MIN()

Answer

AVG()

Question 50

Which DML statement can be used to define a new table in a database?

Accepted Answer

CREATE TABLE

Answer

SELECT

Answer

INSERT

Question 51

Which DML statement can be used to remove an existing table from a database?

Accepted Answer

DROP TABLE

Answer

UPDATE

Answer

SELECT

Answer

INSERT

Question 52

Which DML statement can be used to modify the structure of an existing table?

Accepted Answer

ALTER TABLE

Answer

SELECT

Answer

INSERT

Answer

UPDATE