SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

SELECT * FROM Contest IN ContestDate < '05/25/2006'

INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

INSERT Projects VALUES ('Content Development', 'Website content development project')

INSERT Projects ('Content Development', 'Website content development project')

SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

SELECT * FROM Sales

DELETE FROM Sales

SELECT * FROM SALES WHERE OrderID < 1

SELECT FROM Sales

DELETE FROM SalesData

DELETE * FROM SalesData

DELETE SalesData

DELETE ALL SalesData

To return the minimum value of a numeric expression.

To return the absolute, positive value of a numeric expression.

To return the maximum value of a numeric expression.

To return the average value of a numeric expression.

INSERT clause

SELECT clause

DELETE clause

JOIN clause

Selective Join.

You can't join a table to itself.

Self Join

Outer Join

MAX

TOP

MOST

UPPER

WHERE

SEARCH

FROM

WHILE

Determines if a value matches any of the values in a list or a sub-query.

Defines the tables we are selecting or deleting data from.

Is used with the DISTINCT SQL keyword only.

Is used to select data from a view

a special type of table

a special type of store procedure, executed when certain event occurs

a special type of view

an event

LEFT

LEN

AVG

JOIN

DML

MDL

DDL

All the above

True

False

Delete

Truncate

Remove

Drop

Alter table Tbl_Test Insert column New_Column varchar 20

Alter table Tbl_Test Alter column New_Column varchar 20

Alter table Tbl_Test add New_Column varchar 20

Either a or b could be used

True

False

Truncate

Create

Alter

All the above

True

False

On

Where

Having

Non of the Above