InterviewSolution

Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.	The two phase locking protocol consists which of the following phases?(a) Growing phase(b) Shrinking phase(c) More than one of the mentioned(d) None of the mentionedI got this question in exam.I need to ask this question from Lock Based Protocols topic in chapter Concurrency Control of RDBMS
Answer» The CORRECT choice is (C) More than one of the mentioned For explanation I would say: The TWO phased locking protocol consists of the growing phase and the shrinking phase.

52.	If a transaction Ti may never make progress, then the transaction is said to be ____________(a) Deadlocked(b) Starved(c) Committed(d) Rolled backI have been asked this question by my college professor while I was bunking the class.This key question is from Lock Based Protocols in chapter Concurrency Control of RDBMS
Answer» Right choice is (b) STARVED To explain: If a transaction Ti may never MAKE PROGRESS, then the transaction is SAID to be starved.

53.	The protocol that indicates when a transaction may lock and unlock each of the data items is called as __________(a) Locking protocol(b) Unlocking protocol(c) Granting protocol(d) Conflict protocolThe question was posed to me in an interview for job.I'm obligated to ask this question of Lock Based Protocols in chapter Concurrency Control of RDBMS
Answer» Right choice is (a) Locking protocol To explain: The protocol that INDICATES when a TRANSACTION may lock and unlock each of the data ITEMS is called as locking protocol. Locking PROTOCOLS restrict the number of schedules.

54.	The situation where no transaction can proceed with normal execution is known as ________(a) Road block(b) Deadlock(c) Execution halt(d) AbortionI have been asked this question in semester exam.Origin of the question is Lock Based Protocols topic in portion Concurrency Control of RDBMS
Answer» Right answer is (b) Deadlock For EXPLANATION I would say: The SITUATION where no transaction can PROCEED with NORMAL execution is known as a deadlock.

55.	State true or false: It is not necessarily desirable for a transaction to unlock a data item immediately after its final access(a) True(b) FalseThe question was posed to me in an online quiz.Question is from Lock Based Protocols topic in section Concurrency Control of RDBMS
Answer» The correct ANSWER is (a) True Explanation: It is not necessarily DESIRABLE for a transaction to unlock a DATA item immediately after its FINAL access because SERIALIZABILITY may be violated due to this.

56.	A transaction is made to wait until all ________ locks held on the item are released(a) Compatible(b) Incompatible(c) Concurrent(d) EquivalentI got this question by my school principal while I was bunking the class.Asked question is from Lock Based Protocols topic in section Concurrency Control of RDBMS
Answer» CORRECT OPTION is (a) Compatible To explain I would say: A transaction is made to wait until all compatible locks held on the item are RELEASED. This ENSURES that no other transaction is concurrently accessing the same item.

57.	If a transaction can be granted a lock on an item immediately in spite of the presence of another mode, then the two modes are said to be ________(a) Concurrent(b) Equivalent(c) Compatible(d) ExecutableI had been asked this question in exam.My doubt stems from Lock Based Protocols topic in section Concurrency Control of RDBMS
Answer» The correct choice is (C) Compatible The best I can explain: If a transaction can be GRANTED a lock on an item immediately in SPITE of the presence of another MODE, then the TWO modes are said to be compatible.

58.	A transaction can proceed only after the concurrency control manager ________ the lock to the transaction(a) Grants(b) Requests(c) Allocates(d) None of the mentionedI got this question in an internship interview.The question is from Lock Based Protocols topic in chapter Concurrency Control of RDBMS
Answer» The CORRECT answer is (a) GRANTS Explanation: A transaction can proceed only after the concurrency CONTROL MANAGER grants the LOCK to the transaction.

59.	If a transaction has obtained a ________ lock, it can both read and write on the item(a) Shared mode(b) Exclusive mode(c) Read only mode(d) Write only modeI got this question in an international level competition.This key question is from Lock Based Protocols in portion Concurrency Control of RDBMS
Answer» Right choice is (B) EXCLUSIVE mode The EXPLANATION is: If a transaction has OBTAINED an exclusive mode lock, then it can both read and write on the item on which it in operating.

60.	If a transaction has obtained a __________ lock, it can read but cannot write on the item(a) Shared mode(b) Exclusive mode(c) Read only mode(d) Write only modeThis question was posed to me in an interview.This interesting question is from Lock Based Protocols topic in chapter Concurrency Control of RDBMS
Answer» Correct answer is (a) Shared mode Explanation: If a TRANSACTION Ti has obtained a shared-mode LOCK (denoted by S) on item Q, then Ti can read, but cannot write, Q.