Test Your SQL Knowledge with This Quiz

Progress

True / False

SQL stands for Structured Query Language.

True False

SQL stands for Structured Query Language, which is used for managing and manipulating relational databases.

True / False

In MySQL, SQL can be used to create databases.

True False

SQL commands in MySQL can create databases using the CREATE DATABASE statement.

True / False

SQL is case-sensitive in MySQL.

True False

SQL keywords in MySQL are not case-sensitive, although it is good practice to write them in uppercase.

True / False

In MySQL, the SELECT statement is used to delete data from a table.

True False

The SELECT statement is used to retrieve data from a table, not to delete it. The DELETE statement is used to remove data.

True / False

MySQL allows the use of SQL to perform transactions.

True False

MySQL supports SQL transactions using commands like START TRANSACTION, COMMIT, and ROLLBACK.

True / False

The JOIN operation in MySQL SQL is used to combine data from multiple tables.

True False

The JOIN operation is used to retrieve related data from multiple tables in a relational database.

True / False

MySQL supports SQL subqueries, which are queries nested inside another query.

True False

MySQL supports subqueries, allowing a query to be nested within another SQL query for complex data retrieval.

True / False

In MySQL, SQL views can be used to simplify complex queries and improve performance.

True False

SQL views in MySQL can simplify complex queries by providing a way to save a query, but they do not necessarily improve performance.

True / False

MySQL supports all ANSI SQL standard features.

True False

While MySQL supports many ANSI SQL standard features, it does not support all of them. There are some proprietary extensions and differences.

Q10

True / False

The GRANT statement in MySQL SQL is used to manage user permissions.

True False

The GRANT statement is used to assign specific privileges to users in MySQL, allowing them to perform various actions on the database.

Q11

Single Choice

What does SQL stand for?

Simple Query Language Structured Query Language Standard Query LanguageSequential Query Language

SQL stands for Structured Query Language, which is used for managing and manipulating relational databases.

Q12

Single Choice

Which SQL statement is used to retrieve data from a MySQL database?

SELECT UPDATE INSERTDELETE

The SELECT statement is used to retrieve data from a MySQL database.

Q13

Single Choice

In MySQL, which SQL statement is used to add new records to a table?

UPDATE INSERT DELETESELECT

The INSERT statement is used to add new records to a table in MySQL.

Q14

Single Choice

Which clause in MySQL SQL is used to filter records?

FROM WHERE SELECTGROUP BY

The WHERE clause is used to filter records based on specific conditions in MySQL SQL.

Q15

Single Choice

In MySQL, which SQL function is used to count the number of rows in a result set?

SUM() AVG() COUNT()MAX()

The COUNT() function is used to count the number of rows in a result set in MySQL.

Q16

Single Choice

Which MySQL SQL statement is used to modify existing records in a table?

INSERT DELETE UPDATESELECT

The UPDATE statement is used to modify existing records in a table in MySQL.

Q17

Single Choice

In MySQL, which SQL keyword is used to combine rows from two or more tables, based on a related column?

UNION JOIN INTERSECTEXCEPT

The JOIN keyword is used to combine rows from two or more tables, based on a related column in MySQL.

Q18

Single Choice

Which MySQL SQL clause is used to group rows that have the same values in specified columns into summary rows?

GROUP BY ORDER HAVINGWHERE

The GROUP BY clause is used to group rows that have the same values in specified columns into summary rows in MySQL.

Q19

Single Choice

In MySQL, which SQL clause is used to specify the search condition for groups?

WHERE HAVING GROUPORDER

The HAVING clause is used to specify the search condition for groups, often used in combination with the GROUP BY clause in MySQL.

Q20

Single Choice

Which MySQL SQL command is used to create a new table in a database?

CREATE DATABASE CREATE TABLE ALTER TABLEINSERT INTO

The CREATE TABLE command is used to create a new table in a MySQL database.

Q21

Multiple Choice

Which of the following SQL statements correctly creates a new table named 'employees' with appropriate columns?

SQL Code

CREATE TABLE employees (
 employee_id INT AUTO_INCREMENT,
 first_name VARCHAR(50),
 last_name VARCHAR(50),
 hire_date DATE,
 PRIMARY KEY (employee_id)
);

CREATE TABLE employees ( id INT AUTO_INCREMENT, first_name VARCHAR(100), last_name VARCHAR(100), hire_date TIMESTAMP, PRIMARY KEY (id) ); CREATE TABLE employees ( employee_id INT AUTO_INCREMENT, first_name VARCHAR(50), last_name VARCHAR(50), hire_date DATE, PRIMARY KEY (employee_id) ); CREATE employees TABLE ( employee_id INT, name_first VARCHAR(50), name_last VARCHAR(50), hire_date DATE, PRIMARY KEY (employee_id) );CREATE TABLE employees ( employee_id INT AUTO_INCREMENT, name_first VARCHAR(100), name_last VARCHAR(100), hire_date TIMESTAMP, PRIMARY KEY (employee_id) );

The correct table creation statement uses the AUTO_INCREMENT property for the primary key and defines the appropriate columns with correct data types.

Q22

Multiple Choice

Identify the correct SQL statement(s) that add a new column 'email' of type VARCHAR(100) to the 'customers' table.

SQL Code

ALTER TABLE customers
ADD COLUMN email VARCHAR(100);

ALTER TABLE customers ADD email VARCHAR(100); ALTER customers ADD COLUMN email VARCHAR(100); ALTER TABLE customers ADD COLUMN email VARCHAR(100);ADD COLUMN email VARCHAR(100) INTO customers;

Adding a new column requires the ALTER TABLE statement followed by ADD COLUMN, specifying the data type for the new column.

Q23

Multiple Choice

Which SQL code correctly deletes rows where the 'status' column is NULL in the 'orders' table?

SQL Code

DELETE FROM orders
WHERE status IS NULL;

DELETE FROM orders WHERE status = NULL; DELETE FROM orders WHERE status IS NULL; DELETE FROM orders WHERE status == NULL;REMOVE FROM orders WHERE status IS NULL;

The DELETE statement should include a WHERE clause to filter rows where the 'status' column is NULL.

Q24

Multiple Choice

Determine the correct SQL query that retrieves all unique values from the 'category' column in the 'products' table.

SQL Code

SELECT DISTINCT category
FROM products;

SELECT UNIQUE category FROM products; SELECT category FROM products WHERE category IS DISTINCT; SELECT DISTINCT category FROM products;SELECT ALL DISTINCT category FROM products;

The DISTINCT keyword is used in a SELECT statement to ensure that only unique values from the specified column are retrieved.

Q25

Multiple Choice

Identify the SQL statement that correctly modifies the 'price' column in the 'items' table to increase its precision.

SQL Code

ALTER TABLE items
MODIFY COLUMN price DECIMAL(10, 2);

ALTER TABLE items MODIFY COLUMN price DECIMAL(10, 2); ALTER TABLE items CHANGE price TO DECIMAL(10, 2); MODIFY items SET price TO DECIMAL(10, 2);ALTER COLUMN price ON items SET TYPE DECIMAL(10, 2);

To modify the column data type, the ALTER TABLE statement is used with MODIFY COLUMN, followed by the new data type definition.

Q26

Multiple Choice

Which of the following queries will correctly join the 'customers' table with the 'orders' table on their respective 'customer_id' columns?

SQL Code

SELECT customers.customer_id,
 customers.name,
 orders.order_id,
 orders.order_date
FROM customers
JOIN orders ON customers.customer_id = orders.customer_id;

SELECT customers.customer_id, customers.name, orders.order_id, orders.order_date FROM customers JOIN orders ON customers.customer_id = orders.customer_id; SELECT customer_id, name, order_id, order_date FROM customers JOIN orders WHERE customers.customer_id = orders.customer_id; SELECT customers.customer_id, name, orders.order_id, orders.order_date FROM customers JOIN orders USING (customer_id);SELECT * FROM customers JOIN orders ON customer_id = orders.customer_id;

A JOIN operation typically requires an ON clause to specify the condition for joining two tables.

Q27

Multiple Choice

Choose the correct SQL statements that create an index on the 'email' column in the 'users' table.

SQL Code

CREATE INDEX idx_email
ON users (email);

CREATE INDEX idx_email ON users (email); CREATE INDEX ON users (email); INDEX ON users (email);CREATE INDEX email_index ON users (email);

Creating an index requires the CREATE INDEX statement followed by the index name and the column to index.

Q28

Multiple Choice

Determine the correct SQL statements that update multiple columns in the 'sales' table.

SQL Code

UPDATE sales
SET total_price = 100,
 discount = 10
WHERE sale_id = 1;

UPDATE sales SET total_price = 100, discount = 10 WHERE sale_id = 1; UPDATE sales SET (total_price = 100, discount = 10) WHERE sale_id = 1; UPDATE sales SET total_price = 100 SET discount = 10 WHERE sale_id = 1;UPDATE sales MODIFY total_price = 100, discount = 10 WHERE sale_id = 1;

To update multiple columns, the SET clause in the UPDATE statement lists the columns with their new values.

Q29

Multiple Choice

Which SQL statements correctly create a composite key on the 'order_id' and 'product_id' columns in the 'order_items' table?

SQL Code

CREATE TABLE order_items (
 order_id INT,
 product_id INT,
 quantity INT,
 PRIMARY KEY (order_id, product_id)
);

CREATE TABLE order_items ( order_id INT, product_id INT, quantity INT, PRIMARY KEY (order_id, product_id) ); CREATE TABLE order_items ( order_id INT, product_id INT, quantity INT, UNIQUE (order_id, product_id) ); ALTER TABLE order_items ADD PRIMARY KEY (order_id, product_id);CREATE TABLE order_items ( order_id INT, product_id INT, quantity INT, PRIMARY KEY (order_id) PRIMARY KEY (product_id) );

A composite key is created by defining multiple columns as the primary key in the table creation statement.

Q30

Multiple Choice

Identify the SQL statement that adds a NOT NULL constraint to the 'phone' column in the 'contacts' table.

SQL Code

ALTER TABLE contacts
MODIFY COLUMN phone VARCHAR(15) NOT NULL;

ALTER TABLE contacts MODIFY COLUMN phone VARCHAR(15) NOT NULL; ALTER TABLE contacts ADD CONSTRAINT phone_not_null CHECK (phone IS NOT NULL); ALTER contacts MODIFY phone NOT NULL;UPDATE contacts SET phone NOT NULL;

The NOT NULL constraint ensures that the column cannot have NULL values and is added using the ALTER TABLE statement with MODIFY COLUMN.

MySQL Database Quiz Questions