Computer Essentials 11

A data field that represents a description or characteristic of some entity. Entity Character Attribute Record

Attribute

In _______, transactions are collected over time and then processed all at once. real-time processing batch processing consignment processing group processing

Batch Processing

Information collected by an organization from a variety of external and internal databases is stored in this special type of database. Company warehouse Company database Data warehouse Commercial database

Data warehouse

A hierarchical database uses many-to-many relationships. True False

F

A record is a collection of related tables. True False

F

Data consists of only numbers, letters, and symbols. True False

F

In a distributed database, all the data must be physically located in one place. True False

F

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

F

Individual databases are the foundation of management information systems. True False

F

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

F

This commercial database offers news and information on legal, public records, and business issues. CSi LexisNexis Dow Jones Interactive Publishing Dialog Information Services

LexisNexis

Which view of data deals with how the data is actually formatted and located? Physical view Information view Technical view Logical view

Physical View

A field that uniquely identifies each record. Primary key Numeric Common ID

Primary Key

In _______, data is processed at the same time the transaction occurs. Batch processing Group processing Real-time processing Consignment processing

Real-time

A collection of related fields such as a person's name, address, and age. File Character Field Record

Record

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as specialized programming language called _______. SQL VBA HTML XML

SQL

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

T

Data redundancy can occur due to lack of data integrity. True False

T

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

T

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

T

In a network database, nodes may have a many-to-many relationship. True False

T

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

T

Relational database tables require a common data item. True False

T

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

T

The company database may be stored on a central database server and managed by a database administrator. True False

T

The database in which data elements are organized using classes, objects, attributes, and methods is called the object-oriented database. True False

T

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

T

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

T

Typically, one of the duties of a database administrator is to interact with the data administration subsystem. True False

T

In this subsystem, a user can create data entry forms. Application generation Data administration Data definition DBMS engine

application generation

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

attribute

Access to these databases is offered to the public or selected outside individuals, for a fee. Commercial databases Company databases Distributed databases Data warehouses

commercial databases

These types of databases are also called information utilities or data banks. Shared Individual Commercial Distributed

commerical

The combined information presented on this type of database can be used to change the whole merchandising strategy of a store. Individual Company Distributed Commercial

company

Which of the following is an advantage of using multidimensional databases? Network ability Simpler relationships Smaller hard disk usage Conceptualization

conceptualization

This subsystem defines the logical structure of the database by using a data dictionary or schema. Data definition Data manipulation Data administration Application generation

data definition

If all the data in a database is not physically located in one place, it would be a(n) _______ database. Web distributed commercial individual

distributed

In this database model, the fields or records are structured in nodes. Hierarchical Relational Multidimensional Object-oriented

hierarchical

In this type of database, the data and the DBMS are stored either on the user's hard-disk drive or on a LAN file server. Web Individual Company Commercial

individual

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 lack of data _______. integrity redundancy administration maintenance

integrity

These databases store not only data but also instructions to manipulate the data. Multidimensional Object-oriented Network Hierarchical

object oriented

A network database utilizes these special connections between parent nodes and child nodes that allow multiple connections between records. Strings Pointers Connectors Links

pointers

Having several instances of the same data is called data _______. duplication repetition redundancy doubling

redundancy

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

relational

Which of the following is not an advantage of using a database? Security Sharing Data Integrity Reliability

reliability