Final Exam Flashcards

1
Q

____ is the process of assuring that a relational database structure can be implemented as a series of two-dimensional relations or tables.

A

Normalization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the following provides additional functionality to your operating system including anti-virus software?

A

Utility Software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following characterizes a relational database?

A

A logically related two-dimensional table or file of information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

An E-R diagram includes five basic symbols. Which one decided an entity class?

A

Rectangle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which of the following types of utility software can save information if there is a program failure and you are forced to turn off your computer and then back on again?

A

Crash-proof software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which of the following is an example of horizontal market software?

A

Payroll

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

An organization wishes to store information about its employees in a database. The employees, in this case, constitute a(n)____.

A

entity class

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which of the following magnetic storage devices consists of one or more thin metal platters sealed inside the computer?

A

Hard disk

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following is the TLD of the URL, http://www.uts.edu.au?

A

edu

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

____allow you to have multiple Web site open at the same time.

A

Tabs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which symbol would you use in an E-R diagram to show that a stunt can enroll in more than one course?

A

Crow’s foot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Ramona wants information about Golden Eagle Resorts in Utah on the Web. However, she want to exclude results containing golden eagles (birds) found in Utah. She can use a ____.

A

Boolean Operator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

There are ____ primary steps in designing and building a database.

A

four

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

B-Quant, a double-entry bookkeeping software, is created and maintained by a distributed network of engineers, software developers, and users, each making contributions to the source code that is publicly available and free of charge. B-Quant is an example of ____ software.

A

Open-source

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following is true about a DSL modem?

A

It splits the telephone line to facilitate voice communications and internet connectivity parallely.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The ____ focuses on online collaboration, users as both creators and modifiers of content, dynamic and customized information feeds, and many other engaging web-based services.

A

Web 2.0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

There are ____ main types of sever computers on the internet.

A

four

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Which of the following is true about a communications protocol?

A

It is a set of rules that every computer follows to transfer infromation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

If you were looking at an E-R diagram, how would you be able to identify a many-to-many relationship between two entities?

A

There would be a crow’s foot on each end of the relationship between the two entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which of the following defines a database?

A

A collection of information that is organized and accessed according to the logical structure of that information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

BioNext, a genomics research facility, uses scanners that are used to scan some human physical attributes like fingerprints or irises for security purposes. BioNext is using____.

A

Biometric scanners

22
Q

Organizations such as NASA and the National Weather Service that are heavily involved in research and “number crunching” and require computers with high processing speed, are most likely to employ which of the following computers?

A

Supercomputers

23
Q

Which of the following types of software controls your application software and manages how your hardware devices work together?

A

Operating system software

24
Q

What is a primary key?

A

A field or group of fields that uniquely describes each record in a database

25
Q

The test evaluation committee of a secondary school is planning to buy scanners that can detect the presence or absence of a mark in a predetermined spot on the page. Which of the following types of scanners satisfies this requirement?

A

Optical mark reader

26
Q

According to the American Standard Code for information interchange (ASCII), what is a group of eight bits called?

A

Byte

27
Q

Which symbol should you use in an E-R diagram to show the relationship between a student and the courses they are currently enrolled in?

A

Dotted line

28
Q

Anna finds out that the component on her computer’s CPU that performs logic operations is not working. She logs a complaint with the assistance desk in her office requesting the service personnel to fix the ____.

A

Arithmetic logic unit

29
Q

Which of the following is a graphic method of representing entity classes and their relationships?

A

E-R diagram

30
Q

Jane uses a device that allows her to connect her computer to her phone line, enabling her to access another network. Jane is using a ____.

A

telephone modem

31
Q

The Roth University administration plans to use applications of the Web 2.0 technology for its Web site. However, it favors a particular Web 2.0 technology that will allow students to download audio and video files for viewing on their personal computers. Which of the following Web 2.0 technologies satisfies this requirement?

A

Podcasting

32
Q

An intersection relation is:

A

a relation you create to eliminate a many-to-many relationship

33
Q

An E-R diagram includes five basic symbols. Which one denotes and optimal relationship between entity classes?

A

Circle

34
Q

Technically, a Web site address is called a ____.

A

URL

35
Q

The____ is a nonprofit organization charged with numerous internet-related responsibilities, one of which is the oversight of top-level domains.

A

ICANN

36
Q

Which of the following types of software handles tasks specific to technology management and coordinates the interaction of all technology devices?

A

System software

37
Q

Which of the following helps you develop databases and use the information stored in them?

A

Microsoft Access

38
Q

Which of the following is designed to meet the computing needs of several people simultaneously in a small to medium size business environment.

A

Minicomputer

39
Q

What is a network access point?

A

It is a point on the internet where several connections converge

40
Q

A composite primary key is:

A

a key in the intersecting relation that contains the primary keys form the two intersecting relations

41
Q

On investigating a technical fault in his computer, Max finds out that a temporary holding area of information is affected and needs to be changed. Max needs to change the ____of his computer.

A

random access memory

42
Q

Which of the following is true about the internet backbone of a country?

A

It is the major set of connections for computers on the internet

43
Q

If a student’s ID was also present in a relation that stored enrollment information, this field in the enrollment relation would be called a(n)____ key.

A

foreign

44
Q

Which of the following is and example of microblogging?

A

Richard has a wide network of friends on Facebook

45
Q

The advantage of a(n)____ technology is that it produces brighter, more efficient, and thinner displays than traditional LCDs.

A

organic light-emitting diode

46
Q

Whenever any type of information moves over the Internet, it does so acceding to____.

A

TCP/IP

47
Q

Henry uses a high-speed internet connection using a phone line, which allows him to use his phone line simultaneously for voice communication. Which of the following types of modems is Henry using?

A

Digital Subscriber Line

48
Q

A data dictionary contains:

A

the logical structure for the information in a database.

49
Q

Juan is looking for a personal productivity software that can help him create letters, memos, and other basic documents. Which of the following will best fulfill Juan’s requirements?

A

Word processing

50
Q

Which symbol would you use in and E-R diagram to show that a course is taught by only one teacher?

A

Straight, vertical line ( I )