The extent of the database resource that is included with each lock is called the level of

← Prev Question Next Question →

0 votes

74 views

asked Feb 19 in General by Akshatsen (29.9k points)
closed Feb 20 by Akshatsen

A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a

(a) Database-level lock

(b) Table-level lock

(c) Page-level lock

(d) Row-level lock

• database-management
• concurrency-control
• multiversion-schemes

Share It On

1 Answer

0 votes

answered Feb 19 by SiddhiIngale (29.9k points)
selected Feb 19 by Akshatsen

Best answer

Right answer is (a) Database-level lock

To explain: Data base-level lock prevents the use of any tables in the data base from one transaction while another transaction is being processed.

← Prev Question Next Question →

Find MCQs & Mock Test

1. Free JEE Main Mock Test
2. Free NEET Mock Test
3. Class 12 Chapterwise MCQ Test
4. Class 11 Chapterwise Practice Test
5. Class 10 Chapterwise MCQ Test
6. Class 9 Chapterwise MCQ Test
7. Class 8 Chapterwise MCQ Test
8. Class 7 Chapterwise MCQ Test

Related questions

0 votes

1 answer

The extent of the database resource that is included with each lock is called the level of

asked Feb 19 in General by Akshatsen (29.9k points)

• database-management
• concurrency-control
• multiversion-schemes

0 votes

1 answer

_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

asked Feb 19 in General by Akshatsen (29.9k points)

• database-management
• concurrency-control
• multiversion-schemes

0 votes

1 answer

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute valu

asked Feb 19 in General by Akshatsen (29.9k points)

• database-management
• concurrency-control
• multiversion-schemes

0 votes

1 answer

The file organization which allows us to read records that would satisfy the join condition by using one block read is

asked Feb 19 in General by Akshatsen (29.9k points)

• database-management
• concurrency-control
• multiversion-schemes

0 votes

1 answer

A condition that occurs when two transactions wait for each other to unlock data is known as a(n)

asked Feb 19 in General by Akshatsen (29.9k points)

• database-management
• concurrency-control
• multiversion-schemes

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

• All categories
• JEE (28.1k)
• NEET (8.5k)
• Science (741k)
• Mathematics (240k)
• Statistics (2.8k)
• Environmental Science (3.6k)
• Biotechnology (536)
• Social Science (107k)
• Commerce (62.1k)
• Electronics (3.7k)
• Computer (15.6k)
• Artificial Intelligence (AI) (1.4k)
• Information Technology (13.2k)
• Programming (8.6k)
• Political Science (6.4k)
• Home Science (4.0k)
• Psychology (3.3k)
• Sociology (5.5k)
• English (57.7k)
• Hindi (21.1k)
• Aptitude (23.7k)
• Reasoning (14.6k)
• GK (25.7k)
• Olympiad (527)
• Skill Tips (72)
• CBSE (711)
• RBSE (49.1k)
• General (57.7k)
• MSBSHSE (1.8k)
• Tamilnadu Board (59.3k)
• Kerala Board (24.5k)

...