What is SQL - Practice Questions & Exercises

Challenge - 5 Problems

🧠 Conceptual

intermediate

What does SQL stand for?

Choose the correct full form of SQL.

A Sequential Question Logic

B Simple Query List

C Standard Question Language

D Structured Query Language

💡 Hint

Think about the language used to ask questions to databases.

SQL stands for Structured Query Language. It is used to communicate with databases.

🧠 Conceptual

intermediate

What is the main purpose of SQL?

What is SQL mainly used for in databases?

A To create and manage database structures and data

B To design website layouts

C To write software applications

D To manage operating system files

💡 Hint

SQL helps you work with data stored in databases.

SQL is used to create, read, update, and delete data in databases.

❓ query_result

advanced

What is the output of this SQL query?

Given the table Users with columns id and name, what will this query return?

SELECT name FROM Users WHERE id = 3;

SQL

CREATE TABLE Users (id INT, name VARCHAR(20));
INSERT INTO Users VALUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie');

A Bob

B Charlie

C Alice

D No rows returned

💡 Hint

Look for the row where id equals 3.

The query selects the name where id is 3, which is 'Charlie'.

📝 Syntax

advanced

Which SQL statement is syntactically correct to create a table?

Choose the correct SQL statement to create a table named Products with columns product_id (integer) and product_name (text).

A CREATE TABLE Products (product_id INT, product_name TEXT);

B TABLE CREATE Products (product_id INT, product_name TEXT);

C CREATE Products TABLE (product_id INT, product_name TEXT);

D CREATE TABLE Products product_id INT, product_name TEXT;

💡 Hint

The correct syntax starts with CREATE TABLE followed by the table name and columns in parentheses.

Option A follows the correct SQL syntax for creating a table.

🧠 Conceptual

expert

Which SQL command is used to remove all rows from a table but keep the table structure?

Select the SQL command that deletes all data from a table but does not delete the table itself.

A REMOVE FROM table_name;

B DROP TABLE table_name;

C TRUNCATE TABLE table_name;

D DELETE FROM table_name;

💡 Hint

This command is faster than DELETE and resets identity counters.

TRUNCATE TABLE removes all rows quickly but keeps the table structure intact.