When is a Cartesian product formed?

A Non equi-join is a join condition that does not contain an equality operator.

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?

Explicit Defaults can be used in

MERGE statement

Database transactions end with

You can update more than 1 row in a table with one update syntax

Which is not a group function?

You can use Avg or Sum group functions for any numeric data

COUNT(DISTINCT expr) returns

Which function forces group functions to include null values?

All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause

Which is the clause used to restrict groups?

We can use Group functions in the WHERE clause

We can use MIN and MAX for any

We can nest Group Functions

Delete from Employee where grade = ‘Y’” deletes

In an Oracle Database, Locks are critical

Character values are case insensitive