databases Online Quiz - 147
|Description: databases Online Quiz - 147|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which function takes as argument a numeric value or an expression that can be evaluated to a number.
Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.
You may use two consecutive minus signs in arithmetic expressions to indicate the subtraction of a negative value.
You use comments in a SQL statement to pass hints to the Oracle optimizer
In Oracle SQL, all set operators have equal precedence
In Oracle, the select list appears after the SELECT keyword and before the FROM clause.
The UNION ALL operator does not eliminate duplicate selected rows from the result set.
The ALTER SEQUENCE statement can affect only the future sequence numbers