Which tool should you use?
You are your company’s SQL administrator. You have two SQL Server 2008 computers named SQL1 and SQL2.
Both servers have several jobs that are configured to run on a daily basis. Over recent weeks, the job history log has grown much larger than anticipated.
You need to ensure that job history that is older than 60 days is removed from the job history log. Which tool should you use?
Which system table should you check?
You are the database administrator of your company. The network contains an instance of SQL Server 2008.
You create several jobs on the SQL server. After several days, the SQL Server Agent service stops. You want toview the jobs that were being executed when the service stopped.
Which system table should you check?
Which Transact-SQL statement should you use?
You are the SQL administrator for your company. A SQL Server 2008 computer named Sql3 has several alertsconfigured.
One of the alerts was created using the following Transact-SQL statement:
EXEC dbo.sp_add_alert
@name = ‘Backup Alert’,
@enabled = 1,
@message_id = 0,
@severity = 20,
@notification_message = ‘Error. The database will be backed up.’,
@job_name = ‘Back up the Production Database’;
You need to edit the alert so that the alert has a message ID of 56100. Which Transact-SQL statement should you use?
Which SQL Server Agent system stored procedure should you use?
You are the SQL administrator of your company. The network contains 10 SQL Server 2008 computers. Allservers are members of a group named Corporate SQL Servers . You are in the process of creating an operator for a master SQL Server Agent. You run the sp_add_operator system stored procedure to configure the master SQL Server Agent operator on a new server named SQL1 . Now,you want to add SQL1 to the Corporate SQL Servers group. Which SQL Server Agent system stored procedure should you use?
Which Transact-SQL script should you execute?
You manage an instance of SQL Server 2008 named SQL1 . SQL1 has several jobs configured on it. The jobsteps in each job are configured to include the step output in the job history. You want to view the job history forall jobs and job steps that did not run successfully. Which Transact-SQL script should you execute?
What should you do?
You are the SQL administrator for your company. A new SQL Server 2008 computer named SQL_test has beendeployed for the application developers employed by yourcompany. SQL_test has two databases named Customers and Products . The SQL_test databases must be backed up on a weekly basis. You need to ensure that any backups taken forthe databases on SQL_test minimize the space occupied by the backup files using the least amount ofadministrative effort. What should you do?
Which restore statement should you use to identify the backup file that belongs to the Sql1 database?
You are the database administrator for your company. You maintain a SQL Server 2008 instance named Prod1 .This instance has two databases named Sql1 and Sql2.
You take regular backups of these two databases, andstore them on tape drive media sets. The filenames in the two databases are the same.
Due to a media failure, you lose some data files of the Sql1 database.
You are required to restore the data files ofthe Sql1 database, but you notice that you have used the same name for the backup of Sql1 and Sql2.
Which restore statement should you use to identify the backup file that belongs to the Sql1 database?
What will be the default recovery model for the Db01 database?
You are a database administrator managing the SQL Server databases of your company. You have created anew database named Db01 to store the data for a new division in your company. While creating the database,you did not specify the recovery model for the database.
What will be the default recovery model for the Db01 database?
Which activities should you perform to recover the database in the least amount of time?
You are a database administrator for your company. You implement the following backup strategy for your Prod_details database:
? Take a full backup at 10:00 P.M. every day.
? Take a differential level 1 backup at 6:00 A.M. every day.
? Take a transaction log backup every four hours starting at 12 midnight.
? Take a database snapshot at 2:00 P.M.
A user in your database inadvertently deletes some important data from the Tbl_product table at 8:30 A.M. You are required to recover the maximum possible data in the table.
Which activities should you perform to recover the database in the least amount of time?
What is the result of issuing this statement?
You are the database administrator for a banking firm. Your company stores information regarding all itscustomers in a database named Customers . A power failure causes your server to shut down unexpectedly. Thiscauses the database to close improperly. After restoring the power, you restart the server, and start up the database. To ensure that the database is notcorrupted, you issue the following statement:
DBCC CHECKDB;
What is the result of issuing this statement? (Choose all that apply.)