SQL: DDL and DML

What is the purpose of the PRIMARY KEY constraint in SQL?

Which DML command is used to modify existing records in a table?

Which SQL data type would you use to store precise monetary values?

How does a FOREIGN KEY constraint function in SQL?

Which of the following defines a variable-length character string in SQL?

What does the NOT NULL constraint enforce on a database column?

Which transaction command ensures that changes made are permanently saved to the database?

What does the WHERE clause do in a SQL query?

Which of the following SQL statements correctly filters employees in the 'HR' department?

What is the purpose of using aliases in a SQL query?

How can you retrieve specific columns from a SQL table instead of all columns?

Which SQL statement demonstrates the correct use of greater than operator?

Which SQL command would you use to group records for aggregation purposes?

What is the result of this SQL statement: SELECT * FROM employees WHERE age > 30;?

Which of the following correctly illustrates the basic syntax of a SELECT statement?

How can you select only specified columns from a table instead of all columns?

Which of the following clauses would you use to arrange results in descending order based on a specific column?

What is a key characteristic of a primary key in a database table?

How does a foreign key contribute to database integrity?

What is the limitation of a unique constraint in SQL?

Which function does a check constraint perform in a database?

What aspect of SQL Data Integrity ensures that all values in a column adhere to defined formats or restrictions?

What is the purpose of the SUM() function in SQL?

Which clause should be used to filter groups after an aggregation has been performed?

Which of the following statements correctly represents the order of execution in a SQL query?

When would you use the COUNT() function in a SQL query?

What is a key difference between the HAVING and WHERE clauses?

What is the main purpose of using the GROUP BY clause in SQL?

Which of the following is an example of conditional aggregation?

In which situation would you use the HAVING clause rather than the WHERE clause?

What is the correct order of execution for a SQL statement involving GROUP BY and HAVING?

Which aggregate function would best be used to find the smallest sales figure in a dataset?

What does the AVG() function do in SQL?

Which clause is used to filter groups after aggregation has been performed?

In the statement SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;, what does the HAVING clause filter for?