Basic SQL Queries
What SQL keyword is used to retrieve data from a database?
What is SELECT?
Which SQL function is used to find the average value of a column?
What is AVG()?
What type of SQL join returns only the rows that have matching values in both tables?
What is INNER JOIN?
Which SQL statement is used to insert new records into a table?
What is INSERT INTO?
What SQL command is used to create a new database?
What is CREATE DATABASE?
Which SQL clause is used to filter records based on a condition?
What is WHERE?
Which SQL function returns the highest value in a column?
What is MAX()?
Which SQL join returns all rows from the left table, and the matched rows from the right table?
What is LEFT JOIN?
How do you update a specific column in a table for a given record?
What is UPDATE?
What is a primary key in a database?
What is a column or a set of columns that uniquely identifies each record in a table?
Which SQL operator is used to sort the result set in ascending order?
What is ORDER BY ASC?
Which SQL function counts the number of rows in a table?
What is COUNT()?
Which SQL join returns all rows from the right table, and the matched rows from the left table?
What is RIGHT JOIN?
What SQL statement is used to remove data from a table?
What is DELETE?
Which SQL constraint ensures that a column must have a value (no NULL values)?
What is NOT NULL?
How do you limit the number of rows returned in an SQL query?
What is LIMIT?
Which SQL function calculates the sum of a column's values?
What is SUM()?
Which SQL join returns all rows when there is a match in one of the tables?
What is FULL OUTER JOIN?
Which SQL keyword is used to add new columns to an existing table?
What is ALTER TABLE?
What SQL clause is used to group rows that have the same values into summary rows?
What is GROUP BY?
What is the correct SQL syntax to select all columns from a table named "Customers"?
What is SELECT * FROM Customers;?
Which SQL function returns the lowest value in a column?
What is MIN()?
How would you write a query that combines data from two tables, "Orders" and "Customers," using an INNER JOIN on the column "customer_id"?
What is SELECT * FROM Orders INNER JOIN Customers ON Orders.customer_id = Customers.customer_id;?
Which SQL statement removes a table from a database permanently?
What is DROP TABLE?
Which SQL function would you use to combine two or more result sets into one?
What is UNION?