Tag: databases

True

False

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

The AS clause is used with the JOIN clause only.

The AS clause defines a search condition.

The AS clause defines a group

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