database final exam – Flashcards
30 test answers
Unlock all answers in this set
Unlock answers 30question
A database entity can best be described as _____.
answer
something the database is concerned with about for which data can be stored
Unlock the answer
question
defines the term database requirement?
answer
Something a database must do to fulfill its business function.
Unlock the answer
question
defines data integrity?
answer
The accuracy and correctness of the data in the database.
Unlock the answer
question
A document that has the primary purpose of summarizing and displaying data is called _____.
answer
a report
Unlock the answer
question
The focus of a database, the business problem it is designed to solve, is called _____.
answer
the range of the database
Unlock the answer
question
Observing people at work to see how they interact with the data is called _____.
answer
work shadowing
Unlock the answer
question
Which of the following best describes an attribute or combination of attributes that could be used as the primary key for an entity?
answer
candidate key
Unlock the answer
question
A key that consists of two or more attributes combined to make a unique value is called a ____.
answer
Composite Key
Unlock the answer
question
What represents an advantage of a natural key?
answer
A natural key helps protect data integrity by preventing accidental entry of duplicate rows
Unlock the answer
question
Define a natural key?
answer
An attribute naturally belongs to the entity.
Unlock the answer
question
Define a security requirement for databases?
answer
Refers to requirements related to user access and permissions.
Unlock the answer
question
What types of relationships are depicted in this ERD?
answer
one to one
Unlock the answer
question
When you encounter a many to many relationship, you should always _____.
answer
make a linking table that resolves the many to many into two one to many relationships
Unlock the answer
question
What is a term for an entity that resolves a many to many relationship?
answer
Domain
Unlock the answer
question
Define the term normalization?
answer
The process of removing anomalies and redundancies from database design.
Unlock the answer
question
Which normal form that removes all repeating groups and arrays?
answer
First Normal Form.
Unlock the answer
question
Which normal form that removes all transient dependencies?
answer
Second Normal Form.
Unlock the answer
question
A deletion anomaly occurs _____.
answer
when removing data accidentally causes the loss of other data
Unlock the answer
question
Which database design adapted to the features and limitations of the database management system?
answer
Physical design
Unlock the answer
question
Which of the following best defines the term data type?
answer
A column specification that determines what kind of data can be stored in a column.
Unlock the answer
question
What is a variable character type?
answer
Password/Email Address/A String/BLDG Address
Unlock the answer
question
What is the best definition for the term null?
answer
The absence of a value
Unlock the answer
question
Describes what would be returned by these query criteria? WHERE CustomerCity = 'Seattle' OR CustomerLastName LIKE 'M%'
answer
All the last names of customers in Seattle or the last names of the customers starting with M
Unlock the answer
question
Define a server level account?
answer
login
Unlock the answer
question
A collection of related permissions is called a _____.
answer
roll
Unlock the answer
question
What database role allows a user control over the database?
answer
db_owner
Unlock the answer
