sql fundamendals

Remember: What does SQL stand for?

• Structured Query Language
• Style Query Language
• System Query Language
• Simplified Query Language

Remember: Which statement is used to create a table in SQL?

• CREATE
• ALTER
• DELETE
• SELECT

Remember: Which statement is used to delete a table in SQL?

• DROP
• DELETE
• REMOVE
• TRUNCATE

Understand: What is the difference between the DROP and TRUNCATE statements?

• DROP deletes the table and its structure, while TRUNCATE only deletes the table data.
• DROP deletes the table data, while TRUNCATE deletes the table and its structure.
• DROP and TRUNCATE are the same.
• DROP and TRUNCATE are used to delete columns from a table.

Understand: What is the difference between the WHERE and HAVING clauses in SQL?

• WHERE is used to filter rows based on a condition, while HAVING is used to filter groups based on a condition.
• WHERE is used to filter groups based on a condition, while HAVING is used to filter rows based on a condition.
• WHERE and HAVING are the same.
• WHERE and HAVING are used to join tables.

Understand: What is a subquery in SQL?

• A query within another query
• A query with multiple SELECT statements
• A query that only returns a single result
• A query that only returns aggregate data

Apply: Write an SQL statement to create a table named "employees" with columns "id", "name", "age", and "salary".

• CREATE TABLE employees (id INT, name VARCHAR(50), age INT, salary FLOAT);
• CREATE TABLE employees (id CHAR, name VARCHAR(50), age INT, salary FLOAT);
• CREATE TABLE employees (id INT, name INT, age INT, salary FLOAT);
• CREATE TABLE employees (id INT, name VARCHAR(50), age CHAR, salary FLOAT);

Apply: Write an SQL statement to insert a row into the "employees" table with the values 1, "John", 30, and 5000.

• INSERT INTO employees (id, name, age, salary) VALUES (1, "John", 30, 5000);
• INSERT INTO employees (id, name, age, salary) VALUES (1, 8, 30, 5000);
• INSERT INTO employees (id, name, age, salary) VALUES (1, "John", AAA, 5000);
• INSERT INTO employees (id, name, age, salary) VALUES (1, "John", 30, AAA);

Apply: Write an SQL statement to update the salary of employee with id 1 to 6000.

• UPDATE employees SET salary=6000 WHERE id=1;
• UPDATE employees GET salary=6000 WHERE id=1;
• UPDATE employees salary=6000 WHERE id=1;
• UPDATE employees salary=AAA WHERE id=1;

Which SQL command is used to retrieve data from a table?

• SELECT
• INSERT
• DELETE
• UPDATE