CGS2060 Database Quiz
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 DBMS engine provides an interface for the end user of the database. This interface is called the ___ view. - Dynamic - Physical - Logical - Integrity
Logical
The type of database that uses common fields to create links between tables is called a ___ database. - Object-oriented - Relational - Multi-dimensional - Linkage
Relational
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
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
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 ___ . - File cabinet - Spreadsheet - Infomart - Database
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 - Encyclopedia - Dictionary - Structure
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 - Commerical - Structured
Distributed
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 ___ . - Reliability - Authentification - Integrity - Accuracy
Integrity
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 - Management - Administration - 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. - Dictionary - Manipulation - Definition - Output
Manipulation
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database. - Object-oriented - Time-based - Multidimensional - Relational
Multidimensional
To search a database for information, create a ___ . - Query - Report - Form - Field
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 link between tables in a relational database that defines how the data is related is called a _____. - Join - Relationship - Link - Partnership
Relationship
A collection of related records in a database is referred to as a _____. - Field - Table - Primary Key - Report
Table
The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data?
What field name will the data fall under What data type will be included
In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something. - Field - Report - Form - Relationship
Field
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
To display or distribute information from a database, programmers or database administrators create ___ . - Reports - Tables - Records - Forms
Reports
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. - Output - Description - Definition - Application
Application