Question Bank: Querying and SQL Functions

What command is used to retrieve data from a database?

Which SQL function can be used to count the number of rows in a query?

To sort query results in descending order, which keyword should be used?

What type of SQL function is CONCAT()?

Which SQL clause is used to group rows that have the same values?

What is the default sorting order of the ORDER BY clause?

If you want to filter records after grouping, which clause should you use?

What is the purpose of the DISTINCT keyword in SQL?

Which SQL command creates a new table?

What is a primary key in a table?

Which function would you use to find the average value of a numeric column?

In SQL, which operator is used for pattern matching?

What does an inner join do in SQL?

Which SQL statement updates existing records in a table?

Which of the following is an example of a numeric function in SQL?

What does the AVG() function in SQL return?

Which single row function would you use to find the length of a string?

Which of the following functions would correctly round a numeric value to the nearest integer in SQL?

What does the MIN() function return in SQL?

In SQL, which function would you use to convert a string to uppercase?

Which function returns the current date in SQL?

What is the primary difference between single row functions and aggregate functions?

Which function would you use to remove leading spaces from a string in SQL?

Which SQL function is used to calculate the number of rows in a result set?

When would you use the DATE() function in SQL?

How would the MOD() function be used in SQL?

Which SQL function gives the name of the month for any date input?

What is a characteristic of Aggregate Functions?

Which SQL function could cause a problem if used on a NULL value when calculating the average?

What does the UNION operation do in SQL?

Which condition must be met to perform a UNION operation?

If two tables A and B have the same column names and data types, which of the following SQL statements correctly performs a UNION?

What is the primary purpose of the INTERSECT operation in SQL?

Which SQL function would you use to determine the number of records in a table that match specific criteria?

In SQL, what does the GROUP BY clause accomplish?

Using the DANCE table provided, how would you find students in Class '7A'?

Which statement is true regarding the difference operation in SQL?

What does using 'ORDER BY' in a SQL query do?

Given tables A and B, which SQL statement correctly executes a UNION while removing duplicates?

What will be the result of using the INTERSECT operation on two tables with no common records?

In the provided DANCE and MUSIC tables, how can you find all unique names present in both tables?

If you want to consolidate a set of results by counting occurrences of different names, which SQL clause would you use?

When performing a SQL operation between two tables, what must be consistent in their columns?

What does the GROUP BY clause do in SQL?

Which SQL function can be used with GROUP BY to find the average value?

Which of the following queries correctly groups data by CustID and counts orders?

What does the HAVING clause do in conjunction with GROUP BY?

If you want to display only those customers who purchased more than one car, which query would you use?

Which function would you use to find the maximum sale price of cars grouped by the payment mode?

What result will this query return: SELECT PaymentMode, COUNT(*) FROM SALE GROUP BY PaymentMode HAVING COUNT(*) > 1?

Why is it necessary to use GROUP BY with aggregate functions?

Which SQL query counts the total cars sold by each employee?

In which scenario would the HAVING clause not be necessary?

What result is expected when executing: SELECT COUNT(*) FROM SALE GROUP BY PaymentMode HAVING COUNT(*) < 2?

Which of the following SQL statements will yield the number of distinct payment modes?

How can you find the minimum sale price of cars grouped by Customer ID?

What does the Cartesian product of two tables return?

In SQL, how do you specify multiple tables in a query?

Which SQL query will display all records from DANCE where the Name is also in MUSIC?

Which of the following statements about table aliases is true?

What is typically the relationship between the columns used in a JOIN operation?

Given two tables, PRODUCTS and ORDERS, which SQL statement will correctly display orders along with product details?

When using a Cartesian product, what can be the potential issue?

Which command retrieves data from multiple tables without needing repetitive conditions?

What is the purpose of the USING clause in a JOIN operation?

Which query effectively filters results from DANCE and MUSIC tables based on both conditions being met?

Identify a major difference between INNER JOIN and OUTER JOIN.

Which of the following SQL commands uses both tables to extract data?