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