Tag: databases

The column is populated by sequence

The column contains many different values

The column is mainly used for value range scans

The columns implementing an inverted list attribute.

Small table rarely retrieved with a full table scan

Large table rarely retrieved with a full table scan

Small table frequently retrieved with a full table scan

Large table frequently retrieved with a full table scan

UTL_FILE_DIR

USER_DUMP_DEST

LOG_ARCHIVE_DEST

BACKGROUND_DUMP_DEST

MANAGER must be a role.

It allows the MANAGER to pass the specified privileges on to other users.

It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

A Schema Object

A subquery that can contain an ORDER BY clause

Another name for a view that contains group functions

A subquery that is part of the FROM clause of another query

A MERGE statement is used to merge the data of one table with data from another.

A MERGE statement replaces the data of one table with that of another.

A MERGE statement can be used to insert new rows into a table.

A MERGE statement can be used to update existing rows in a table.

String

Character

Integer

Date

Numeric

Conversion

Line 1

Line 2

Line 3

Line 4

a. View is a named SQL query stored in data dictionary

b. View is a database object which stores data

c. View is used for data hiding

d. Views doesn’t occupy memory

True

False