The Ultimate Server Query Language Quiz

COUNT()

NUMBER()

SUM()

specify range for search condition

Specify search condition

Specify what table we are selecting or deleting data from.

INSERT

SELECT

UPDATE

INVERT

The SELECT clause only

The DELETE and UPDATE clauses

The UPDATE clause only

None of the other three

Different Mode Level

Data Model Language

Data Mode Lane

Data Manipulation language

MOST

MAX

TOP

UPPER

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

SAVE 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')

INSERT INTO

WRITE

SELECT

ENTER

DELETE

REMOVE

DROP DATA

CLEAR

SELECT CustomerName, COUNT(CustomerName) FROM Orders

SELECT CustomerName, COUNT(CustomerName) FROM Orders GROUP BY CustomerName

SELECT CustomerName, COUNT(CustomerName) FROM Orders ORDER BY CustomerName

Strong Question Language

Structured Query Language

Structured Question Language

SELECT

GET

OPEN

EXTRACT

SAVE

SAVE AS

MODIFY

UPDATE

SELECT Persons.FirstName

SELECT FirstName FROM Persons

EXTRACT FirstName FROM Persons

SELECT *.Persons

SELECT [all] FROM Persons

SELECT * FROM Persons

SELECT Persons

SELECT * FROM Persons WHERE FirstName'Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='%a%'

False

True

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT * FROM Persons WHERE FirstName'Peter' AND LastName'Jackson'

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

SELECT LastName>'Hansen' AND LastName

SELECT DISTINCT

SELECT DIFFERENT

SELECT UNIQUE

ORDER BY

SORT

ORDER

SORT BY

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER BY FirstName DESC

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO Persons

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE ROW FirstName='Peter' FROM Persons

DELETE FirstName='Peter' FROM Persons

SELECT COUNT() FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

ASC

DESC

There is no default value.

No

Yes

SELECT Username, Password FROM Users

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = 'user1'

Cursor is acronym for Current Set Of Records and is a database object pointing to a currently selected set of records.

A cursor is SQL keyword specifying a retrieved data order.

A blinking vertical line that indicates the location of the next input on the display screen.

Definition of the condition to be met for the rows to be returned.

A list of columns to be selected.

The name of the table we are selecting from.

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints.

The SQL ALTER TABLE clause is used to insert data into database table.

THE SQL ALTER TABLE deletes data from database table.

The SQL ALTER TABLE clause is used to delete a database table.

The WHERE and the HAVING clauses are identical

The HAVING SQL clause condition(s) is applied to all rows in the result set before the WHERE clause is applied (if present). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.

The WHERE SQL clause condition(s) is applied to all rows in the result set before the HAVING clause is applied (if present). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.

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.

Yes.

No.

Is used with the DISTINCT SQL keyword only.

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

Update only one row at a time.

Update more than one row at a time.

Delete more than one row at a time.

Delete only one row at a time..

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 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.

The TRUNCATE clause is identical to the DELETE clause

WHERE clause.

GROUP BY clause.

ORDER BY clause.

JOIN clause.

SELECT ADD(Price) FROM Sales

SELECT SUM(Price) FROM Sales

SELECT TOTAL(Price) FROM Sales

SELECT SUM(Price) WHERE Sales

SELECT AVG(OrderNumber) FROM Sales

SELECT COUNT(*) FROM Sales

SELECT SUM(OrderNumber) FROM Sales