Backup & Restore
Security
SQL Maintenance
DBA's Personal Assistant
Name that Object
100
This backup type allows for point-in-time restores
What is transaction log backup?
100
This sql account is the default out-of-the-box administrator account when SQL Authentication mode is used
What is SA?
100
This command checks the logical and physical integrity of a specified database
What is DBCC CHECKDB?
100
This runs as a service which must run to perform jobs
What is SQL Server Agent?
100
This object must be unique and not null
What is a PRIMARY KEY?
200
This method backs up all data including all transactions that have been committed at the time of completion.
What is a Full Database Backup?
200
In SQL 2008, this group is not automatically given System Administrator rights by default
What is BUILTIN\Administrators?
200
This reports and corrects pages and row count inaccuracies in the catalog views
What is DBCC UPDATEUSAGE?
200
This is an alias for a person or group that can receive notifications that a job has completed or failed
What are operators?
200
This object can link two (or more) tables together
What is a FOREIGN KEY?
300
This method of restore is to be used if you need to restore differential or transaction log backups
What is NORECOVERY?
300
This database role gives the user the ability to perform any database level task, including backup database
What is db_owner?
300
Fragmentation of this can cause performance issues with queries
What is Index Fragmentation?
300
This can execute a command-line applications
What is a job?
300
Typically, this object is a virtual table and does not store a set of data values.
What is a VIEW?
400
This statement when used in a restore allows for Point-in-Time recover for transaction log backups.
What is STOPAT?
400
This explicit permission does not allow a user to perform a task, even if given GRANT rights
What is DENY?
400
Updating this provides SQL an up-to-date path to find data, resulting in better performance of queries
What is STATISTICS?
400
This is used to view jobs that have run, are running and are scheduled to run
What is job activity monitor?
400
This query's cached execution plan can help performance of repetitive tasks
What is a stored procedure?
500
This error-detection mechanism verifies pages prior to backup
What is CHECKSUM?
500
When granted SELECT permission on a schema, a user receives SELECT permission on all objects in that schema due to this.
What is Inherited Permissions?
500
This method of fixing fragmented indexes is useful when the average fragmentation is above 30%, but takes the index offline
What is REBUILD INDEX?
500
This stored procedure allows you to define a new job
What is sp_add_job?
500
This allows for a collection of objects
What is SCHEMA?
M
e
n
u