Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SELECT CountryName FROM Country WHERE CountryID = 6 6 2 ; UPDATE Country SET Population = 1 8 1 9 3 6 WHERE CountryID =

SELECT CountryName
FROM Country
WHERE CountryID =662;
UPDATE Country
SET Population =181936
WHERE CountryID =662;
If lock scope is a single row, and T
takes an exclusive lock on CountryID 662, what happens to T
?
Pick
If lock scope is a block, and T
takes an exclusive lock on CountryID 662, select the row(s) that are locked.
222 El Salvador San Salvador 6420744 NAmerica
807 North Macedonia Skopje 2082958 Europe
152 Chile Santiago 18729160 SAmerica
760 Syria Damascus 16906283 Asia
586 Pakistan Islamabad 212215030 Asia
690 Seychelles Victoria 96762 Africa
148 Chad N'Djamena 15477751 Africa
662 Saint Lucia Castries 181889 NAmerica
705 Slovenia Ljubljana 2073894 EuropeSELECT CountryName
FROM Country
WHERE CountryID =662;
UPDATE Country
SET Population =181936
WHERE CountryID =662;
If lock scope is a single row, and T
takes an exclusive lock on CountryID 662, what happens to T
?
Pick
If lock scope is a block, and T
takes an exclusive lock on CountryID 662, select the row(s) that are locked.
222 El Salvador San Salvador 6420744 NAmerica
807 North Macedonia Skopje 2082958 Europe
152 Chile Santiago 18729160 SAmerica
760 Syria Damascus 16906283 Asia
586 Pakistan Islamabad 212215030 Asia
690 Seychelles Victoria 96762 Africa
148 Chad N'Djamena 15477751 Africa
662 Saint Lucia Castries 181889 NAmerica
705 Slovenia Ljubljana 2073894 EuropeSELECT CountryName
FROM Country
WHERE CountryID =662;
UPDATE Country
SET Population =181936
WHERE CountryID =662;
If lock scope is a single row, and T
takes an exclusive lock on CountryID 662, what happens to T
?
Pick
If lock scope is a block, and T
takes an exclusive lock on CountryID 662, select the row(s) that are locked.
222 El Salvador San Salvador 6420744 NAmerica
807 North Macedonia Skopje 2082958 Europe
152 Chile Santiago 18729160 SAmerica
760 Syria Damascus 16906283 Asia
586 Pakistan Islamabad 212215030 Asia
690 Seychelles Victoria 96762 Africa
148 Chad N'Djamena 15477751 Africa
662 Saint Lucia Castries 181889 NAmerica
705 Slovenia Ljubljana 2073894 Europe

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions