Which system stored procedure should you use?
You manage an instance of SQL Server 2008 named SQL1 . SQL1 contains a database named Products thatstores product data for the company.
You create a maintenance job for the Products database.
The job runs three Transact-SQL statements to perform maintenance tasks on the Products database.
You configure the jobto run every evening at 8:00 P.M. You verify the next day that the job executed as scheduled.
After three weeks, you discover that the job has failed and is no longer running as scheduled.
You want todetermine the cause of the failure. Which system stored procedure should you use?
Which event should you monitor in the SQL Server Profiler?
You are a database administrator for your company managing all your company’s SQL Server 2008 databases.
The Prod_details database is the main database accessed by users in the company. The head office of thecompany receives data from other branches.
After the employees of the audit department have verified the data,the database is updated with the data.
Some employees in the audit department complain that either the update process is very slow, or timeout errormessages are displayed when they try to update the data in the database.
You suspect concurrency issues to bethe cause of the problem and decide to monitor the transaction locks held on the database objects by using theSQL Server Profiler.
Which event should you monitor in the SQL Server Profiler?
Which file should you check?
You are the database administrator of your company. You configure a new SQL Server Agent job on a SQLServer 2008 computer named SQL1.
You confirm that the job runs successfully. After a month, you discover that the SQL Server Agent has stopped unexpectedly.
You try to start the SQL ServerAgent manually but the agent will not start. You want to identify the cause of the problem. Which file should you check?
Which Transact-SQL should you use?
You are the database administrator for a major shipping company. You manage all the SQL Server 2008 databases of the company.
You have created different jobs in the database to perform different administrativefunctions.
Due to recent scheduling changes, you must reschedule the jobs to be executed at a different time.
You want toidentify details of the last job that was successfully executed on the server.
Which Transact-SQL should you use?
What should you do to achieve this objective?
You are the database administrator of your company. Users report an instance of SQL Server 2008 named SQL1 is performing poorly.
You suspect that deadlocks are causing the server to perform slowly. You want to identifythe cause of the deadlocks.
To achieve this, you want to collect information about the deadlocks and save theinformation to a file. What should you do to achieve this objective?
Which two transaction isolation levels can you configure to accomplish this?
You are the database administrator of your company.
You are in the process of configuring transaction isolationlevel to define the locking and row versioning behavior of Transact-SQL statements.
You want to ensure thatphantom reads do not occur when you configure the transaction isolation level.
Which two transaction isolation levels can you configure to accomplish this? (Choose two. Each correct answerrepresents a complete solution.)
Which event should you trace?
You are the database administrator for a banking company. You manage all the SQL Server 2008 databases ofthe company.
The company stores customer-related data in the database named Cust01. This database isaccessed by most users in the company for different purposes.
The users daily perform insert and updates to the database through a .NET application.
Eric, a user in the database, complains that his transaction has frozen and that he is not able to perform anyoperation in the database.
You find out that the problem is due to a deadlock.
You want to find out the user who isthe other participant in the deadlock by using SQL Server Profiler.
Which event should you trace?
Which function should you use to obtain the required information?
You are the database administrator for your company. You maintain a database named Prod1 on a SQL Server2008 instance named Sql1.
The Prod1 database contains all the orders and product-related information for yourcompany.
Indexes have been created on the key columns of the database tables.
The data in the tables isconstantly updated, and new rows are added to the table.
You notice performance on the database server is degrading.
You consider a high number of indexes in thedatabase to be the cause of this problem.
You are required to identify the lock and latch information and the access methods used for these indexes.
Which function should you use to obtain the required information?
Which command should you use to restart the instance?
You have been hired by your company to manage an instance of SQL Server 2008. The server contains severaluser-defined stored procedures that query the system databases.
You discover that queries against some systemdatabases are not returning the correct results. You decide to repair the corrupt system databases.
To achievethis, you want to start the SQL Server instance in single-user mode without using the minimal configuration.
Which command should you use to restart the instance?
Which statements or functions should you use to obtain the desired results?
You are the database administrator for your company. You manage all the SQL Server 2008 databases in yourcompany. The Prod_details database is the main database accessed by the company’s users. The head officereceives data from other branches of the company. After the data is verified by employees of the auditdepartment, the database is updated with this information. Some employees in the audit department complain they cannot update data in certain tables. You suspect thatother database users are holding locks on these tables.
You must identify the oldest transaction in the database and the SQL Server logins associated with thetransaction.
Which statements or functions should you use to obtain the desired results? (Choose two. Each answerrepresents a part of the solution.)