databases quiz
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
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data type
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, videos, images, and extremely large files Use Object Query Language to construct queries that extract data from the databases
Large databases, often called data banks, that cover particular subjects are referred to as ________ databases.
commercial
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ____ subsystem
data administration
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
The interfaces for the logical view of a database and the physical view of a database are provided by the DBMS _____.
engine
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 ___ .
integrity
A link between tables in a relational database that defines how the data is related is called a _____.
relationship
Because it can store virtually unlimited amounts of data that can be shared across networks, and because the data can be kept far more accurately, a ____ has many advantages over a traditional filing system.
database
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
The DBMS engine provides an interface for the end user of the database. This interface is called the ____ view
logical
To search a database for information, create a ___.
query
The type of database that uses common fields to create links between tables is called a ___ database.
relational
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
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 ___ .
database
An integral part of a database management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ____.
dictionary
The DBMS subsystem that allows for data maintenance and data analysis, including providing the capability to create queries, reports, and forms ja referred to as the data ___ subsystem
maintenance
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.
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
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ______.
record
To display or distribute information from a database, programmers or database administrators create____.
reports
A collection of related records in a database is referred to as _____.
table
A database that scores data in different physical locations and that users access through client/server networks is called a _____ database.
distributed
In a database a ____ is a group of related characters in a database table that represents a characteristic of someone or something
field
To control how information is entered into a database, programmers and database administrators create ____ to help ensure data integrity
forms
The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application _____ system
generation
You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In stubhub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ______.
database
In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ___ key.
foreign