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

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

True

False

+

-

||

*

True

False

Structured Query Language

Standard Query Language

System Query Language

Simple Query Language

Distinct

Projection

Where

All of the above

Date

Sysdate

Current Date

System Date

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

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

DTEXEC

DTSEXEC

SQLEXEC

PSEXEC

distributes a row to single output and another to the other output

distributes its input to one or more outputs

join two inputs

extract data from a connection

Containers

Tasks

Transformations

Precedence Constraints