Multiple Choice Quiz

Multiple Choice Quiz
(See related pages)


1	The company that created SQL is:
		A)	Microsoft
		B)	Oracle
		C)	IBM
		D)	Informix


2	The recognized standard database language is:
		A)	Cobol
		B)	SQL
		C)	C++
		D)	Access


3	Which of the following is not a statement type in SQL?
		A)	Database design
		B)	Database definition
		C)	Database manipulation
		D)	Database control


4	Which of the following is not a SQL database manipulation statement?
		A)	CREATE TABLE
		B)	UPDATE
		C)	DELETE
		D)	INSERT


5	CUSTOMER RENTALS In the table RENTALS, Rtn provides the rental number (the primary key). Cname refers to the Cname in Customer, Pickup is the city where the car was picked up, and Return is the city where the car was returned. RENTCOST In RentCost, Cost shows the base cost of renting a given Make for one day. CITYADJ If the return city of table Rentals is the one listed in table CityAdj, the cost of the rental is multiplied by Factor and by Days shown in table RentLength below. RENTLENGTH RENTLENGTH shows the number of days for the rental number (Rtn) of the table Rentals (this table exists for the sake of testing SQL. Normally, the data here should be part of table Rentals.) The execution of the command SELECT Cname FROM Customer WHERE Resid_City = BirthPlace will produce the following number of rows:
		A)	4
		B)	3
		C)	1 or 2
		D)	0


6	After execution of the command SELECT Cname FROM Customer ORDER BY Resid_City, Cname the value shown first will be:
		A)	BLACK
		B)	GREEN
		C)	MARTIN
		D)	VERNON


7	After execution of the query SELECT Resid_City, AVG(Age) AS Avgage FROM Customer GROUP BY Resid_City The largest value in the column under the heading Avgage will appear in the row showing the following value for Resid_City:
		A)	CARY
		B)	ERIE
		C)	HEMET
		D)	TAMPA


8	The execution of the SQL query SELECT DISTINCT C1.Cname FROM Customer C1, Customer C2 WHERE C1.BirthPlace = C2.Resid_City will produce the following number of rows:
		A)	0
		B)	1 or 2
		C)	3 or 4
		D)	5 or more


9	In a SQL query that gets its data from two tables, and where the keywords WHERE, GROUP, ORDER and HAVING appear, which operation is performed before the other ones?
		A)	Restriction on WHERE conditions
		B)	Restrictions on HAVING conditions
		C)	ORDER BY
		D)	Sort on GROUP BY


10	In a SQL query that gets its data from two tables, and where the keywords WHERE, GROUP, ORDER and HAVING appear, which operation is performed last?
		A)	Restriction on WHERE conditions
		B)	Restrictions on HAVING conditions
		C)	Cross product or join
		D)	Sort on GROUP BY

Log In
Instructors may log in here to access additional teaching material for this site.
Username:
Password:
	Forgot your password?

Site Preferences	(Log out)

		Send mail as:

TA email:
Other email:

"Floating" navigation?
Drawer speed:

Notes		(What is this?)

Add a note
1.	(optional) Enter a note here:
2.	(optional) Select some text on the page (or do this before you open the "Notes" drawer).
3.	Highlighter Color:
4.

Search
Search for:
Search in:

Home > Chapter 4 > Multiple Choice Quiz

	Course-wide Content
		E/R Assistant Glossary Web Links

	Quizzes
		Multiple Choice Quiz True or False Quiz
	More Resources
		Learning Objectives PowerPoint Presentations Databases

	Instructor Resources
		Case Studies Material for a first c... Material for a second ... End of Chapter Solutions Chapter Problem Soluti... Databases Sample Chapters Book Preface PageOut

	Course-wide Content
		E/R Assistant Glossary Web Links

	Instructor Resources
		Database Files

	Quizzes
		Multiple Choice Quiz True or False Quiz
	More Resources
		Learning Objectives PowerPoint Presentations Databases