IS 443 Test 1 – Flashcards

Unlock all answers in this set

Unlock answers
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
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New