SQL Quiz - 2

1.	What does SQL stand for?

		Strong Question Language
		Structured Question Language
		Structured Query Language
2.	Which SQL statement is used to extract data from a database?

		GET
		OPEN
		EXTRACT
		SELECT
3.	Which SQL statement is used to update data in a database?

		SAVE
		MODIFY
		SAVE AS
		UPDATE
4.	Which SQL statement is used to delete data from a database?

		COLLAPSE
		DELETE
		REMOVE
5.	Which SQL statement is used to insert new data in a database?

		ADD NEW
		INSERT INTO
		INSERT NEW
		ADD RECORD
6.	With SQL, how do you select a column named "FirstName" from a table named "Persons"?

		SELECT Persons.FirstName
		SELECT FirstName FROM Persons
		EXTRACT FirstName FROM Persons
7.	With SQL, how do you select all the columns from a table named "Persons"?

		SELECT * FROM Persons
		SELECT [all] FROM Persons
		SELECT *.Persons
		SELECT 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<>'Peter'
		SELECT * FROM Persons WHERE FirstName='Peter'
		SELECT [all] FROM Persons WHERE FirstName='Peter'
		SELECT [all] FROM Persons WHERE FirstName LIKE '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 LIKE 'a%'
		SELECT * FROM Persons WHERE FirstName LIKE '%a'
		SELECT * FROM Persons WHERE FirstName='a'
		SELECT * FROM Persons WHERE FirstName='%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 FirstName='Peter', LastName='Jackson' FROM Persons
	SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
	SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='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 * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
	SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
	SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
13.		Which SQL statement is used to return only different values?

	SELECT DIFFERENT
	SELECT UNIQUE
	SELECT DISTINCT
14.		Which SQL keyword is used to sort the result-set?

		SORT
		ORDER BY
		ORDER
		SORT BY
15.	With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

	SELECT * FROM Persons ORDER FirstName DESC
	SELECT * FROM Persons SORT 'FirstName' DESC
	SELECT * FROM Persons SORT BY 'FirstName' DESC
	SELECT * FROM Persons ORDER BY FirstName DESC

16.	With SQL, how can you insert a new record into the "Persons" table?

		INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
		INSERT ('Jimmy', 'Jackson') INTO Persons
		INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
17.	With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

	INSERT INTO Persons ('Olsen') INTO LastName
	INSERT ('Olsen') INTO Persons (LastName)
	INSERT INTO Persons (LastName) VALUES ('Olsen')
18.		How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

	UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
	MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
	UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
	MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
19.		With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

		DELETE FirstName='Peter' FROM Persons
		DELETE ROW FirstName='Peter' FROM Persons
		DELETE FROM Persons WHERE FirstName = 'Peter'
20.	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