if you want to remove an article from website contact us from top.

    which level of locking provides the highest degree of concurrency in a relational database

    Mohammed

    Guys, does anyone know the answer?

    get which level of locking provides the highest degree of concurrency in a relational database from screen.

    Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer?

    Page level locking locks whole page i.e all rows therefore highly restrictive Table locking is mainly used for concurrency control with DDL operations A row share table lock is the least restrictive, and has the highest degree of concurrency for a table.It indicates the transaction has locked rows in the table and intends to update them.Therefore Row level provides highest level of concurrency.Hence Answer is C

    Computer Science Engineering (CSE) Question  >  Which level of locking provides the highest d...

    Which level of locking provides the highest degree of concurrency in a relational data base?

    a) Page b) Table c) Row d)

    Page, table and row level locking allow the same degree of concurrency

    Correct answer is option 'C'. Can you explain this answer?

    Related Test

    Test: Transactions & Concurrency Control- 1

    Answers

    RAJJI DEVI May 23, 2020 Related

    Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer?

    Page level locking locks whole page i.e all rows therefore highly restrictive

    Table locking is mainly used for concurrency control with DDL operations

    A row share table lock is the least restrictive, and has the highest degree of concurrency for a table.It indicates the transaction has locked rows in the table and intends to update them.

    Therefore Row level provides highest level of concurrency.Hence Answer is C

    Upvote | 1 Reply

    View courses related to this question

    Explore Computer Science Engineering (CSE) courses

    Explore Computer Science Engineering (CSE) courses

    View courses related to this question

    1 Crore+ students have signed up on EduRev. Have you?

    Download as PDF Share with a friend Answer this doubt

    Similar Computer Science Engineering (CSE) Doubts

    WHICH OF THE FOLLOWING CONCURRENCY CONTROL PROTOCOL ENSURES BOTH CONFLICT S...MORE

    1 Answer

    WHICH OF THE FOLLOWING CONCURRENCY CONTROL PROTOCOLS ENSURE BOTH CONFLICT S...MORE

    1 Answer

    A RELATION (FROM THE RELATIONAL DATABASE MODEL) CONSISTS OF A SET OF TUPLES...MORE

    1 Answer

    CONSIDER THE FOLLOWING TWO STATEMENTS ABOUT DATABASE TRANSACTION SCHEDULES:...MORE

    1 Answer

    WITH REGARD TO THE EXPRESSIVE POWER OF THE FORMAL RELATIONAL QUERY LANGUAGE...MORE

    1 Answer

    Question Description

    Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? for Computer Science Engineering (CSE) 2022 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2022 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer?.

    Solutions for Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

    Here you can find the meaning of Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer?, a detailed solution for Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? has been provided alongside types of Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Which level of locking provides the highest degree of concurrency in a relational data base?a)Pageb)Tablec)Rowd)Page, table and row level locking allow the same degree of concurrencyCorrect answer is option 'C'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.

    स्रोत : edurev.in

    Databases: GATE IT 2004

    Which level of locking provides the highest degree of concurrency in a relational database ? ... level locking allow the same degree of concurrency

    GATE IT 2004 | Question: 21

    asked in Databases Nov 2, 2014

    recategorized Nov 14, 2014 by Sankaranarayanan P.N

    8,598 views

    5 Answers

    4 Comments

    Show 4 previous comments

    2 Comments

    1 2 next » Answer: ← Previous Next →

    ← Previous in category

    Next in category →

    Related questions

    Send feedback Rank Predictor College Prediction Useful Links FAQ Corrections Discuss Copyright Request Testimonials Chat Logs Chat Badges Search tips Exam Category Blog Category Blog Tags Privacy Test Series Contact Us

    Developed by Chun

    स्रोत : gateoverflow.in

    GATE

    A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.

    GATE | GATE-IT-2004 | Question 21

    Last Updated : 03 Apr, 2018

    Read Courses Discuss Practice Video

    Which level of locking provides the highest degree of concurrency in a relational data base?

    (A) Page(B) Table(C) Row(D) Page, table and row level locking allow the same degree of concurrencyAnswer: (C)Explanation:

    Page level locking locks whole page i.e all rows therefore highly restrictive

    Table locking is mainly used for concurrency control with DDL operations

    A row share table lock is the least restrictive, and has the highest degree of concurrency for a table.It indicates the transaction has locked rows in the table and intends to update them.

    Therefore, Row level provides highest level of concurrency. Option (C) is correct.

    Quiz of this Question

    स्रोत : www.geeksforgeeks.org

    Do you want to see answer or more ?
    Mohammed 7 day ago
    4

    Guys, does anyone know the answer?

    Click For Answer