← 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
- Free JEE Main Mock Test
- Free NEET Mock Test
- Class 12 Chapterwise MCQ Test
- Class 11 Chapterwise Practice Test
- Class 10 Chapterwise MCQ Test
- Class 9 Chapterwise MCQ Test
- Class 8 Chapterwise MCQ Test
- 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)
...