Chapter 1
Computers represent data in a finite manner. What does this mean? Computers are not as intelligent as the human brain. Computers cannot store analog data. There is a limit to how much data they can represent. There are only so many different ways to represent something.
There is a limit to how much data they can represent.
What purpose does a junction table serve? To join two tables with similar data To simplify a one-to-many relationship To identify a primary key To simplify a many-to-many relationship
To simplify a many-to-many relationship
What kind of data can be stored in a Boolean data type? Integer True/False Decimal Positive/Negative
True/False
_____ is another word for a database record. Turing Tunnel Tuple Terrabit
Tuple
How would a grocery chain manage a database containing information on thousands of customers? With data arrays With an HTML based spreadsheet By storing it on an email server With an informational database With a DBMS
With a DBMS
How would a university that needs to have records of student grades store this information? With a Javascript program With an application macro With a generic macro With a relational array With a database table
With a database table
What is the diagram symbol for a database? a circle a line a cloud a cylinder
a cylinder
Each column in a database table is also called _____? a file an array a field a relation a record
a field
A database management system is _____. a computer system for student and employee data a software system for flat files, images, spreadsheets and word processing files a software application that allows the creation and editing of a database while allowing multiple concurrent access of users a software application with structured data and tables
a software application that allows the creation and editing of a database while allowing multiple concurrent access of users
Data integrity restrictions serve to _____. restrict the amount of data accessed by users conserve storage space control data input formats and ensure data-entry validity ensure consistency in repeatedly entered data
control data input formats and ensure data-entry validity
When duplicate versions of the same data appear in different places, _____. data inconsistencies have occurred a security breach has occurred integrity restrictions have been violated data redundancies have occurred
data redundancies have occurred
Data redundancy results from _____. identical data appearing in multiple places in the database identical data inputted in multiple formats identical data accessed by multiple users essential data not appearing in the database
identical data appearing in multiple places in the database
Which database type is the simplest type and is organized into rows and columns in a text file? text database command line line entry shell database
text database
Database security comprises protection of the data within the database from _____. unauthorized external access users accessing restricted areas in the database and from unauthorized external access users accessing certain areas in the database the database administrator and users
users accessing restricted areas in the database and from unauthorized external access
Where is a multi-user database typically located? A central computer server The desktop computer of the database administrator A laptop computer which is used by multiple users A USB flash drive that is passed around the office A desktop computer of one of the employees
A central computer server
What is a database? A base layer for storing items A computer mechanism for storing and retrieving data A part of a computer closest to data A type of a disk
A computer mechanism for storing and retrieving data
A database is comprised of tables, which each have columns and rows. Housed in one specific column and row is one unit of data called: A record A datum A table A DML
A record
What is a query? A statement that displays or alters data in a database An example of a one-to-one relationship A database management system A data type
A statement that displays or alters data in a database
What does a database model provide? The different data types that can be stored in a database The file format to store the database The best names to use for database tables A systematic way to organize data A conceptual representation of digital data
A systematic way to organize data
Which of the following is NOT true about a database field? A table can have more than one field with the same name. Each field in a database is unique. The database fields are the columns in the table. The database fields are containers of data for the table.
A table can have more than one field with the same name.
What is the difference between analog and digital data? Analog data cannot be stored, while digital data are stored using computers. Analog data refer to data from before the invention of computers. There is no real difference. Analog data are continuous, while digital data are discrete.
Analog data are continuous, while digital data are discrete.
What are data? Tables used by computers Basic facts or values Information Text and numbers
Basic facts or values
What is data? Text and numbers Basic facts or values Binary digits Information Tables used by computers
Basic facts or values
In a database, what type of field would you use for the names of customers? Character Integer String Decimal
Character
In a database, _____ run vertically (down the page) and _____ run horizontally (across the page) Columns; Rows Columns; Fields Records; Columns Rows; Columns
Columns; Rows
Which of the following is an advantage of a hierarchical data model? Ability to store multimedia data types Complex data relationships can be modeled Easy to understand database tables Conceptual simplicity
Conceptual simplicity
The database administrator has already set permissions for several people to use the system. Three of the users need to be able to use the database at the same time. What function does the administrator need to set? Security Integrity Concurrency User permissions Backup and recovery
Concurrency
What type of language is ''delete'' in SQL? A query DML or database manipulation language One-to-many SQL or structured query language
DML or database manipulation language
The following terms all describe a set of records: File, View, Record Window, View, Data Set Data Set, Table, File Data Set, View, File
Data Set, Table, File
What is the difference between data and information? Data are basic values or facts, while information consists of organized data used to answer question or solve problems. Data are digital and can include audio while information is analog and text only. Computers can only store data while the human brain stores information. Data is used to make decisions while information is strictly records. Data consists of records while information consists of arrays.
Data are basic values or facts, while information consists of organized data used to answer question or solve problems.
What is the difference between data and information? Computers store data, while the human brain stores information. Data refer to basic values or facts, while information consists of organized data used to answer questions or solve problems. They pretty much mean the same thing. Data are digital, while information is analog.
Data refer to basic values or facts, while information consists of organized data used to answer questions or solve problems.
A ________ is an organized collection of data. Datasystem Header Row Record field Database
Database
What does the acronym DBMS stand for? Database Management Service Database Manipulation System Data-driven Business Management System Database Management Science Database Management System
Database Management System
If you need to store the prices of items sold, what data type would you use? Text Integer Character Decimal
Decimal
In the database example shown here, which fields are numeric (numbers only): ID, Release Date, Rating ID and Rating ID, Rating, Length Length, ID, Rating
ID and Rating
What makes a relational database so effective ? Every object has a unique ID. It can be used to store objects. It can be used to store video. It works best for data that is inherently hierarchical. Multiple tables can be linked together.
Multiple tables can be linked together.
Which of the following database models uses parent-child relationships where each child can have multiple parents? Object-oriented database model Parent-child database model Hierarchical database model Relational database model Network database model
Network database model
Which of the following DBMS models would be used to manage a collection of audio files? Hierarchical Flat files Object-oriented Network Relational
Object-oriented
What are the three fundamental elements of a database management system? Texts, numbers and multimedia Physical database, database engine and database schema Database, file system and search engine Data entry, data storage and data analysis Records, fields and tables
Physical database, database engine and database schema
Which of the following can NOT be repeated in a set of database records? Numeric fields Primary keys Date/time fields Text fields
Primary keys
Which of the following is NOT a potential advantage of a database management system (DBMS)? Allows multiple users to access the same data simultaneously Reduces data storage needs Increases security and reliability due to a limited number of managers Provides automated methods to create, store and retrieve data Reduces multiple versions of the same data
Reduces data storage needs
What does RDBMS stand for? Rapid Development Bit Map Systems Research Development BMS Real Database Messaging System Relational Database Management System
Relational Database Management System
In the data storage sense, what does 'denormalized' mean? Storing data in small chunks Data containing unusual information Standardizing data before it's stored Storing data in large chunks
Storing data in large chunks
What is a database field? A record in a database table A row in a database table The columns in a database table The item numbers in a database table
The columns in a database table