SQL Mastery

What is the SQL query to insert data into a table?

• ADD INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)

• INSERT table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)

• INSERT INTO table_name (value1, value2, value3, ...) VALUES (column1, column2, column3, ...)

• INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)

How can you delete records from a table using SQL?

• DROP table_name WHERE condition;

• UPDATE table_name SET column_name = NULL WHERE condition;

• REMOVE * FROM table_name WHERE condition;

• DELETE FROM table_name WHERE condition;

What is the syntax for updating data in a table using SQL?

• CHANGE table_name SET column1 = value1 WHERE condition;

• UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

• UPDATE table_name SET column1 = value1 WHERE condition;

• MODIFY table_name SET column1 = value1 WHERE condition;

What does the SELECT statement do in SQL?

• Deletes data from a database

• Retrieves data from a database

• Updates data in a database

• Creates a new database

How can you perform arithmetic operations in SQL?

• Use operators like ^, $, !, & in SELECT queries to perform arithmetic operations in SQL.

• Perform arithmetic operations in SQL by using keywords such as ADD, SUBTRACT, MULTIPLY, DIVIDE.

• Arithmetic operations in SQL can be done by calling external functions from other programming languages.

• Use operators like +, -, *, /, % in SELECT queries to perform arithmetic operations in SQL.

What are comparison operators in SQL used for?

• Comparison operators in SQL are used to create new tables

• Comparison operators in SQL are used to compare values in a query.

• Comparison operators in SQL are used to perform calculations

• Comparison operators in SQL are used to format data

When inserting data into a table, what happens if a primary key constraint is violated?

• The database will ignore the primary key constraint and insert the record

• The database system will throw an error and prevent the insertion of the new record.

• The database will automatically generate a new primary key value and insert the record

• The database will update the existing record with the new data

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

• To order the rows before deletion

• To specify a condition for which rows to delete

• To specify the columns to delete

• To update the rows instead of deleting them

How can you update multiple columns in a table using a single SQL query?

• UPDATE table_name MODIFY column1 = value1, column2 = value2, ... WHERE condition;

• ALTER table_name SET column1 = value1, column2 = value2, ... WHERE condition;

• INSERT INTO table_name (column1, column2) VALUES (value1, value2) WHERE condition;

• UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

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

• WHERE clause is used for updating data, HAVING clause is used for selecting data

• WHERE clause is used for joining tables, HAVING clause is used for sorting data

• HAVING clause is used for filtering rows before grouping, WHERE clause is used for filtering groups after grouping

• The WHERE clause is used to filter rows before grouping, while the HAVING clause is used to filter groups after grouping.