RDBMS Lab@Home 12

1. You are a database administrator at AdventureWorks, Inc. As a part of regular maintenance, you need to check the following details:
Current sessions
File space usage
Current transactions
Current connections
How will you perform this task?

Ans.

2.  You are a database administrator at AdventureWorks, Inc. You want to check the information about the operating system resources that are specific to SQL Server. How will you do this?

Ans. 

3. You are a database administrator at AdventureWorks, Inc. The following statements are executed to check the state of I/O operations: 

Select * sys.dm_db_backup_tapes 

Select * from sys.dm_db_pending_io_requests 

Select * from sys.dm_db_cluster_shared_drives 

Select * from sys.dm_db_virtual_files_stats

 However, the preceding statements generated an error. Identify the error and provide the solution.

Ans. https://drive.google.com/open?id=0B08RKBSts8D8UUFnZlN3d291Mmc

4. You are a database administrator at AdventureWorks, Inc. and want to generate an effective execution plan on the Employee table. For this, create a statistics on the Employee table. In addition, show the list of all the statistics maintained on the Employee table?

Ans. https://drive.google.com/open?id=0B08RKBSts8D8YlR1Y1FoOUR6UVk

5.You are a database administrator at AdventureWorks, Inc. You want to get the information regarding the amount of disk activity generated for the Employee table. How will you perform this task?

Ans. https://drive.google.com/open?id=0B08RKBSts8D8WGp6bU81dGlrOFk

6. An employee having contact ID as 2 got married and her last name has been changed to Smith. You have to make the required changes in the Contact table and track these changes by using the CDC method. (Use the AdventureWorks database)

Ans. https://drive.google.com/open?id=0B08RKBSts8D8U0I0U0s2VzljS00

7. An employee having contact ID as 4 has changed his title from (Sr.) to (Mr.). You need to update its record into Contact table and track these changes by using the track changing method. (Use the AdventureWorks database)

Ans.https://drive.google.com/open?id=0B08RKBSts8D8TXh5TGQtRkg5UDQ