When a document has the primary purpose of summarizing and displaying data, what is it called?
a Report
100
What is a composite key?
A key that consists of two or more attributes
100
What is the portion of SQL used to select and edit data?
Data Manipulation Language
100
Why would you have a linking table?
To resolve a many-to-many relationship
100
What is meant by the term NULL?
The absence of a value
200
What would you call something the database is concerned with for which data can be stored?
An Entity
200
What is a natural key?
An attribute that already naturally belongs to the entity
200
If you name a column with more than one word, what are the acceptable characters to enclose the name?
[] and “ “
200
Where are relationships created in SQL Management Studio?
In Database Diagrams
200
What term describes the column specification that determines what kind of data can be stored in a column?
Data Type
300
What is work shadowing?
Observing people at work to see how they interact with the data
300
What are the attributes called when they might be used as the primary key for an entity?
Candidate Keys
300
If a SQL statement includes a WHERE clause, where should that clause be located?
After the complete FROM clause
300
What is an EQUI JOIN?
A type of join that uses the WHERE clause with an equal sign to relate tables.
300
Requirements related to user access and permissions are what kind of requirements?
Security Requirements
400
What is the domain of a database?
The focus / business area / business problem it is designed to solve
400
What is an advantage of a natural key?
A natural key can prevent accidental entry of duplicate rows which helps with data integrity
400
If you perform an UPDATE or DELETE on a table without using a WHERE clause, what is the effect?
Every record in the table is either updated or deleted.
400
What is the concept that every foreign key must relate to an existing primary key called?
Referential Integrity
400
What is the role db_owner?
A built-in database role that allows a user complete control over a database.
500
What is the process of removing anomalies and redundancies from database design?
Normalization
500
When you cannot enter data into a foreign key table unless it is related to an existing record in the primary key table, what SQL action is most affected?
INSERT
500
In SQL Server, how are users given permissions?
They are granted specific actions.
500
What is an advantage of enforcing referential integrity?