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

1

2

>1

N

1

0

10

None of the above

SELECT * FROM test_chk ;

select * from test_chk where name1 like '%%\%' escape '\'

select * from test_chk where name1 like ' \ ' escape '\';

select * from test_chk where name1 like '%!%%' escape '!'

SELECT * FROM test_chk ;

select * from test_chk where name1 like '%%\%' escape '\'

select * from test_chk where name1 like ' \ ' escape '\';

select * from test_chk where name1 like '%!%%' escape '!'

True

False

True

False

Both values will be equal

Both values will not be equal

You can’t compare these two values

Both will be NULL

NO_DATA_FOUND

ROWTYPE_MISMATCH

TOO_MANY_ROW

DUP_VAL_ON_INDEX

INVALID_CURSOR

CURSOR_ALREADY_OPEN

TIMEOUT_ON_RESOURCE

SYS_INVALID_ROWID

More detail about either Dimension/Measure

More detail about Measure

More detail about Dimension

separate object for Time Dimension

Only Alias

Removing the unnecessary tables.

Aliases or context

Only Context

2D Area chart

pie chart

3D line chart

all off the above