Selfjoin

Outerjoin

innerjoin

equijoin

True

False

1112

1111.93

1111.93412

1111.934

It divides both the values and gives the quotient.

It multiplies both the values and gives the product.

It divides both the values and gives the remainder.

There is no such function.

Duplicate

Distinct

Remove

Delete

Single-row subquery, Double-row subquery

Double-row subquery, Multiple-row subquery

Multiple-row subquery

Single-row subquery and Multiple subquery

Only one row

Two rows

Zero rows

There is no such subquery

It gives the name and marks of all the students.

It does not return anything.

It shows an error saying” INVALID SYNTAX ERROR”

It shows an error saying” Single-row subquery returns more than one row

IN

OF

ALL

ANY

IN

OF

ALL

ANY

Add new rows to a table

Modify existing rows of a table

Remove existing rows from a table

All of the above

Insert to table tablename (….);

Insert into table tablename (….);

Insert into table tablename values (…..);

Any one of the above

Date

Sysdate

Current Date

System Date

Distinct

Projection

Where

All of the above

True

False

True

False

+

-

||

*

Projection

Selection

Join

All of the above

Select all columns from EMP;

Select distinct columns from EMP;

Select * from EMP;

All of the above

True

False