Question 1

Which of the following identifies the quality of data in a database?
A) file resolution
B) authenticated access
C) information dimensionality
D) data integrity

Accepted Answer

Data integrity refers to the accuracy, consistency, and completeness of data in a database, making it the most relevant choice for identifying the quality of data in a database. File resolution refers to the number of pixels in an image, authenticated access is a security measure, and information dimensionality refers to the level of detail in a data set.

Question 2

In which kind of conversion does the user stop using the old system and begin using the new system on a certain date?
A) direct conversion
B) parallel conversion
C) phased conversion
D) pilot conversion

Accepted Answer

Direct conversion involves stopping the old system and fully transitioning to the new system on a specific date. It is best suited for smaller organizations or when there is a pressing need to replace the old system quickly.

Question 3

Which of the following is not one of the qualities associated with identifying the value of information?
A) accurate
B) verifiable
C) useful
D) concise

Accepted Answer

The three qualities associated with identifying the value of information are accuracy, verifiability, and usefulness. Conciseness is a desirable trait in communication but is not directly related to the value of information.

Question 4

You store all of your photographs on a Web site that uses a database to store the photos users post. What is this type of database called?
A) a collaborative database
B) a group database
C) a social database
D) a visual database

Accepted Answer

A collaborative database is a type of database that allows multiple users to contribute, access, and modify data in a shared environment. In this scenario, the website is allowing users to contribute photos to the database, making it a collaborative database. B, C, and D are not accurate descriptions of this type of database.

Question 5

HTML uses codes that specify links to other documents and indicate how a webpage is displayed when viewed on the web. What is the term for these codes?
A) links
B) icons
C) keys
D) tags

Accepted Answer

The term for these codes is HTML tags. These tags provide structure and formatting instructions to a web page and help the browser to understand how to display the content.

Question 6

Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?
A) SFA
B) MRP
C) CAM
D) CRM

Accepted Answer

CRM (Customer Relationship Management) manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions. SFA (Sales Force Automation) focuses on sales activities, MRP (Material Requirements Planning) focuses on production planning, and CAM (Computer-Aided Manufacturing) focuses on automating manufacturing processes.

Question 7

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?
A) check digit
B) index
C) insertion ordinal
D) integer

Accepted Answer

A check digit is a number or character that is added to the end of a primary key field to verify its accuracy and prevent data entry errors. It is calculated based on the other digits in the field using a specific algorithm. The other options (B, C, D) are not typically used in primary keys.

Question 8

Microwave transmission involves sending signals from one microwave station to another. What is this often called?
A) line-of-sight transmission
B) flexed-point wireless
C) out-of-sight transmission
D) fixed wireless

Accepted Answer

The answer of Microwave transmission involves sending signals from one...

Question 9

In large companies, users write a formal request for a new or modified information system, which is called which of the following?
A) system demand
B) IS need
C) project request
D) corporate requirement

Accepted Answer

A formal request for a new or modified information system in large companies is generally called a project request. A system demand could refer to a system requirement within an existing project, an IS need is too broad and generic, and corporate requirement does not necessarily refer specifically to an information system.

Question 10

Which of the following is an advantage of an interpreter?
A) When it finds errors, it displays feedback immediately.
B) Interpreted programs run faster than compiled programs.
C) An interpreter produces an object program.
D) all of the above

Accepted Answer

An advantage of an interpreter is that when it finds errors, it displays feedback immediately. This allows for quicker debugging of code compared to compiled programs. However, it is not true that interpreted programs run faster than compiled programs, and an interpreter does not produce an object program.

Question 11

Which of the following roles is responsible for designing and developing an information system?
A) manager
B) coordinator
C) analyst
D) developer

Accepted Answer

The answer of Which of the following roles is responsible...

Question 12

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?
A) backward
B) restorative
C) undo
D) model

Accepted Answer

The described recovery method is known as backward recovery or rollback recovery, where the DBMS uses the log to undo changes made to the database during a specific time period.

Question 13

Which of the following is an advantage of a multidimensional database?
A) There is a common query language.
B) The content of all dimensions is the same regardless of the subject.
C) It can consolidate data much faster than a relational database.
D) All multidimensional databases have a dimension of time.

Accepted Answer

Multidimensional databases are optimized for fast consolidation of data, making it possible to handle large amounts of data more efficiently than relational databases.

Question 14

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?
A) before image
B) front-end
C) after image
D) back-end

Accepted Answer

The answer of Which of the following kinds of programs...

Question 15

Which of the following is a special formatting language that programmers use to format documents for display on the web?
A) Java
B) JavaScript
C) HTML
D) All of the above

Accepted Answer

HTML (Hypertext Markup Language) is the special formatting language that programmers use to format documents for display on the web. Java and JavaScript are programming languages that can be used for web and other types of development, but they are not specifically for formatting documents for the web like HTML.

Question 16

In sequence, traditional system development contains five phases. What are they?
A) planning, analysis, design, implementation, support and security
B) analysis, implementation, support and security, design, planning
C) support and security, design, planning, analysis, implementation
D) implementation, analysis, support and security, planning, design

Accepted Answer

The answer of In sequence, traditional system development contains five...

Question 17

Which of the following is a set of technologies from Microsoft that allows almost any type of program to run on the Internet or an internal business network?
A) .JIT
B) .RPG
C) .NET
D) .VPE

Accepted Answer

.NET is a set of technologies from Microsoft that allows the development and execution of various types of applications and services, including web applications, desktop applications, and mobile applications, on the Internet or an internal business network. The other options, .JIT, .RPG, and .VPE, are not related to Microsoft technologies that enable program execution on the Internet or an internal business network.

Question 18

In a database, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?
A) field
B) member
C) record
D) identifier

Accepted Answer

A field is the smallest unit of data a user accesses in a database. It is a combination of one or more related characters or bytes that represents a single attribute of an entity. Examples of fields include a customer's name, address, phone number, or purchase history.

Question 19

In managing a company's database, which of the following roles requires a technical inside view of data?
A) administrator
B) manager
C) modeler
D) leader

Accepted Answer

The answer of In managing a company's database, which of...

Quiz 13: Appendix: Discovering Computers

Which of the following identifies the quality of data in a database?

In which kind of conversion does the user stop using the old system and begin using the new system on a certain date?

Which of the following is not one of the qualities associated with identifying the value of information?

You store all of your photographs on a Web site that uses a database to store the photos users post. What is this type of database called?

HTML uses codes that specify links to other documents and indicate how a webpage is displayed when viewed on the web. What is the term for these codes?

Which of the following manages information about customers, past purchases, interests, and the day-to-day interactions, such as phone calls, email messages, web communications, and instant messaging sessions?

Which of the following is a number(s) or character(s) that is appended to or inserted into a primary key field?

Microwave transmission involves sending signals from one microwave station to another. What is this often called?

In large companies, users write a formal request for a new or modified information system, which is called which of the following?

Which of the following is an advantage of an interpreter?

Which of the following roles is responsible for designing and developing an information system?

In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?

Which of the following is an advantage of a multidimensional database?

Which of the following kinds of programs interacts with a DBMS, which in turn interacts with the database?

Which of the following is a special formatting language that programmers use to format documents for display on the web?

In sequence, traditional system development contains five phases. What are they?

Which of the following is a set of technologies from Microsoft that allows almost any type of program to run on the Internet or an internal business network?

In a database, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?

In managing a company's database, which of the following roles requires a technical inside view of data?