Intro To it Exam A & B

Question 1

The ______ keyword in SQL is used to inform the DBMS what tables are to be interrogated by the query and, if more than one table contains the data of interest, how they are to be combined or joined.

Answer 1

SELECT

Question 2

The _______ keyword in SQL is used to inform the DBMS what fields or attributes are of interest (and where they are located, i.e. which table/relation they can be found in).

Answer 2

SELECT clause

Question 3

This server addresses protocols such as: IMAP, POP3, SMTP, HTTP, MAPI, and MIME?

Answer 3

eMail Server

Question 4

The system clock speed commonly is measured in which two primary measurements?

Answer 4

Megahertz (MHz)

Gigahertz (GHz)

Question 5

All of the following are parts of a URL except for:

Answer 5

LAN

Question 6

In a client-server network, what is the role of the server?

Answer 6

The role of the server is to send out requests for information.

Question 7

Which of the following describes the knowledge stage in the DIKW model?

Answer 7

A management decision on how many people to hire after observing current employee levels and upcoming marketing promotions.

Question 8

Which of the following would NOT require the use of a network?

Answer 8

Loading a statistical program on your personal computer.

Question 9

Why is it essential to know what information will be needed from the database from the outset of development? Select all that apply.

Answer 9

By knowing the purpose, the developer can determine how many fields are needed in the database.
The developer can determine which data types would help fulfill the purpose.
The purpose determines the structure of the database.

Question 10

Which of the following statements best defines the ALU?

Answer 10

The ALU contains circuitry that performs operations on data such as addition and subtraction.

Question 11

Integrated development environments (IDEs) combine which of the following tools into a single package for systems and application development.

Answer 11

-Compiling
-Editing
-Debugging

Question 12

Which of the four main components of a computer is described by this statement: This component executes all of the arithmetic and logic operations and is responsible for controlling (commanding) all of the components in the computer.

Answer 12

CPU

Question 13

Which of the following statements describes why network protocols are necessary?

Answer 13

Network protocols are necessary for computers to communicate with each other.

Question 14

A typical database application has how many layers?

Answer 14

2

Question 15

Which of the following are phases of the waterfall model?

Answer 15

-Design
-Implementation
-Testing

Question 16

Which answer most accurately describes the timeline of computer development?

Answer 16

First, computers built and programmed by engineers. Next, limited use of computers by large organizations. Next, introduction of personal computers. Lastly, Graphical User Interface systems are introduced.

Question 17

Which of the following statements best represents the relevant characteristic of quality data?

Answer 17

The data used applies to the question being answered.

Question 18

The _____ keyword in SQL is used to inform the DBMS of the specific criteria the data should match to be returned as the output of the query.

Answer 18

WHERE clause

Question 19

_______, sometimes referred to as middleware, facilitate the communication of hardware and software.

Answer 19

Device driver

Question 20

Which statement describes the role of a systems administrator?

Answer 20

Systems administrators are responsible for the installation and maintenance of the resources of an organization’s network

Question 21

Which of the following is the best definition of a computer network?

Answer 21

A computer network is a collection of computers and computer resources (e.g., printers, file servers) connected in such a way that the computers can communicate with each other and their resources.

Question 22

This form of cloud computing is offered as a service by some major organizations, such as Amazon and Google, and used extensively by app developers. Its intent is to be able to quickly and reliably develop and deliver applications

Answer 22

PaaS (Platform as a Service)

Question 23

Which of the following is the correct function of the compiler?

Answer 23

Translates the entire program, creating an executable program, which can be run at a later time.