ODBC and SQL - Quiz Explanation

The answers you selected are indicated below, along with text that explains the correct answers.

1.	What is the ODBC protocol used for? Please select the best answer.
	A.	Creating data on a Web server
	B.	Accessing data from a database
	C.	Sending data from a client site
	D.	Designing a database
	The correct answer is B. The ODBC protocol is used for accessing data from a database. Answer A is incorrect because, while the ODBC driver is configured on a Web server, it is not used to create data on the server. Answer C is incorrect because ODBC is used to access, rather than send, data. Answer D is incorrect because you would use a database language like SQL, rather than an access protocol, to design a database.

2.	Which of the following SQL commands is used for database queries? Please select the best answer.
	A.	CREATE TABLE
	B.	REVOKE ALL
	C.	GRANT ALL
	D.	SELECT
	The correct answer is D. SELECT is the correct SQL command used for database queries. Answer A is incorrect because CREATE TABLE defines the data to be included in a table. Answer B is incorrect because REVOKE ALL denies access to data for specified users. Answer C is incorrect because GRANT ALL grants access to data for specified users.