1. What does SQL stand for? |
| Strong Question Language |
| Structured Query Language |
| Structured Question Language |
|
2. Which SQL statement is used to extract data from a database? |
| OPEN |
| SELECT |
| GET |
EXTRACT
|
3. Which SQL statement is used to update data in a database? |
| SAVE AS |
| SAVE |
| MODIFY |
UPDATE
|
4. Which SQL statement is used to delete data from a database? |
| COLLAPSE |
| REMOVE |
| DELETE |
|
5. Which SQL statement is used to insert new data in a database? |
| ADD RECORD |
| INSERT INTO |
| ADD NEW |
INSERT NEW
|
6. With SQL, how do you select a column named "FirstName" from a table named "Persons"? |
| EXTRACT FirstName FROM Persons |
| SELECT FirstName FROM Persons |
| SELECT Persons.FirstName |
|
7. With SQL, how do you select all the columns from a table named "Persons"? |
| SELECT *.Persons |
| SELECT Persons |
| SELECT * FROM Persons |
SELECT [all] FROM Persons
|
8. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? |
| SELECT * FROM Persons WHERE FirstName LIKE 'Peter' |
| SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' |
| SELECT * FROM Persons WHERE FirstName='Peter' |
SELECT [all] FROM Persons WHERE FirstName='Peter'
|
9. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"? |
| SELECT * FROM Persons WHERE FirstName='%a%' |
| SELECT * FROmPersons WHERE FirstName LIKE '%a' |
| SELECT * FROM Persons WHERE FirstName='a' |
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
|
10. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true |
| False |
| true |
|
|
11. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"? |
| SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' |
| SELECT FirstName='Peter', LastName='Jackson' FROM Persons |
| SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson' |
|
12. 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"? |
| SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons |
| SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen' |
| SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' |
|
13. Which SQL statement is used to return only different values? |
| SELECT UNIQUE |
| SELECT DIFFERENT |
| SELECT DISTINCT |
|
14. With SQL, how can you return the number of records in the "Persons" table? |
| SELECT COUNT() FROM Persons |
| SELECT COLUMNS() FROM Persons |
| SELECT COLUMNS(*) FROM Persons |
SELECT COUNT(*) FROM Persons
|
15. With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table? |
| DELETE ROW FirstName='Peter' FROM Persons |
| DELETE FirstName='Peter' FROM Persons |
| DELETE FROM Persons WHERE FirstName = 'Peter' |
|
16. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table? |
| UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' |
| MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen |
| UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen |
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
|
17. With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table? |
| INSERT ('Olsen') INTO Persons (LastName) |
| INSERT INTO Persons ('Olsen') INTO LastName |
| INSERT INTO Persons (LastName) VALUES ('Olsen') |
|
18. With SQL, how can you insert a new record into the "Persons" table? |
| INSERT ('Jimmy', 'Jackson') INTO Persons |
| INSERT INTO Persons VALUES ('Jimmy', 'Jackson') |
| INSERT VALUES ('Jimmy', 'Jackson') INTO Persons |
|
19. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? |
| SELECT * FROM Persons ORDER BY FirstName DESC |
| SELECT * FROM Persons SORT 'FirstName' DESC |
| SELECT * FROM Persons ORDER FirstName DESC |
SELECT * FROM Persons SORT BY 'FirstName' DESC
|
20. Which SQL keyword is used to sort the result-set? |
| ORDER BY |
| ORDER |
| SORT |
SORT BY
|
