Tag: technology

Unconnected identifiers

Identifying qualifiers

Reference identifiers

Reference qualifiers

DELETE statements only

UPDATE, DELETE, INSERT and SELECT statements

UPDATE statements only

INSERT statements only

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

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

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

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

ASC

DESC

No Default value

Returns error

SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')

All the above

Order By

Sort

Arrange

All the above

SELECT ADD(Price) FROM Sales

SELECT TOTAL(Price) FROM Sales

SELECT SUM(Price) FROM Sales

SELECT SUM(Price) WHERE Sales

The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table

The TRUNCATE clause is identical to the DELETE clause

The DELETE clause deletes all rows in a database table, while the TRUNCATE clause can have a WHERE condition and might or might not delete all rows in a table

None of these

True

False

******3400

3400******

3400

Error