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 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 trace flag should you use?
You are responsible for managing an instance of SQL Server 2008. You discover that the server is performingvery poorly.
You investigate and discover that deadlocks are causing the problem. You want to identify which processes and resources are causing the problem.
You want to ensure that theinformation you receive about deadlocks is formatted by processes and then by resources. Which trace flag should you use?
Which Transact-SQL statement should you run?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas 15 databases. Users report that some queries take a long time to complete. You investigate and discoverdeadlocks are causing this problem.
You want to receive information about the resources and types of locks that are causing deadlocks along with thecurrent command affected by the deadlocks.
You want to receive this information in Extensible Markup Language(XML) format.
Which Transact-SQL statement should you run?
Which statement should you use to create the trigger?
You are the database administrator for your company and manage all the SQL Server 2008 databases of the company.
You are responsible for performing the daily backup activities on all the databases on the server. Database users regularly create new objects in one of the databases.
You want to be notified when new objectsare created in the database. You want to create a trigger that will fire whenever a new user-defined function is created in the database.
The trigger should insert statement-specific data, such as the name of the database user who issued the CREATE FUNCTION statement, the time the statement was issued, and the Transact-SQL statement that was issued, intoa database table named Log_structures . The Log_structures table was created by using the followingstatement:
CREATE TABLE Log_structures (
user1 nvarchar(100),
createtime datetime,
SQL_stat nvarchar(2000));
Which statement should you use to create the trigger?
What should you do to allow the members of the Role_Admin role to update the Accounts table with the leastadmi
You are the database administrator for a banking firm and maintain all the SQL Server 2008 databases of thefirm.
You create the Accounts table in the Sales schema of the database to store all information regarding thefirm’s customers.
To update the account details of a customer’s account, you instruct another databaseadministrator, Michelle, to create a stored procedure named Upd_account_details in the Sales schema in thedatabase. Michelle runs the following script to create the Upd_account_details procedure:
CREATE PROC Upd_account_details
@AccountName nvarchar(40)
@Address1 nvarchar(40)
@Address2 nvarchar(40)
@City nvarchar(25)
@State nvarchar(2)
@Phone nvarchar(20) AS
INSERT INTO Accounts VALUES
(@AccountName, @Address1, @Address2, @City, @State, @Phone) GO
ALTER AUTHORIZATION ON OBJECT::Upd_account_details TO Michelle; GO
You want to assign permissions on this procedure to the members of the Role_Admin role. You issue the following statement:
GRANT ALL ON OBJECT::Sales.Upd_account_details to Role_Admin
When John, a member of the Role_Admin role, attempts to update a record with the Upd_account_details stored procedure, he receives an error and is unable to update the record.
What should you do to allow the members of the Role_Admin role to update the Accounts table with the leastadministrative effort?
What should you do?
You are a database administrator for your company. Your company stores all its product data in a SQL Server2005 database named Products. You upgrade the Products database to SQL Server 2008. After the upgrade,you create the respective logins and users in the new database on SQL Server 2008. Eric, a user in your database, complains that since the upgrade he is not able to access the tables created byanother user, Adam, through a stored procedure. However, Adam is able to access the tables through the storedprocedure.
You need to ensure that Eric is able to access the data while minimizing excessive permissions. What should you do?
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 role should you add Adam to allow him to perform these tasks without giving him unnecessarypermissions?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas a default instance of SQL Server installed. You want to allow an assistant administrator named Adam to beable to perform the following tasks:
? Execute, start, or stop all local jobs.
? Delete the job history for any local job.
? Enable or disable all local jobs and schedules.
To which role should you add Adam to allow him to perform these tasks without giving him unnecessarypermissions?
Which Transact-SQL script must you run on all three servers?
You are the SQL administrator for your company. You have three SQL Server 2008 computers named SQL1 , SQL2 , and SQL3 . Each server supports a single instance.
You have been asked to configure SQL1 to connect to remote data sources that use OLE DB. You have alsobeen asked to configure SQL2 to control CPU usage and to configure SQL3 to provide access to physicalmemory. Which Transact-SQL script must you run on all three servers?