Understanding SQL Statements

What does SQL stand for?

• Structured Query List

• Simple Query Language

• Standard Query Language

• Structured Query Language

Which SQL statement is used to retrieve data?

• SELECT

• UPDATE

• INSERT

• DELETE

How do you add a new record in a table?

• Use a 'SELECT * FROM table_name;' statement.

• Use an 'INSERT INTO table_name (column1, column2) VALUES (value1, value2);' statement.

• Use a 'DELETE FROM table_name WHERE condition;' statement.

• Use an 'UPDATE table_name SET column1 = value1;' statement.

What SQL command is used to delete data?

• DELETE

• CLEAR

• REMOVE

• DROP

Which clause is used to filter records?

• FILTER

• SELECT

• GROUP BY

• WHERE

What is the purpose of the 'ORDER BY' clause?

• To filter the results of a query.

• To limit the number of results returned by a query.

• To group the results of a query.

• To sort the result set of a query.

How do you update existing records in a table?

• Use the SQL SELECT statement to retrieve records.

• Use the SQL UPDATE statement with SET and WHERE clauses.

• Delete the records using the SQL DELETE statement.

• Create a new table with the updated records.

What is a primary key in SQL?

• A primary key is a unique identifier for a record in a SQL table.

• A primary key is an optional field in a SQL table.

• A primary key can contain duplicate values.

• A primary key is a foreign key in another table.

What does the 'JOIN' clause do?

• The 'JOIN' clause combines rows from multiple tables based on a related column.

• The 'JOIN' clause filters rows based on a condition.

• The 'JOIN' clause deletes rows from a table.

• The 'JOIN' clause creates a new table from existing tables.

How can you create a new table in SQL?

• INSERT INTO table_name (column1_name, column2_name);

• ALTER TABLE table_name ADD column_name column_datatype;

• DROP TABLE table_name;

• CREATE TABLE table_name (column1_name column1_datatype, column2_name column2_datatype, ...);