databases Online Quiz - 155
|Description: databases Online Quiz - 155|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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
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