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

True

False

Structured Query Language

Standard Query Language

System Query Language

Simple Query Language

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

True

False

Acquisition

Transaction

Application

Clean Up

Define the target table

Define the Work table

Define the input file

Define the Error table

True

False

True

False

Acquisition

Transaction

Application

Preliminary