Chapter 1

Ace your homework & exams now with Quizwiz!

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


Related study sets

Starting Out with Python, 3e Ch 9

View Set

Nursing 1: Fundamentals Pretest A and B

View Set

Chapter 9 PrepU: The Nurse-Patient Relationship

View Set

Property and Casualty Insurance EXAM

View Set

Advantages/Disadvantages of the Waterfall Method

View Set

Exam 1 Small Business Management

View Set

Women's Roles During World War II

View Set