Practice Exam 2

Question 1

Object-oriented languages can only be used by professional programmers who have devoted years to learning object-oriented design and coding skills.

Answer 1

True

Question 2

As predicted by Moore’s Law, CPU speeds continually increase.

Answer 2

True

Question 3

Volatile memory devices can store data without using external power.

Answer 3

False

Question 4

Although the operating system makes the computer usable, it does little application-specific work

Answer 4

True

Question 5

linux applications are constructed using Objective-C and VB.NET languages.

Answer 5

False

Question 6

In a closed source project, such as Microsoft Office, the source code is highly protected and only available to trusted employees and carefully vetted contractors.

Answer 6

True

Question 7

Creating a system to record and manage the resolution of problems is the development task of a database administrator.

Answer 7

False

Question 8

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

Answer 8

False

Question 9

The lost-update problem can be resolved by implementing single-user database processing.

Answer 9

False

Question 10

A data model describes data and relationships that will be stored in the database.

Answer 10

True

Question 11

1:M, N:M, and 1:1 are common examples of minimum cardinalities, where N and M represent many relationships for two different entities.

Answer 11

False

Question 12

A computer network between Seattle and Philadelphia is made possible through a LAN

Answer 12

False

Question 13

The most basic cloud offering is platform as a service (PaaS) that is the cloud hosting of a bare server computer or data storage.

Answer 13

False

Question 14

Oracle On demand is an example of infrastructure as a service.

Answer 14

False

Question 15

To ensure security, the VPN client software decrypts the original message so that its contents are protected from snooping.

Answer 15

False

Question 16

Unlike ftp, http does not have a secure version.

Answer 16

False

Question 17

Purchasing raw materials is an example of a structured process

Answer 17

True

Question 18

An information silo is a condition that exists when data are isolated in separated information systems.

Answer 18

True

Question 19

The primary purpose of an ERP system is integration.

Answer 19

True

Question 20

A trigger is a computer program stored in a database that is used to enforce business

Answer 20

False

Question 21

Industry-specific solutions contain program and database configuration files but not the process blueprints that apply to ERP implementations in specific industries.

Answer 21

False

Question 22

SAP and Oracle are the highest ranked ERP vendors in the market.

Answer 22

True

Question 23

Bytes lack the capacity to measure sizes of noncharacter data.

Answer 23

False

Question 24

Native applications are also known as thick-client applications.

Answer 24

True

Question 25

The World Wide Web sponsors committees that create and publish protocols and other standards.

Answer 25

False

Question 26

Characteristic of volatile memory?

Answer 26

contents are lost when power is off

Question 27

Ronald runs both Windows 7 and Linux on his desktop computer. This process is called

Answer 27

PC virtualization

Question 28

Bits are used for computer data because they ________.

Answer 28

are easy to represent physically

Question 29

Albert creates a relational database to store employee performance statistics. He stores each employee’s data in independent rows and creates a column named “Employee Number” to assign unique numbers to each employee. This column is referred to as a(n)

Answer 29

primary key

Question 30

What refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

Answer 30

lost-update problem

Question 31

Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, productivity of an employee on daily basis, and employee name. These aspects that Brad wants to track are called ________.

Answer 31

entities

Question 32

A student management system allows students to have multiple majors, and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship.

Answer 32

N:M

Question 33

In cloud computing, resources are said to be “pooled” because organizations ________.

Answer 33

share the same physical hardware through virtualization

Question 34

Compared to in-house hosting, cloud-based hosting ________.

Answer 34

minimizes the risk of investing in technology that will soon become obsolete

Question 35

The ________ protocol standard is also known as Ethernet.

Answer 35

IEEE 802.3

Question 36

digital subscriber line signals

Answer 36

Digital subscriber line signals do not interfere with telephone signals.

Question 37

cable lines

Answer 37

rely on high-capacity optical fiber cables and use their own protocols for data transmission.

Question 38

example of a structured process

Answer 38

customer returns

Question 39

example of a dynamic process

Answer 39

Nike uses Facebook and Twitter to generate buzz about its new line of running shoes.

Question 40

work group information systems

Answer 40

they support 10 to 100 users

Question 41

Enterprise application integration is a ________.

Answer 41

Suite of software applications that consolidates existing systems by providing layers of software that connect applications together

Question 42

A store is a procedure

Answer 42

computer program stored in a database that is used to enforce business rules

Question 43

ERP training falls into two broad categories. One of the categories is training on how to use the ERP application software. What does the training include?

Answer 43

steps for using the applications to accomplish the activities in various processes

Question 44

Joseph wishes to increase the operational efficiency of his new startup. In order to achieve this, what should Joseph do?

Answer 44

Joseph should use integrated data stored in his firm’s central database to analyze its day-to-day activities.

Question 45

A data integrity problem will occur only if ________.

Answer 45

data are duplicated in a database