database final exam – Flashcards
Unlock all answers in this set
Unlock answersquestion
Redundancy refers to what database condition?
answer
The same data is recorded in more than one place in the same database.
question
Which is the function of a primary key?
answer
It uniquely identifies each record.
question
describes the function of a foreign key?
answer
A foreign key is the primary key of one table repeated in another table in order to create a relationship between the tables.
question
defines the function of SQL in a database?
answer
It is the language relational databases use to create database objects and to manipulate and retrieve data.
question
A database entity can best be described as _____.
answer
something the database is concerned with about for which data can be stored
question
defines the term database requirement?
answer
Something a database must do to fulfill its business function.
question
defines data integrity?
answer
The accuracy and correctness of the data in the database.
question
A document that has the primary purpose of summarizing and displaying data is called _____.
answer
a report
question
The focus of a database, the business problem it is designed to solve, is called _____.
answer
the range of the database
question
Observing people at work to see how they interact with the data is called _____.
answer
work shadowing
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
question
A key that consists of two or more attributes combined to make a unique value is called a ____.
answer
Composite Key
question
What represents an advantage of a natural key?
answer
A natural key helps protect data integrity by preventing accidental entry of duplicate rows
question
Define a natural key?
answer
An attribute naturally belongs to the entity.
question
Define a security requirement for databases?
answer
Refers to requirements related to user access and permissions.
question
What types of relationships are depicted in this ERD?
answer
one to one
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
question
What is a term for an entity that resolves a many to many relationship?
answer
Domain
question
Define the term normalization?
answer
The process of removing anomalies and redundancies from database design.
question
Which normal form that removes all repeating groups and arrays?
answer
First Normal Form.
question
Which normal form that removes all transient dependencies?
answer
Second Normal Form.
question
A deletion anomaly occurs _____.
answer
when removing data accidentally causes the loss of other data
question
Which database design adapted to the features and limitations of the database management system?
answer
Physical design
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.
question
What is a variable character type?
answer
Password/Email Address/A String/BLDG Address
question
What is the best definition for the term null?
answer
The absence of a value
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
question
Define a server level account?
answer
login
question
A collection of related permissions is called a _____.
answer
roll
question
What database role allows a user control over the database?
answer
db_owner
