We can use Group functions in the WHERE clause

We can use MIN and MAX for any

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

Delete from Employee where grade = ‘Y’” deletes

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

In an Oracle Database, Locks are critical

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 nest Group Functions

Limiting the rows in a select statement for a specific condition is done by the clause

Character values are case insensitive