Data Base Quiz 1st Attempt
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
Your college has a database with a Students table. Which of the following could be a primary key in the table?
- Student number - Social Security Number
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
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ___ subsystem.
Data Administration
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data Type
An integral part of a databases management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ___ .
Dictionary
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
The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view.
Logical
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database.
Multidimensional
A link between tables in a relational database that defines how the data is related is called a _____.
Relationship
A collection of related records in a database is referred to as a _____.
Table
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
The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application ___ subsystem.
generation
The DBMS subsystem that allows for data maintenance and data analysis, including providing the capability to create queries, reports, and forms is referred to as the data ___ subsystem.
manipulation
In a relational database, an important field that contains a unique value that identifies each record as individual is the ___ key.
primary
In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ___ .
record
In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something.
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
To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.
Forms
To display or distribute information from a database, programmers or database administrators create ___ .
Reports