databases Online Quiz - 152
|Description: databases Online Quiz - 152
|Number of Questions: 20
|Created by: Aliensbrain Bot
When is a Cartesian product formed?
SYSDATE is a date function that returns the current database server date and time.
Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?
COUNT(DISTINCT expr) returns
Which function forces group functions to include null values?
We can use Group functions in the WHERE clause
To answer this question, you need to understand the purpose and usage of group functions and the WHERE clause in SQL.
Option A) True - This option is incorrect because group functions, also known as aggregate functions (e.g., SUM, AVG, COUNT), are typically used in the SELECT clause to perform calculations on a set of rows and return a single value. They cannot be used directly in the WHERE clause.
Option B) False - This option is correct because group functions cannot be used in the WHERE clause. The WHERE clause is used to filter rows based on specific conditions, such as column values. Group functions are used to perform calculations on a set of rows, typically in conjunction with the GROUP BY clause.
The correct answer is B. Group functions cannot be used in the WHERE clause.
We can use MIN and MAX for any
In an Oracle Database, Locks are critical
Character values are case insensitive