Class 4 Flashcards
The Oracle INSERT ALL statement is used to add multiple rows just in one table at a time.
Answer: False
The Oracle INSERT ALL statement is used to add multiple rows just in one table or multiple tables at a time.
The DISTINCT clause can only be used with SELECT statements.
Answer: True
The DISTINCT clause can only be used with SELECT statements.
The DISTINCT clause doesn’t ignore NULL values.
Answer: False
The DISTINCT clause DOESn’t ignore NULL values.
All aggregate functions group data to ultimately produce a single result value.
Answer: True
All aggregate functions group data to ultimately produce a single result value.
The COUNT(DISTINCT expression) function returns the number of unique and non-null items in a group.
Answer: False
The COUNT(DISTINCT expression) function returns the number of unique and NULL items in a group.
Aggregate functions can not be nested.
Answer: False
Aggregate functions CAN be nested.
The ORDER BY clause can only be used in SELECT statement.
Answer: True
The ORDER BY clause can only be used in SELECT statement.
The nested aggregate functions starts the process from the inner aggregate function.
Answer: True
The nested aggregate functions starts the process from the inner aggregate function.
We can have the DISTINCT clause in UPDATE statements.
Answer: False
We can have the DISTINCT clause in UPDATE* statements.
just in SELECT statements
We cannot use both SQL function and aggregate function in a nested aggregate functions query.
Answer: False
We CANnot use both SQL function and aggregate function in a nested aggregate functions query.
The Oracle BETWEEN condition is used to retrieve values within a range in a where clause in a SELECT statement.
Answer: True
The Oracle BETWEEN condition is used to retrieve values within a range in a where clause in a SELECT statement.
We cannot use ROWNUM to limit the number of rows returned by a query.
Answer: False
We CANnot use ROWNUM to limit the number of rows returned by a query.
