All columns in the SELECT list, that are not there in the GROUP function, should be in the Group By clause
True
False
Which is the clause used to restrict groups?
HAVING
WHERE
Order By
Group by
We can use Group functions in the WHERE clause
We can use MIN and MAX for any
Numeric data
Data type
Char data
None of the Above
You can update more than 1 row in a table with one update syntax
Delete from Employee where grade = ‘Y’” deletes
All rows of the Employee table
Rows of the Employee table where the set grade is ‘Y’
Delete 1 row
Nothing will be deleted
Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?
CHECK keyword
WITH CHECK keyword
WITH CHECK OPTION keyword
Explicit Defaults can be used in
INSERT statement
UPDATE statement
Both of the Above
MERGE statement
Avoids separate updates
ncreases performance and ease of use
Is useful in data warehousing applications
All of the above
Database transactions end with
COMMIT or ROLLBACK
A DDL or DCL statement executing
USER exiting iSQL*Plus or System crash
Any one of the above