In an Oracle Database, Locks are critical
True
False
Which is not a group function?
Count
Avg
Total
Max
We can nest Group Functions
SYSDATE is a date function that returns the current database server date and time.
The value returned by the subquery is used by the main query.
To perform wild card search “Like” is used .
When is a Cartesian product formed?
When a join condition is omitted.
When a join condition is invalid.
All rows in the first table are joined to all rows in the second table.
All of the above.
In a join condition it is mandatory to specify the table name along with the Column name.
The minimum number of join statements required to join 10 tables together are:
9
11
5
12
None of the above
A Non equi-join is a join condition that does not contain an equality operator.