Tag: databases

True

False

None

Record

Record Structure

Record Occurence

Data Item

Record Occurence

Record

Record Type

Areas

Record Occurence

Record Type

Data Item

True

False

A view can be created as read only.

A view can be created as a join on two or more tables. AND Insert and delete operations cannot be performed on views using functions

A view cannot have an ORDER BY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.

Both tables have NULL values.

You want all unmatched data from one table.

You want all matched data from both tables.

You want all unmatched data from both tables.

One of the tables has more data than the other.

TRUNCATE is a DDL command whereas DELETE is a DML command

TRUNCATE is much faster than DELETE

In case of TRUNCATE ,Trigger doesn't get fired.But in DML commands like DELETE .Trigger get fired

All of the above

TRUNCATE is a DDL command whereas DELETE is a DML command

TRUNCATE is much faster than DELETE

In case of TRUNCATE ,Trigger doesn't get fired.But in DML commands like DELETE .Trigger get fired

All of the above

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS_RECD

USER_COL_PRIVS_MADE

USER_COL_PRIVS_RECD