databases Online Quiz - 157 Online Test

Back

databases Online Quiz - 157

Description: databases Online Quiz - 157
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

Start the Quiz

Explicit Defaults can be used in

technology databases

INSERT statement
UPDATE statement
Both of the Above
None of the Above

MERGE statement

technology databases

Avoids separate updates
ncreases performance and ease of use
Is useful in data warehousing applications
All of the above

Database transactions end with

technology databases

COMMIT or ROLLBACK
A DDL or DCL statement executing
USER exiting iSQL*Plus or System crash
Any one of the above

In an Oracle Database, Locks are critical

technology databases

True
False

Which is not a group function?

technology databases

Count
Avg
Total
Max

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

technology databases

True
False

COUNT(DISTINCT expr) returns

technology databases

No. of rows in a table
No. of rows with non-null values of the expr
No. of distinct non-null values of the expr
None of the above

Which function forces group functions to include null values?

technology databases

Group By
NVL
Order By
Having

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

technology databases

True
False

Which is the clause used to restrict groups?

technology databases

HAVING
WHERE
Order By
Group by

We can use Group functions in the WHERE clause

technology databases

True
False

We can use MIN and MAX for any

technology databases

Numeric data
Data type
Char data
None of the Above

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

technology databases

True
False

Delete from Employee where grade = ‘Y’” deletes

technology databases

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?

technology databases

CHECK keyword
WITH CHECK keyword
WITH CHECK OPTION keyword
None of the Above

Explicit Defaults can be used in

technology databases

INSERT statement
UPDATE statement
Both of the Above
None of the Above

MERGE statement

technology databases

Avoids separate updates
ncreases performance and ease of use
Is useful in data warehousing applications
All of the above

Database transactions end with

technology databases

COMMIT or ROLLBACK
A DDL or DCL statement executing
USER exiting iSQL*Plus or System crash
Any one of the above

In an Oracle Database, Locks are critical

technology databases

True
False

Which is not a group function?

technology databases

Count
Avg
Total
Max

- Hide questions

databases Online Quiz - 157

AI Explanation

Find more quizzes from top tags