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 byte is a _____________.

Computer chip

Character of data

Database

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

Hyperlink

Website

Database

5. 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

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

Identifying

Normalization

7. SQL is a(n) ________________.

Query language

Browser

Identifier

8. 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

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

Disk

License

Drive

Byte

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

Browser

Web blocker

Firewall

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

Thick client

Thin client

12. 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

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

Server farm

Websites

Multiple servers

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. Each entity has a unique attribute called ______________.

Crow's feet

Identifier

Model

17. DBMS products are broadly classified into _______________.

Two broad categories: unified and separate

Two broad categories: enterprise and personal

18. Metadata are _____________.

Data that describe data

Database applications

Collections of bits

19. 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

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

Are small

Are easy to work with

Are easy to represent electronically

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 program that controls the computer's resources?

The application system

The operating system

The budgeting system

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. 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

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

Facebook

Microsoft office

Itunes

Amazon

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. A ________ is equivalent to 1,024 bytes.

Megabyte

Kilobyte

Gigabyte

30. Which of the following is nonvolatile in nature?

Main memory and cache

Optical and magnetic discs

31. 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

32. 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

33. 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

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

Process application

Database application

Software application

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

Attributes

Identifiers

Data models

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. Which of the following protocols guarantees a secure transmission?

HTTP

SMTP

HTTPS

FTP

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

Block websites

Encrypt data for transmission

Secure hyperlinks

43. 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

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. Every table in a normalized database has a ______________.

Server

Single theme

Source code

Client

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

Access point

Analog signal

Packet

Firewall

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

Multiple downloading

Mass processing

Memory swapping

50. 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

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

Tracking

Lost-update

Multi-user

Processing

52. Minimum cardinalities are

Minimum requirements on the number of entities

Minimum requirements on the number of attributes

Minimum requirement on the number of identifiers

53. Development costs of an information system include _______________.

Acquiring costs

Data conversion costs

Repairing costs

54. 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

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 byte is a _____________.

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

5. Server farms are used when the _______________.

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

7. SQL is a(n) ________________.

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

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

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

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

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

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

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

15. Virtualization is the process where _______________.

16. Each entity has a unique attribute called ______________.

17. DBMS products are broadly classified into _______________.

18. Metadata are _____________.

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

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

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

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

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. In which of the following cases is a user using the internet, but not the web?

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

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. A ________ is equivalent to 1,024 bytes.

30. Which of the following is nonvolatile in nature?

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

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

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

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

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

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. Which of the following protocols guarantees a secure transmission?

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

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

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. Every table in a normalized database has a ______________.

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

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

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

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

52. Minimum cardinalities are

53. Development costs of an information system include _______________.

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

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) ________________.