$1.$ This is a two$-$part exercise:

a$.$ Create a script that creates to tables named InvoiceCopy and VendorCopy that

contain

all of the records from the Invoices and Vendors table.

b$.$ Create a script that contains a set of action queries coded as a transaction.

The first

action should update the VendorCopy table by changing the VendorName $$Data

Reproductions Corp$$ to $$DRC$.$ The second action should update all invoices for

Data

Reproductions Corp so that their invoice numbers include the prefix DRC

$($example;

DRC$1234,$ with $1234$ being the original invoice number$).$

$2.$ In a separate text file, describe in $1$ paragraph each, each of the Lock Resource

types in

MS SQL Server $2022.$

$3.$ In a separate text file, describe in $1$ paragraph each, each of the Lock Modes in

MS SQL

Server $2022.$

$4.$ In a separate text file, describe in at least $2$ paragraphs how a Deadlock on an

object

$($Table or Row$)$ could happen and how you would solve it$.$

$5.$ In a separate text file, describe the default locking behavior of MS SQL Server

$2022$