A reason to use a relational database instead of a flat file database would be to:
What is minimizing the amount of redundant data stored in the database?
100
Thisdatabase object should be created to optimize how the underlying data is physically accessed by queries.
What is an index?
100
A data structure that physically stores the data in a relational database table that has a single nonclustered index.
What is a heap?
100
The database language that can be used to retrieve, add, change, or remove data from a table.
What is Database Manipulation Language (DML)?
100
This is the one reason to routinely back up your database.
What is to be able to restore the database to a functioning state after a hardware or server failure?
200
Data about each instance of an entity is stored in a relational database as:
What is a row in a table?
200
An index that includes all columns used by the query is known as:
What is a covering index?
200
A statement that allows a database user to run a stored procedure is this.
What is GRANT EXECUTE?
200
This statement deletes all rows from the table, but does not log each row deleted.
What is TRUNCATE TABLE?
200
A statement used to backup the transaction log.
What is BACKUP LOG?
300
This statement removes permissions that were previously granted on a database object using the GRANT statement.
What is REVOKE?
300
1 is the maximum number of clustered indexes that a ________ ____ can have.
What is a database table?
300
This is a data type that can store a floating point value between 0 and 200,000 to four decimal places of accuracy with the least amount of required storage.
What is smallmoney?
300
The purpose of defining a foreign key is:
What is to define a relationship between two tables?
300
This statement adds a column to a table.
What is ALTER TABLE?
400
This constraint ensures referential integrity.
What is FOREIGN KEY?
400
This constraint specifies for a column that cannot contain duplicate values.
What is UNIQUE?
400
A data type that can store an integer between 0 and 255 and minimize the required storage.
What is tinyint?
400
The PRIMARY KEY constraint ensures which integrity?
What is entity integrity?
400
This type of backup contains only information that has changed since the last complete backup.
What is differential backup?
500
This data type can store a time that includes hours, minutes, and seconds, but no fractional seconds, and can also minimize storage requirements.
What is time?
500
You do this to improve data retrieval performance.
What is denormalizing a database?
500
This datatype can store between one and five characters of alphanumeric data and supports multiple languages with minimal storage space requirements.
What is NVARCHAR(5)?
500
The ALTER statement belongs to this database language group.
What is Database Definition Language (DDL)?
500
This operator returns only rows that are in both of the result sets returned by two other separate queries.