question

A record consists of a

answer

Set of one or more fields

question

What is a benefit of using a DBMS

answer

They help create an environment for end users to have access to more data

question

The DBMS allows you to extrapolate information from your data by using

answer

Query language

question

Which is NOT considered a 3GL 1. COBOL 2. BASIC 3. Query Language 4. FORTRAN

answer

Query Language

question

Database management systems, operating systems, applications, and utilities are all examples of

answer

Software

question

A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions? a. Data integrity management b. Data storage management c. Data reports d. Security management

answer

Data Reports

question

Ad hoc query is a

answer

Spur-of-the-moment question

question

John is working in the customer table and needs to know what customers are located in Florida. To find the information, he would

answer

Create a new query

question

Which of the following is NOT a data anomaly 1. Modification 2. Insertion 3. Deletion 4. Correction

answer

Correction

question

Who run the organization's daily operations?

answer

End users

question

Activities that make the database perform more efficiently, in terms of storage and access speed, are known as performance___?

answer

Tuning

question

What deals with fixing the database after a failure, such as hard disk malfunction

answer

Recovery

question

A raw fact, such as an invoice date, is known as___?

answer

Data

question

What manages interactions between the end user and the database?

answer

DBMS

question

Another name for production database is a _____ database

answer

transactional

question

All of these are true about database except: 1. It is a shared, integrated structure 2. It stores user data 3. It must contain multiple tables 4. It stores metadata

answer

It must contain multiple tables

question

SQL is

answer

Structured Query Language

question

A relational database is a group of...

answer

Tables

question

One of the advantages of a relations database model is...

answer

Easier database design

question

The hierarchical database model is based on a

answer

Tree structure

question

Given its parent/child structure, the hierarchical model yields integrity and consistency; there cannot be...

answer

A child without a parent

question

A relational database model

answer

Lets the user operate in a human logical environment

question

The network database models have an

answer

Owner/member relationship that promotes database integrity

question

Which of the following was NOT produced by the DBTG of CODASYL? 1. Standard network specifications for a network schema 2. Standard network specifications for a network schema 3. Standard specifications for a data management language 4. Standard diagrams for database modeling known as ERD

answer

Standard diagrams for database modeling known as ERD

question

Because an RDBMS hides the system's complexity from the user/designer....

answer

Data management is easier

question

Database models can be grouped into two categories: conceptual modes and ______ models

answer

Implementation

question

Classes are organized into a class ____

answer

Hierarchy

question

What model contains the least semantics?

answer

Hierarchical

question

Which of the following data models are dependent on their physical structure? 1. Object oriented 2. Relational 3. Semantic 4. Hierarchical

answer

Hierarchical

question

A data model must represent the ___ world as closely as possible

answer

Real

question

What modern development has dramatically changed the direction database technology was moving in?

answer

The internet.

question

Which of the following databases does NOT provide structural independence? 1. Network 2. Relational 3. Entity Relationship 4. Object oriented

answer

Network

question

What model is independent of both hardware and software? 1. Conceptual 2. External 3. Developmental 4. Logical

answer

Conceptual

question

The ___ model adapts a conceptual model to a specific DBMS (Internal, entity, external, database)

answer

Internal

question

What type of relationship is expressed with the phrase "painter paints painting"?

answer

1:M

question

Which of the following is likely to be a business rule as relates to data modeling? 1. A customer may make many payments on an account. 2. A machine operator may not work more than 10 hours in a 24 hour period. 3. A training session cannot be scheduled for fewer than 10 employees or more than 30 employees. 4. Casual fridays take place in the summer.

answer

Casual fridays take place in the summer

question

Nulls, if used improperly, can create problems because they can represent ___

answer

A known, but missing, attribute value.

question

The entity integrity rule requires that ___

answer

All primary key entries are unique, cannot be NULL

question

According to E.F. Codd, another word for the term "relation" is __

answer

Table

question

Each table must have a ____ Key

answer

Primary

question

The key's role is based on a concept known as ___

answer

Determination

question

A table can be logically connected to another table by defining a ___

answer

Common Attribute

question

A relational operator that yields all values from selected attributes is known as the _____ operator. 1. DIFFERENCE 2. PRODUCT 3. SELECT 4. PROJECT

answer

Project

question

In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ____ in the second table

answer

Foreign key

question

A primary key that consists of more than one field is called a ___ key

answer

Composite

question

A field that consists of integer values is a ___ type field

answer

Numeric

question

Which of the following is NOT an allowable operation for a date field? 1. Compare two dates 2. Multiply two dates 3. Convert a date from its internal representation to different presentation format 4. Create a date by adding or subtracting a number of days from a given date

answer

Multiply two dates (WHY WOULD YOU MULTIPLY?)

question

We can describe a link by observing that ___. 1. a primary key of one table appears again as a primary key in a related table 2. a foreign key of one table appears again as a foreign key in a related table 3. a primary key of one table appears again as a foreign key in a related table 4. a foreign key of one table appears again as a primary key in a related table

answer

A primary key of one table appears again as a foreign key in a related table

question

A ___ key is defined as a key that is used strictly for data retrieval purposes.

answer

Secondary key

question

A relational operator that combines all rows from two tables is considered to be a(n).

answer

UNION

question

The ERD is used to graphically represent the ____ database model.

answer

Conceptual

question

A ___ attribute can be further subdivided to yield additional attributes.

answer

Composite

question

A ___ attribute can have only one value.

answer

Single valued

question

A __ attribute need not be physically stored within the database

answer

Derived

question

A ___ relationship exists when two entities are associated

answer

Binary

question

Attributes may share a

answer

Domain

question

In an ER diagram, primary keys are indicated by ___

answer

Underlining

question

What is the ideal number of attributes used to make up a primary key?

answer

One

question

Which of the following might be represented with a multivalued attribute? 1. Persons name 2. Class location 3. Bank account balance 4. Book title

answer

Class location (state, city, building, room number, etc)

question

what type of attribute cannot be created in a DBMS?

answer

Multivalued

question

In the Chen model, cardinality is indicated using the ___ notation a. (max, min) b. (min, max) c. [min ... max] d. {min|max}

answer

(min, max)

question

The extended entity relationship model (EERM) is sometimes referred to as the ___

answer

Enhanced entity relationship model

question

The ___ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).

answer

Specialization Hierarchy

question

One important inheritance characteristic is that all entity subtypes inherit their ___

answer

Primary Key

question

A ___ is the attribute in the super type entity that determines to which entity subtype each supertype occurrence is related

answer

Subtype discriminator

question

Non-overlapping subtypes are subtypes that contain a ___ subset of the supertype entity set

answer

Unique

question

A ___ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world

answer

Design Trap

question

The traditional SDLC is divided into ___ phases.

answer

Five

question

The initial assessment and the feasibility study are part of the SDLC's ____ phase.

answer

Planning

question

Evaluation, maintenance, and enhancement are part of the ____ phase

answer

Maintenance

question

The ___ design is the process of selecting the data storage and data access characteristics of the database

answer

Physical

question

Which of the following questions would NOT be asked by a manager viewing the database? 1. How will the data be accessed? 2. What are the problems? 3. What are the solutions to the problems? 4. What data is required to generate the desired information?

answer

How will the data be accessed? (Why would he ask that if he is viewing the database already, as in already accessed it)

question

What is the primary objective of database design?

answer

To create complete, normalized, nonredundant,and fully integrated conceptual, logical, and physical database models.

question

"Should the existing system be replaced?" is a question that is asked during the ___ stage of the SDLC

answer

Planning

question

Once the data has been loaded into the database, the ___ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints

answer

Database Administrator

IS 443 Test 1 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards