MIS Test 2

1. The term "open source" means that the source code of the program is ________________.

Available to the public

Only available to a select few

Hard to access

2. Bits are grouped into 8-bit chunks called ___________.

Bytes

Megabytes

Watts

Binary digits

3. A(n) ______________ contains the URL of the Web page to find when the user clicks it.

Hyperlink

Website

Database

4. Server farms are used when the _______________.

Sites have a large number of users and servers are organized into a collection of servers

Computer crashes

Server is private

5. A byte is a _____________.

Computer chip

Character of data

Database

6. Which of the following is true about virtual private networks?

Creates the appearance of a private point-to-point connection

Creates the appearance of a public point-to-point connection

7. SQL is a(n) ________________.

Query language

Browser

Identifier

8. __________ is the process of converting a poorly structured table into two or more well-structured tables.

Identifying

Normalization

9. When you buy an operating system for your personal computer, you are actual buying a software ____________.

Disk

License

Drive

Byte

10. A client-server application that requires nothing more than a browser is called a _____________.

Thick client

Thin client

11. A _________ is a computing device that prevents unauthorized network access.

Browser

Web blocker

Firewall

12. Which of the following terms refers to a collection of servers?

Server farm

Websites

Multiple servers

13. Which of the following is a program used to create, process, and administer a database?

A database management system (DBMS)

A structured query language

An application program

14. ________________ communications are secure, even though they are transmitted over the internet.

Web

Internet

VPN

15. Virtualization is the process where _______________.

One computer hosts the appearance of many computers

There are a lot of graphics

There is a collection of servers

16. Metadata are _____________.

Data that describe data

Database applications

Collections of bits

17. DBMS products are broadly classified into _______________.

Two broad categories: unified and separate

Two broad categories: enterprise and personal

18. Each entity has a unique attribute called ______________.

Crow's feet

Identifier

Model

19. Bits are used for computer data because they ________________.

Are small

Are easy to work with

Are easy to represent electronically

20. Which of the following is a program that controls the computer's resources?

The application system

The operating system

The budgeting system

21. Which of the following is a developmental task of a database administrator?

Create and staff DBA function

Form steering committee

Specify requirements

Validate data model

Evaluate application design

All of the above

22. Which of the following is a function of an ISP?

Provides you with a legitimate internet address

Pays for the internet

Serves as your gateway to the internet

All of the above

23. Which of the following is likely to be used by organizations with limited budgets?

Lotus notes

Linux with Ubantu or OpenOffice clients

24. To run a program or process data, the computer first transfers the program or data from disk to the ____________.

Data channel

Basic components

Main memory

Software

25. Which of the following is an example of a closed source project?

Facebook

Microsoft office

Itunes

Amazon

26. In which of the following cases is a user using the internet, but not the web?

When they are using either HTTP or HTTPS

When they are using SMTP or FTP

27. A(n) is a set of rules that two communicating devices follow

Source code

Protocol

Machine code

Network

28. _______________ are programs that run on a server-tier computer and that manage HTTP traffic by sending and receiving Web pages to and from clients.

Databases

Applications

Web servers

29. Which of the following is nonvolatile in nature?

Main memory and cache

Optical and magnetic discs

30. A ________ is equivalent to 1,024 bytes.

Megabyte

Kilobyte

Gigabyte

31. Which of the following is true of N:M relationships?

An advisor has at most one department

More than one entity is allowed on each side of the relationship

One department can have many advisors

32. The application layer of the TCP/IP protocol architecture ________________.

Enables communication among programs (programs to programs)

Deals with internet routing

Is a reliable internet transport

33. A _____________ is a collection of forms, reports, queries, and programs that process a database

Process application

Database application

Software application

34. Entities have ______ that describe the characteristics of the entity.

Attributes

Identifiers

Data models

35. Which of the following statements is true about UTP cables?

They are types of cables used to connected computers, printers, switches and other devices on a LAN

Most LAN connections are made using UTP cables

The cable consists of wires that are twisted together to improve signal quality

If the connection carries a lot of traffic, the UTP cable may be replaced by optical fiber cables

All of the above

36. A ___________ is a column or group of columns that identifies a unique row in a table.

Grid

Key

Entity

37. A network of computers that appears to operate as an integrated whole is known as a(n) ___________.

Database

Byte

Grid

Processor

38. The various computers and printers on a LAN are connected to a _______________, which is a special purpose computer that receives and transmits wired traffic on the LAN.

Switch

Modem

Protocol

IP address

39. Which of the following is an example of vertical-market software?

Software installed into devices such as printers

Graphic programs

Microsoft excel

Inventory tracking software for an auto manufacturer

40. A(n) __________ uses the internet or other internet to create the appearance of private, point to point connections.

VPN

Modem

HTTP

Data link

41. Packet-filtering firewalls perform all of the following except ______________.

Block websites

Encrypt data for transmission

Secure hyperlinks

42. Which of the following is one of the functions of an application program?

Videochat on a mac

Write a document or query a customer database

Control a computer's resources

43. Which of the following protocols guarantees a secure transmission?

HTTP

SMTP

HTTPS

FTP

44. Ronald runs both Windows 7 and Linux on his desktop computer. The process is called _________________/

PC virtualization

Server virtualization

Site licensing

Desktop virtualization

45. ________________ are commands that the CPU can process that may be specific for each processor type.

Operating systems

Databases

Optical disks

Instruction sets

46. The connection between the VPN client and the VPN server is called a(n) ___________________.

Bridge

Tunnel

Connector

47. Which of the following statements is true of firmware?

It can't be changed or upgraded

It is easy to access

Users do not need to load firmware into the device's memory

It is more complicated than microsoft excel

48. The operating system employs _________ so that users can run multiple applications and files at the same time.

Multiple downloading

Mass processing

Memory swapping

49. Every table in a normalized database has a ______________.

Server

Single theme

Source code

Client

50. A(n) _____________ is a piece of a message that is handled by programs that implement IP.

Access point

Analog signal

Packet

Firewall

51. The ____________ problem is unique in a multi-user database environment.

Tracking

Lost-update

Multi-user

Processing

52. Which of the following is most likely to be the last-choice alternative when deciding to acquire an application software?

Software developed in-house

Software developed by children

Software that is unreliable

53. Development costs of an information system include _______________.

Acquiring costs

Data conversion costs

Repairing costs

54. Minimum cardinalities are

Minimum requirements on the number of entities

Minimum requirements on the number of attributes

Minimum requirement on the number of identifiers

55. The __________________ layer of the TCP/IP protocol architecture is said to provide reliable internet transport.

Transport

Application

Internet

Data link

56. The hardware component that connects a printer's circuitry to the network is called a(n) _________________.

SOHO

NIC

LAN

WAN

57. _____________ is the process of converting a data model into tables, relationships, and data contraits.

Normalization

Database design

Multi-user processing

58. Which of the following is an example of cloud computing?

Tweeting on twitter

Uploading a video on youtube

Accessing a video on Facebook

Retrieving your mail on yahoo

59. The IEEE 802.3 and 802.11 protocols _______________.

Operate at the bottom two layers (data link and physical)

Operate at the top layer (application)

Operate at the middle layers (transport and internet)

60. Which of the following is an example of a database product?

Microsoft office

Ubuntu

Linux

61. In a database system, a _____________ is the smallest piece of data.

Bit

Byte

Chip

Disk

62. Which of the following is true for the TCP/IP protocol architecture?

The 4th layer is transport

The 2nd layer is internet

The 5th layer is physical

The 1st layer is data link

63. A hospital is using a software to analyze treatment regimen and recovery times. The software relates to the dosages, regularity and therapeutic procedures to the time taken by patients segmented across age- and illness-groups. This software is an example of a(n) ________________.

Database management system

Structured query language

Application program

Database administration

MIS Test 2

1. The term "open source" means that the source code of the program is ________________.

2.

What first name or nickname would you like us to use?

2. Bits are grouped into 8-bit chunks called ___________.

3. A(n) ______________ contains the URL of the Web page to find when the user clicks it.

4. Server farms are used when the _______________.

5. A byte is a _____________.

6. Which of the following is true about virtual private networks?

7. SQL is a(n) ________________.

8. __________ is the process of converting a poorly structured table into two or more well-structured tables.

9. When you buy an operating system for your personal computer, you are actual buying a software ____________.

10. A client-server application that requires nothing more than a browser is called a _____________.

11. A _________ is a computing device that prevents unauthorized network access.

12. Which of the following terms refers to a collection of servers?

13. Which of the following is a program used to create, process, and administer a database?

14. ________________ communications are secure, even though they are transmitted over the internet.

15. Virtualization is the process where _______________.

16. Metadata are _____________.

17. DBMS products are broadly classified into _______________.

18. Each entity has a unique attribute called ______________.

19. Bits are used for computer data because they ________________.

20. Which of the following is a program that controls the computer's resources?

21. Which of the following is a developmental task of a database administrator?

22. Which of the following is a function of an ISP?

23. Which of the following is likely to be used by organizations with limited budgets?

24. To run a program or process data, the computer first transfers the program or data from disk to the ____________.

25. Which of the following is an example of a closed source project?

26. In which of the following cases is a user using the internet, but not the web?

27. A(n) is a set of rules that two communicating devices follow

28. _______________ are programs that run on a server-tier computer and that manage HTTP traffic by sending and receiving Web pages to and from clients.

29. Which of the following is nonvolatile in nature?

30. A ________ is equivalent to 1,024 bytes.

31. Which of the following is true of N:M relationships?

32. The application layer of the TCP/IP protocol architecture ________________.

33. A _____________ is a collection of forms, reports, queries, and programs that process a database

34. Entities have ______ that describe the characteristics of the entity.

35. Which of the following statements is true about UTP cables?

36. A ___________ is a column or group of columns that identifies a unique row in a table.

37. A network of computers that appears to operate as an integrated whole is known as a(n) ___________.

38. The various computers and printers on a LAN are connected to a _______________, which is a special purpose computer that receives and transmits wired traffic on the LAN.

39. Which of the following is an example of vertical-market software?

40. A(n) __________ uses the internet or other internet to create the appearance of private, point to point connections.

41. Packet-filtering firewalls perform all of the following except ______________.

42. Which of the following is one of the functions of an application program?

43. Which of the following protocols guarantees a secure transmission?

44. Ronald runs both Windows 7 and Linux on his desktop computer. The process is called _________________/

45. ________________ are commands that the CPU can process that may be specific for each processor type.

46. The connection between the VPN client and the VPN server is called a(n) ___________________.

47. Which of the following statements is true of firmware?

48. The operating system employs _________ so that users can run multiple applications and files at the same time.

49. Every table in a normalized database has a ______________.

50. A(n) _____________ is a piece of a message that is handled by programs that implement IP.

51. The ____________ problem is unique in a multi-user database environment.

52. Which of the following is most likely to be the last-choice alternative when deciding to acquire an application software?

53. Development costs of an information system include _______________.

54. Minimum cardinalities are

55. The __________________ layer of the TCP/IP protocol architecture is said to provide reliable internet transport.

56. The hardware component that connects a printer's circuitry to the network is called a(n) _________________.

57. _____________ is the process of converting a data model into tables, relationships, and data contraits.

58. Which of the following is an example of cloud computing?

59. The IEEE 802.3 and 802.11 protocols _______________.

60. Which of the following is an example of a database product?

61. In a database system, a _____________ is the smallest piece of data.

62. Which of the following is true for the TCP/IP protocol architecture?

63. A hospital is using a software to analyze treatment regimen and recovery times. The software relates to the dosages, regularity and therapeutic procedures to the time taken by patients segmented across age- and illness-groups. This software is an example of a(n) ________________.