Title: Quiz 9
Course: RITA MC - WEB PAGE DESIGN I > Section: Unit 4 -- Responsive Sites, Mobile Sites, Apps, and Database

Q: All server behaviors use ColdFusion when addressing databases.
- True
- False
A: False

Q: Using server behaviors to generate dynamic pages is much more efficient than updating content manually each time the information changes.
- True
- False
A: True

Q: It requires more steps and custom scripts to process data for storage in a database from checkboxes than from a list box.
- True
- False
A: False

Q: The server discards a recordset when it is no longer needed.
- True
- False
A: True

Q: When you type nbf_db_connect in the Connection name box in the accompanying figure, it is an internal name that is visible only when you are working in Dreamweaver.
- True
- False
A: True

Q: The Display Record Count server behavior provides information in the ‘Records x to y’ format.
- True
- False
A: False

Q: You determine which fields of information are displayed in the master page and which fields of information are displayed in the detail page when you set the parameters for the pages.
- True
- False
A: True

Q: When you want the same functionality in two different places, a good technique is to copy the code from one location and paste it in the other location.
- True
- False
A: True

Q: Using word processing applications like Microsoft Word to add formatting to text helps prevent hard-to-trace code errors that can arise in unformatted text in code.
- True
- False
A: False

Q: When you use ASP and an Access database, you must input a custom connection string.
- True
- False
A: True

Q: E-commerce sites often use a(n) query to store online orders and billing information.
- True
- False
A: False

Q: Oracle is a database management program that is part of the Microsoft Office suite.
- True
- False
A: False

Q: Server behaviors run on the Web server before the Web page is sent to a user’s browser and are written in PHP, ASP, ASP.NET, JSP, or ColdFusion.
- True
- False
A: True

Q: SQL is a specialized language used for working with databases.
- True
- False
A: True

Q: The item marked 1 in the accompanying figure is used to move the selected field up.
- True
- False
A: False

Q: To open the dialog box in the accompanying figure, in the ____ category of the Insert panel, click the Master Detail Page Set button.
- Master
- Detail
- Data
- Database
A: Data

Q: ____ is a specialized language used for working with databases.
- JavaScript
- SQL
- ColdFusion
- HTML
A: SQL

Q: When you create a set of pages that presents information in two levels of detail, the ____ page displays the detail of the selected record.
- master
- outer
- nested
- detail
A: detail

Q: Which of the following is NOT a button on the page navigation bar?
- First Page
- Current Page
- Last Page
- Previous Page
A: Current Page

Q: You determine which fields of information are displayed in the master page and which fields of information are displayed in the detail page when you set the ____ for the pages.
- properties
- parameters
- styles
- behaviors
A: parameters

Q: A ____ refresh tag tells the browser to automatically refresh a page after a certain amount of time.
- comment
- meta
- body
- link
A: meta

Q: You can protect a page from unauthorized access by adding the ____ server behavior to the page.
- Prevent Access
- Restrict Access
- Limit Access
- Check Access
A: Restrict Access

Q: You can press the ____ keys to open and close the Server Behaviors panel.
- Ctrl+Esc
- Alt+F8
- Ctrl+F9
- Alt+F10
A: Ctrl+F9

Q: Case-Based Critical Thinking Questions
Case 9-1

Your small business has started to experience success. You have had a Web presence for a long time, but you have begun to think you might benefit from converting to a database-driven site. Therefore, you hire a small business consultant to give you some counsel.

In your first call with the consultant, he mistakenly thinks you have a large budget and are planning to deliver very significant amounts of data to multiple users simultaneously. Though this is not the case, it causes him to give you an incorrect assessment of the kind of database software in which you should invest. Which of the following does he recommend to you?
- DB2
- MySQL
- Microsoft Access
- SQL
A: DB2

Q: Case-Based Critical Thinking Questions
Case 9-2

It is time for you to take your new database-driven Web site to the next level.

What happens to a recordset when it is no longer needed?
- It is held in a static position near the database.
- It is discarded.
- It is archived in a backup file.
- Nothing
A: It is discarded.