Database - 100%

When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ___ generation subsystem. -Application -Output -Definition -Description

Application

The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ___ subsystem. -Data Administration -Data Management -Data Security -Data Support

Data Administration

What element of a database field specifies the data in a field such as text, numeric, or date/time? -Data Type -Data Configuration -Data Mart -Data Specificity

Data Type

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ___ . -infomart -File cabinet -Database -Spreadsheet

Database

Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ___ . -Databases -Spreadsheets -Lists -Amazon.com

Databases

An integral part of a databases management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ___ . -Reference -Structure -Encyclopedia -Dictionary

Dictionary

A database that stores data in different physical locations and that users access though client/server networks is called a ___ database. -Distributed -Joint-use -Commercial -Structured

Distributed

In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something. -Form -Field -Relationship -Report

Field

When you need to link 2 tables in a database that don't have a field in common, one solution is to create a _____ in one table that links to the primary key in the other table. -Foreign key -False key -Supplemental -Secondary

Foreign key

The type of database that uses common fields to create links between tables is called a ___ database. -Relational -Linkage -Object-oriented -Multi-dimensional

Relational

A link between tables in a relational database that defines how the data is related is called a _____. -Join -Relationship -Patnership -Link

Relationship

To display or distribute information from a database, programmers or database administrators create ___ . -Records -Forms -Tables -Reports

Reports

A collection of related records in a database is referred to as a _____. -Table -Primary Key -Field -Report

Table

Select the advantages of using a database instead of a traditional filing system. -A database can hold larger amounts of data -A database can provide better data integrity -A database can never be hacked -Using a relational database, such as MS Access, is so easy that it requires no instruction

-A database can hold larger amounts of data -A database can provide better data integrity

Select what's true about database fields -A group of related characters in a database -Represents a characteristic of someone or something -Primary key is a field designation -A field is a row in a table

-A group of related characters in a database -Represents a characteristic of someone or something -Primary key is a field designation

Select what's true about object-oriented databases. -Store instructions for how to compute the data as well as the data to be processed -Equipped to handle unstructured data such as MP4 files, video, images, and extremely large files -Use Object Query Language to construct queries that extract data from the database -Are commonly referred to as relational databases.

-Store instructions for how to compute the data as well as the data to be processed -Equipped to handle unstructured data such as MP4 files, video, images, and extremely large files -Use Object Query Language to construct queries that extract data from the database

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity. -Forms -Tables -Records -Relationships

Forms

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ___ . -Hierarchy -Levels -Manager -Company

Hierarchy

Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ___ . -Accuracy -Reliability -Authentication -Integrity

Integrity

The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view. -Logical -Integrity -Physical -Dynamic

Logical

Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ___ System. -Operating -Administration -Management -Organizing

Management

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ___ subsystem. -Manipulation -Definition -Output -Dictionary

Manipulation

To search a database for information, create a ___ . -Form -Query -Field -Report

Query

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ . -Record -List -Field -Table

Record

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database. -Multidemensional -Time-based -Object-oriented -Relational

Multidimensional