Find the questions in the attached document

timer Asked: Nov 6th, 2016

Question description

I need the answers in 7 hours time. Kindly find attached document.

YOU ARE TO USE SQL COMMANDS TO BUILD THESE UNLESS OTHERWISE NOTED. USE THE AdventureWorks2012 database for the following: 1. Use sp_configure to grant the first parameter to all users by default, show advanced options and run reconfigure. Use sp_configure to change the maximum lock settings from 0 to 20000 using the locks option and run reconfigure. Copy and paste your SQL statements and the results into your assignment submission. Don’t forget to restart the server. Answer the question of why do you restart the server as a part of your solution for this problem. Using SQL Server Management Studio, list the steps you take to change the number of seconds between blocked processes reports to 1. (do not use T-SQL statements) Be specific about the steps and dialogs and dialog field names you change. ***** 2. Write a statement to set the transaction isolation level to repeatable, read for your current session. In the same query, create a transaction that will execute a select statement that will display all columns from HumanResources EmployeePayHistory followed by a select statement that will display all columns from HumanResources Department. Put both select statements within a begincommit transaction block. Answer the following question: What is the one exception that does not allow you to switch isolation levels during a transaction and what is the result if you do try to switch the level? ***** 3. Use the cis605 database to create a begin-commit transaction block. In the block you will execute the following insert statements: insert insert insert insert into into into into employee employee employee employee values values values values (8902, (8903, (8904, (8905, 'Harry', 'Doe', '1C', '777-777-7777'); 'Jane', 'Taylor', '1A', '888-888-8888'); 'Joe', 'Cole', '1A', '999-999-9999'); 'Sue', 'Smith', '2A', '100-100-1000'); within the transaction block save transactions a and b for the first two insert statements and then following the third and fourth insert statements roll back transaction b and then transaction a in that order. Copy and paste the SQL and results into your assignment submission. Verify the results of the transaction block by selecting all columns from employee. Copy and paste the SQL and results into your assignment submission. Answer the question: Looking at the select all from employees results; what was the result of running this transaction and why did you see those results? ***** 4. Using AdventureWorks 2012, create a T-SQL statement that will display the resource, name, request session id, request mode and request status for all system transaction locks. ***** 5. Using cis605, create a T-SQL statement that will disable employee lock escalation. 6. What is the difference between implicit and explicit transaction mode ? ***** 7. What kinds of locks are compatible with an exclusive lock ? ***** 8. Discuss the difference between row-level and page-level locking. (detailed answer)

Tutor Answer

(Top Tutor) Studypool Tutor
School: Boston College
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors