With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
A -
SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
B -
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
C -
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
D -
SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'
2-
Which SQL statement is used to return only different values?
A -
SELECT UNIQUE
B -
SELECT DIFFERENT
C -
SELECT DISTINCT
D -
SELECT COLUMNS() FROM Persons
3-
With SQL, how can you return the number of records in the "Persons" table?
A -
SELECT COUNT() FROM Persons
B -
SELECT COLUMNS() FROM Persons
C -
SELECT COLUMNS(*) FROM Persons
D -
SELECT COUNT(*) FROM Persons
4-
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
A -
DELETE ROW FirstName='Peter' FROM Persons
B -
DELETE FirstName='Peter' FROM Persons
C -
DELETE FROM Persons WHERE FirstName = 'Peter'
D -
DELETE ('Olsen') INTO Persons (LastName)
5-
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
A -
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
B -
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
C -
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen
D -
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
6-
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
A -
INSERT ('Olsen') INTO Persons (LastName)
B -
INSERT INTO Persons ('Olsen') INTO LastName
C -
INSERT INTO Persons (LastName) VALUES ('Olsen')
D -
INSERT FirstName='Peter' FROM Persons
7-
With SQL, how can you insert a new record into the "Persons" table?
A -
INSERT ('Jimmy', 'Jackson') INTO Persons
B -
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
C -
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
D -
INSERT INTO Persons ('Olsen') INTO LastName
8-
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
A -
SELECT * FROM Persons ORDER BY FirstName DESC
B -
SELECT * FROM Persons SORT 'FirstName' DESC
C -
SELECT * FROM Persons ORDER FirstName DESC
D -
SELECT * FROM Persons SORT BY 'FirstName' DESC
9-
Which SQL keyword is used to sort the result-set?
A -
ORDER BY
B -
ORDER
C -
SORT
D -
SORT BY
10-
Which of the following methods cannot be used to shrink the size of a transaction log file
manually?