Question 1

A ____ data type usually provides a variable-length field into which users can enter comments.
A) text
B) character
C) memo
D) string

Accepted Answer

The memo data type is the best choice for a field that can hold variable-length comments. The text data type is also a good choice, but it is limited in size to 255 characters, whereas the memo data type can hold up to 65,536 characters. The character and string data types are not suitable for holding large amounts of text.

Question 2

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.
A) memo
B) real
C) text
D) logical

Accepted Answer

The text data type is appropriate for a field that needs to store textual data, such as a person's name. It allows for a variable length string to be entered, depending on the length of the name. The memo data type is used for larger amounts of text, such as a description, and the real and logical data types are used for numbers and true/false values, respectively, and are not appropriate for storing names.

Question 3

A database ____ contains a list of keys,and each key provides a pointer to the record that contains the rest of the fields related to that key.
A) schema
B) catalog
C) index
D) roster

Accepted Answer

An index contains a list of keys and pointers to the corresponding records in a database. It is used for faster retrieval of data based on the key values. A schema defines the structure of a database, a catalog contains metadata about the database objects, and a roster is a list of names or people.

Question 4

A ____ validates an entry by searching for the same data in a file or database table.
A) validating routine
B) redundancy routine
C) lookup routine
D) normalizing routine

Accepted Answer

A lookup routine searches for a specific value in a file or database table to verify its validity. It is commonly used in data validation processes.

Question 5

To provide a quality database interface,a designer might ____.
A) arrange fields in a logical order
B) minimize on-screen instructions to save space
C) position entry areas randomly
D) use only one type of control on the interface

Accepted Answer

Arranging fields in a logical order helps users easily navigate the database and find the information they need. Minimizing on-screen instructions can make the interface confusing, and positioning entry areas randomly can make it difficult for users to locate the information they need. Using only one type of control on the interface can limit functionality and make the interface less user-friendly.

Question 6

-The two tables shown in the accompanying figure are ____ by the CustomerNumber field.
A) merged
B) related
C) split
D) concatenated

Accepted Answer

The CustomerNumber field is common to both tables, indicating that the tables are related.

Question 7

____ is a markup language that allows field tags,data,and tables to be incorporated into a Web document.
A) HTML
B) XML
C) Java
D) ASP

Accepted Answer

XML (Extensible Markup Language) allows for tags to be created and customized, making it easy to incorporate field tags, data, and tables into a web document. HTML is a markup language used for creating the structure and content of web pages, but it is not as customizable as XML. Java and ASP are programming languages used for building web applications and dynamic websites, but they are not markup languages.

Question 8

The goal of normalization is to minimize data ____.
A) redundancy
B) cardinality
C) indexing
D) formatting

Accepted Answer

Normalization is the process of organizing data in a database to avoid redundancy and dependency. Redundancy refers to unnecessarily duplicated data in a database that can lead to inconsistencies and errors in data retrieval and management. Therefore, the goal of normalization is to minimize data redundancy. Cardinality, indexing, and formatting are not directly related to the normalization process.

Question 9

The ____ Web publishing process generates customized Web pages as needed.
A) server-side
B) flexible
C) static
D) dynamic

Accepted Answer

The dynamic web publishing process involves creating web pages on-the-fly and customizing them based on user input, database queries, or other factors. This approach provides greater flexibility and interactivity compared to static web pages, which are pre-coded and unchanging. Server-side programming often plays a role in the dynamic web publishing process, allowing for sophisticated back-end functionality and database management.

Question 10

A field ____ is a template that adds the correct formatting as data is entered.
A) format
B) roster
C) validation
D) screen

Accepted Answer

A field format is a template that adds the correct formatting as data is entered. It ensures that data is entered uniformly and in a consistent format.

Question 11

The ____ data type would be the right choice for a field designed to hold an MP3 file.
A) music
B) computed field
C) logical
D) BLOB

Accepted Answer

BLOB stands for Binary Large Object, which is a data type used for storing large binary files such as images, audio, video, and other multimedia files. MP3 files are binary files, so the BLOB data type would be the appropriate choice for storing them.

Question 12

The ____ data type is used to store true/false or yes/no data using minimal storage space.
A) yes
B) logical
C) memo
D) true

Accepted Answer

The logical data type is used to store true/false or yes/no data in minimal storage space.

Question 13

Dynamic Web publishing relies on a program or script,referred to as a(n)____ program,that acts as an intermediary between your browser and a DBMS.
A) server-side
B) client-side
C) XForm
D) input

Accepted Answer

Server-side programs are responsible for interacting with the database and generating dynamic content through the web server. Client-side programs run in the user's browser and do not directly interact with the database. XForms and input are not specifically related to dynamic web publishing.

Question 14

A table's ____ order is the order in which records are stored on disk.
A) storage
B) sort
C) normal
D) linked

Accepted Answer

The sort order is the order in which records are stored on disk.

Question 15

-The accompanying figure shows a(n)____ document.
A) HTML
B) XML
C) JavaScript
D) Perl

Accepted Answer

The figure likely shows a structured document with tags, which is characteristic of XML (Extensible Markup Language).

Question 16

A CGI script can be written in all of the following EXCEPT ____.
A) C++
B) Java
C) JavaScript
D) Perl

Accepted Answer

CGI scripts are typically written in server-side languages like C++, Java, and Perl. JavaScript is primarily a client-side scripting language and is not commonly used for writing CGI scripts.

Question 17

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.
A) cardinality
B) validation
C) structure
D) filter

Accepted Answer

Validation rules are used to specify and control the format and values that can be entered into a particular field. These rules help maintain data integrity and accuracy in a database by preventing invalid or incorrect data from being entered.

Question 18

A(n)____ can be used to delineate the data entry area in a user interface.
A) box
B) line
C) shaded area
D) all of the above

Accepted Answer

All of the above options (box, line, shaded area) can be used to delineate the data entry area in a user interface. A box or a shaded area can provide a visual boundary around the input fields, while a line can be used to separate different sections or categories within the data entry area. Using a combination of these elements can help make the data entry process more intuitive and user-friendly.

Question 19

Which of the following is NOT true of XML?
A) It exists as a document in human-readable format.
B) It is portable so that it can be easily accessed from virtually any platform.
C) XML documents are optimized for many operations you customarily associate with databases such as fast sorts and updates.
D) All that is required to view an XML document is an XML-enabled browser.

Accepted Answer

XML documents are not optimized for many operations you customarily associate with databases such as fast sorts and updates. They are primarily used for structuring and organizing data in a standardized way.

Question 20

All of the following are tools to help you create server-side programs EXCEPT ____.
A) ASP
B) JavaScript
C) CGI
D) PHP

Accepted Answer

JavaScript is primarily used as a client-side programming language and is not designed to create server-side programs. The other options, ASP, CGI, and PHP, are all server-side languages and frameworks used to create dynamic websites and web applications.

Quiz 11: Databases

A ____ data type usually provides a variable-length field into which users can enter comments.

The ____ data type would be appropriate for a fixed-length field designed to hold a person's name.

A database ____ contains a list of keys,and each key provides a pointer to the record that contains the rest of the fields related to that key.

A ____ validates an entry by searching for the same data in a file or database table.

To provide a quality database interface,a designer might ____.

-The two tables shown in the accompanying figure are ____ by the CustomerNumber field.

____ is a markup language that allows field tags,data,and tables to be incorporated into a Web document.

The goal of normalization is to minimize data ____.

The ____ Web publishing process generates customized Web pages as needed.

A field ____ is a template that adds the correct formatting as data is entered.

The ____ data type would be the right choice for a field designed to hold an MP3 file.

The ____ data type is used to store true/false or yes/no data using minimal storage space.

Dynamic Web publishing relies on a program or script,referred to as a(n) ____ program,that acts as an intermediary between your browser and a DBMS.

A table's ____ order is the order in which records are stored on disk.

-The accompanying figure shows a(n) ____ document.

A CGI script can be written in all of the following EXCEPT ____.

A field ____ rule is a specification that the database designer sets up to filter the data entered into a particular field.

A(n) ____ can be used to delineate the data entry area in a user interface.

Which of the following is NOT true of XML?

All of the following are tools to help you create server-side programs EXCEPT ____.