aa

Skip to main content

TEAP 1311-Fall 2011-Computer Literacy-Section1

You are logged in as Alexandr Cosarnii (Logout)

Page path

Home / 〉 My courses

/ 〉 TEAP 1311-1

/ 〉  31 October - 6 November

/ 〉 Quiz-Week 11

/ 〉 Review of attempt 1

Started on           Wednesday, 2 November 2011, 01:52 PM

Completed on   Wednesday, 2 November 2011, 02:22 PM

Time taken         30 secs

Marks   54.00/60.00

Grade   90.00 out of a maximum of 100.00

Question 1

Correct

Mark 1.00 out of 1.00

Question text

_____ databases store not only data but also instructions to manipulate the data.

Select one:

a. Multidimensional

b. Network

c. Hierarchical

d. Object-oriented

Object-oriented databases store the data and the instructions to manipulate the data.

Feedback

The correct answer is: Object-oriented.

Question 2

Correct

Mark 1.00 out of 1.00

Question text

A record represents a collection of attributes that describe an .

Feedback

A record is a collection of related fields. A record represents a collection of attributes that describe an entity.

The correct answer is: entity.

Question 3

Correct

Mark 1.00 out of 1.00

Question text

A nationwide airline reservation system is an example of this type of database model.

Select one:

a. Multidimensional model

b. Relational model

c. Object-oriented model

d. Hierarchical model

A nationwide airline reservations system is an example of a hierarchical database model.

Feedback

The correct answer is: Hierarchical model.

Question 4

Correct

Mark 1.00 out of 1.00

Question text

Individual databases are the foundation of management information systems.

Select one:

True

False

Feedback

correct

The correct answer is 'False'.

Question 5

Correct

Mark 1.00 out of 1.00

Question text

A common operational database is a type of

Select one:

a. individual database

b. shared database

Company (shared) databases are of two types: common operational database and common user database.

c. commercial database

d. distributed database

Feedback

The correct answer is: shared database.

Question 6

Correct

Mark 1.00 out of 1.00

Question text

The logical view of data focuses on meanings and content of the data.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 7

Correct

Mark 1.00 out of 1.00

Question text

The analysis tools associated with the  subsystem include query-by-example and structure query languages (SQL).

Feedback

The data manipulation subsystem provides tools for maintaining and analyzing data. Specific tools include query-by-example and specialized programming languages called structured query languages (SQL).

The correct answer is: data manipulation.

Question 8

Correct

Mark 1.00 out of 1.00

Question text

A _____ in different tables can be used to integrate the data in a database.

Select one:

a. key field

In a database, each record is uniquely identified by its key field. Key fields in different files can be used to integrate the data in a database.

b. character

c. table

d. record

Feedback

The correct answer is: key field.

Question 9

Correct

Mark 1.00 out of 1.00

Question text

The data manipulation subsystem can use query-by-example as well as

Select one:

a. VBA

b. SQL

Data manipulation subsystem provides tools like query-by-example and structured query languages (SQL) for data maintenance and data analysis.

c. XML

d. HTML

Feedback

The correct answer is: SQL.

Question 10

Correct

Mark 1.00 out of 1.00

Question text

 databases are the foundation for management information systems.

Feedback

Company databases are the foundation for management information systems.

The correct answer is: Company.

Question 11

Correct

Mark 1.00 out of 1.00

Question text

In a network database, a node may be reached through more than one path with the help of .

Feedback

A network database is sometimes described as a many-to-many relationship. There are additional connections–called pointers–between parent nodes and child nodes. Thus, a node may be reached through more than one path.

The correct answer is: pointers.

Question 12

Correct

Mark 1.00 out of 1.00

Question text

In the object-oriented database model, this term is the equivalent to a field in a relational model.

Select one:

a. Entities

b. Attributes

Attributes are the description of entities. They are similar to fields.

c. Classes

d. Methods

Feedback

The correct answer is: Attributes.

Question 13

Correct

Mark 1.00 out of 1.00

Question text

Data redundancy results due to lack of data integrity.

Select one:

True

False

Feedback

correct

The correct answer is 'False'.

Question 14

Correct

Mark 1.00 out of 1.00

Question text

In  access storage, the computer continues scanning for records until the desired record is located.

Feedback

In sequential access storage, the user must wait for the computer to scan several records one at a time. It continues scanning until the desired record is located.

The correct answer is: sequential.

Question 15

Incorrect

Mark 0.00 out of 1.00

Question text

A hierarchical database uses many-to-many relationships.

Select one:

True

False

Feedback

incorrect

The correct answer is 'False'.

Question 16

Correct

Mark 1.00 out of 1.00

Question text

Which of the following is an advantage of using multidimensional databases?

Select one:

a. Smaller hard disk usage

b. Simpler relationships

c. Network ability

d. Intuitive conceptualization

Multidimensional databases and hyper cubes provide users with an intuitive model in which complex data and relationships can be conceptualized.

Feedback

The correct answer is: Intuitive conceptualization.

Question 17

Correct

Mark 1.00 out of 1.00

Question text

The logical arrangement of data in a database is called the database model.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 18

Correct

Mark 1.00 out of 1.00

Question text

In the  database, complex relationships between data can be represented and efficiently analyzed.

Feedback

Each side of the cube in a multidimensional database is considered a dimension of the data. In this way, complex relationships between data can be represented and efficiently analyzed.

The correct answer is: multidimensional.

Question 19

Correct

Mark 1.00 out of 1.00

Question text

In a network database, a node can be traced down through different branches.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 20

Correct

Mark 1.00 out of 1.00

Question text

If all the data in a database is not physically located in one place, it would be a(n)

Select one:

a. commercial database

b. individual database

c. Web database

d. distributed database

Many times the data in a company is stored not in just one location but in several locations. The database, then, is a distributed database. That is, not all the data in a database is physically located in one places.

Feedback

The correct answer is: distributed database.

Question 21

Correct

Mark 1.00 out of 1.00

Question text

A  is a collection of related records.

Feedback

A table is a collection of related records.

The correct answer is: table.

Question 22

Correct

Mark 1.00 out of 1.00

Question text

The combined information presented on a _____ can be used to change the whole merchandising strategy of a store.

Select one:

a. company database

Company databases are the foundation for management information systems. This information could be used to change the whole merchandising strategy of the store.

b. individual database

c. distributed database

d. commercial database

Feedback

The correct answer is: company database.

Question 23

Correct

Mark 1.00 out of 1.00

Question text

A credit card bill that is processed at one shot - say the end of the month - is an example of

Select one:

a. consignment processing

b. real-time processing

c. batch processing

In batch processing, data is collected over several hours, days, or even weeks. It is then processed all at once as a "batch."

d. group processing

Feedback

The correct answer is: batch processing.

Question 24

Correct

Mark 1.00 out of 1.00

Question text

This type of database is organized into many tables with common data items (key fields) linking the tables to one another.

Select one:

a. Multidimensional

b. Relational

In the relational database model, there are no access paths down a hierarchy. Rather, the data elements are stored in different tables, each of which consists of rows and columns.

c. Hierarchical

d. Network

Feedback

The correct answer is: Relational.

Question 25

Correct

Mark 1.00 out of 1.00

Question text

The duties of a database administrator include the determining of which people have access to what kinds of data in the database, referred to as  rights.

Feedback

Database administrators interact with the data administration subsystem, and determine processing rights or determining which people have access to what kinds of data in the database.

The correct answer is: processing.

Question 26

Correct

Mark 1.00 out of 1.00

Question text

Having several instances of the same data is called

Select one:

a. data repetition

b. data duplication

c. data redundancy

Data redundancy occurs when you have several instances of the same data stored in multiple files.

d. data doubling

Feedback

The correct answer is: data redundancy.

Question 27

Correct

Mark 1.00 out of 1.00

Question text

Database tables can be related or connected to other tables by common key fields.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 28

Correct

Mark 1.00 out of 1.00

Question text

In a  database, not all the data in a database is physically located in one place.

Feedback

Many times the data in a company is stored not in just one location but in several locations. It is made accessible through a variety of communications networks. The database, then, is a distributed database.

The correct answer is: distributed.

Question 29

Correct

Mark 1.00 out of 1.00

Question text

A bank credit card reflects  processing.

Feedback

In batch processing, data is collected over several hours, days, or even weeks. If you have a bank credit card, your bill probably reflects batch processing.

The correct answer is: batch.

Question 30

Incorrect

Mark 0.00 out of 1.00

Question text

Querying the database and generating reports is assisted by the application generation subsystem.

Select one:

True

False

Feedback

incorrect

The correct answer is 'False'.

Question 31

Correct

Mark 1.00 out of 1.00

Question text

The most basic logical element of data is a .

Feedback

A character is the most basic logical data element. It is a single letter, number, or special character, such as a punctuation mark, or a symbol, such as $.

The correct answer is: character.

Question 32

Correct

Mark 1.00 out of 1.00

Question text

The database in which data elements are stored in a manner that doesn't require an access path down a hierarchy is called the object-oriented database.

Select one:

True

False

Feedback

correct

The correct answer is 'False'.

Question 33

Correct

Mark 1.00 out of 1.00

Question text

Access to these databases is offered to the public or selected outside individuals for a fee.

Select one:

a. company databases

b. distributed databases

c. commercial databases

A commercial database is generally an enormous database that an organization develops to cover particular subjects. It offers access to this database for a fee.

d. data warehouses

Feedback

The correct answer is: commercial databases.

Question 34

Correct

Mark 1.00 out of 1.00

Question text

The analysis tools associated with the data manipulation subsystem include  and structure query languages (SQL).

Feedback

The data manipulation subsystem provides tools for maintaining and analyzing data. Specific tools include query-by-example and specialized programming languages called structured query languages (SQL).

The correct answer is: query-by-example.

Question 35

Correct

Mark 1.00 out of 1.00

Question text

A data field represents a(n)

Select one:

a. character

b. attribute

A data field represents an attribute (description or characteristics) of some entity (person, place, thing, or object).

c. entity

d. record

Feedback

The correct answer is: attribute.

Question 36

Correct

Mark 1.00 out of 1.00

Question text

Traditionally, data is processed in one of two ways: batch processing and  processing.

Feedback

Batch and real-time processing have been used to handle common record-keeping activities such as payroll and sales orders.

The correct answer is: real-time.

Question 37

Correct

Mark 1.00 out of 1.00

Question text

The data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server in these databases.

Select one:

a. Individual databases

In an individual database, typically, the data and the DBMS are under the direct control of the user. They are stored either on the user's hard-disk drive or on a LAN file server.

b. Commercial databases

c. Web databases

d. Company databases

Feedback

The correct answer is: Individual databases.

Question 38

Correct

Mark 1.00 out of 1.00

Question text

In _____, the user must wait for the computer to scan several records one at a time, until the desired record is located.

Select one:

a. sequential access storage

In sequential access storage, by contrast, the user must wait for the computer to scan several records one at a time. It continues scanning until the desired record is located.

b. sequential data access

c. coordinated storage

d. direct access tape

Feedback

The correct answer is: sequential access storage.

Question 39

Correct

Mark 1.00 out of 1.00

Question text

The feature of describing the entry field in a data dictionary form as 'text' is characteristic of

Select one:

a. application generation subsystem

b. data administration subsystem

c. data definition subsystem

The logical structure of the database is described by the data definition subsystem. It defines the type of data for each field (text, numeric, time, graphic, audio, and video).

d. data manipulation subsystem

Feedback

The correct answer is: data definition subsystem.

Question 40

Correct

Mark 1.00 out of 1.00

Question text

The ATM works on the principle of real-time processing.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 41

Correct

Mark 1.00 out of 1.00

Question text

If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a

Select one:

a. lack of data administration

b. lack of data integrity

With data redundancy, if one or more files are overlooked, problems will likely result. This situation results from a lack of data integrity.

c. lack of data maintenance

d. lack of data redundancy

Feedback

The correct answer is: lack of data integrity.

Question 42

Incorrect

Mark 0.00 out of 1.00

Question text

The company database may be stored on a mainframe and managed by a database administrator.

Select one:

True

False

Feedback

incorrect

The correct answer is 'True'.

Question 43

Correct

Mark 1.00 out of 1.00

Question text

Each entry in a/an  database has one parent node, with the parent node having several child nodes.

Feedback

In a hierarchical database, fields or records are structured in nodes. Nodes are points connected like the branches of an upside-down tree. Each entry has one parent node, although a parent may have several child nodes.

The correct answer is: hierarchical.

Question 44

Correct

Mark 1.00 out of 1.00

Question text

In order to create, modify, and gain access to a database, special software called the database management system is required.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 45

Correct

Mark 1.00 out of 1.00

Question text

The  or schema contains a description of the structure of data in the database.

Feedback

A data dictionary contains a description of the structure of data in the database.

The correct answer is: data dictionary.

Question 46

Correct

Mark 1.00 out of 1.00

Question text

Collectively, a person's name, address, and age would be called a

Select one:

a. character

b. field

c. record

A record is a collection of related fields. A record represents a collection of attributes that describe an entity.

d. file

Feedback

The correct answer is: record.

Question 47

Incorrect

Mark 0.00 out of 1.00

Question text

Data typically consists of numbers, letters, and symbols.

Select one:

True

False

Feedback

incorrect

The correct answer is 'False'.

Question 48

Correct

Mark 1.00 out of 1.00

Question text

A network database can utilize ____, special connections between nodes that allow multiple connections between records.

Select one:

a. links

b. pointers

Pointers are used to connect parent nodes and child nodes.

c. strings

d. connectors

Feedback

The correct answer is: pointers.

Question 49

Correct

Mark 1.00 out of 1.00

Question text

Which of the following is not an advantage of using a database?

Select one:

a. Integrity

b. Sharing

c. Reliability

Advantages include sharing, security, less data redundancy, and data integrity.

d. Security

Feedback

The correct answer is: Reliability.

Question 50

Correct

Mark 1.00 out of 1.00

Question text

A record is a collection of related tables.

Select one:

True

False

Feedback

correct

The correct answer is 'False'.

Question 51

Incorrect

Mark 0.00 out of 1.00

Question text

A  represents a collection of attributes that describe an entity.

Feedback

The correct answer is: record.

Question 52

Correct

Mark 1.00 out of 1.00

Question text

A commercial database is generally an enormous database that an organization develops to cover particular subjects.

Select one:

True

False

Feedback

correct

The correct answer is 'True'.

Question 53

Incorrect

Mark 0.00 out of 1.00

Question text

In an object-oriented database, attributes are specific instances of a class that can contain both data and instructions to manipulate the data.

Select one:

True

False

Feedback

incorrect

The correct answer is 'False'.

Question 54

Correct

Mark 1.00 out of 1.00

Question text

The scenario wherein many files about the same person exist across different departments within an organization is called .

Feedback

Many organizations have multiple files on the same subject or person. This is called data redundancy.

The correct answer is: data redundancy.

Question 55

Correct

Mark 1.00 out of 1.00

Question text

In a  database, a node may be reached through more than one path with the help of pointers.

Feedback

A network database is sometimes described as a many-to-many relationship. There are additional connections–called pointers–between parent nodes and child nodes. Thus, a node may be reached through more than one path.

The correct answer is: network.

Question 56

Correct

Mark 1.00 out of 1.00

Question text

Object-oriented databases organize data using objects, classes, entities, attributes, and .

Feedback

Object-oriented databases organize data using objects, classes, entities, attributes, and methods.

The correct answer is: methods.

Question 57

Correct

Mark 1.00 out of 1.00

Question text

Dialog Information Services is an example of a  database.

Feedback

A commercial database is generally an enormous database that an organization develops to cover particular subjects.

The correct answer is: commercial.

Question 58

Correct

Mark 1.00 out of 1.00

Question text

Information collected by an organization from a variety of external and internal databases is stored in special type of database called a

Select one:

a. data warehouse

To support the needs of managers and other business professionals, many organizations collect data from a variety of internal and external databases. This data is then stored in a special type of database called a data warehouse.

b. commercial database

c. company warehouse

d. company database

Feedback

The correct answer is: data warehouse.

Question 59

Correct

Mark 1.00 out of 1.00

Question text

In the  database, data elements are stored in different tables, each of which consists of rows and tables.

Feedback

In a relational database, there are no access paths down a hierarchy. Rather, the data elements are stored in different tables, each of which consists of rows and columns.

The correct answer is: relational.

Question 60

Correct

Mark 1.00 out of 1.00

Question text

Which view of data deals with how the data is actually formatted and located?

Select one:

a. Physical view

The physical view focuses on the actual format and location of the data.

b. Information view

c. Logical view

d. Technical view

Feedback

The correct answer is: Physical view.

Finish review

Skip Quiz navigation

Quiz navigation

Question

1 On this page Correct

Question

2 Correct

Question

3 Correct

Question

4 Correct

Question

5 Correct

Question

6 Correct

Question

7 Correct

Question

8 Correct

Question

9 Correct

Question

10 Correct

Question

11 Correct

Question

12 Correct

Question

13 Correct

Question

14 Correct

Question

15 Incorrect

Question

16 Correct

Question

17 Correct

Question

18 Correct

Question

19 Correct

Question

20 Correct

Question

21 Correct

Question

22 Correct

Question

23 Correct

Question

24 Correct

Question

25 Correct

Question

26 Correct

Question

27 Correct

Question

28 Correct

Question

29 Correct

Question

30 Incorrect

Question

31 Correct

Question

32 Correct

Question

33 Correct

Question

34 Correct

Question

35 Correct

Question

36 Correct

Question

37 Correct

Question

38 Correct

Question

39 Correct

Question

40 Correct

Question

41 Correct

Question

42 Incorrect

Question

43 Correct

Question

44 Correct

Question

45 Correct

Question

46 Correct

Question

47 Incorrect

Question

48 Correct

Question

49 Correct

Question

50 Correct

Question

51 Incorrect

Question

52 Correct

Question

53 Incorrect

Question

54 Correct

Question

55 Correct

Question

56 Correct

Question

57 Correct

Question

58 Correct

Question

59 Correct

Question

60 Correct

Show one page at a time

Finish review

You are logged in as Alexandr Cosarnii (Logout)

TEAP 1311-1