Sail E0 Webinar

MCQs

Total Questions : 64 | Page 3 of 7 pages
Question 21. The size of the lock is referred to as the lock granularity.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. A durable transaction is one in which all committed changes are permanent.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 23. An ACID transaction is one that is atomic, consistent isolated, and durable.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 24. When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 25. The size of a lock is referred to as lock sizing.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 26. When two transactions are being processed against the database at the same time they are termed concurrent transactions.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. Locks placed by the DBMS are explicit locks.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. In optimistic locking, the assumption is made that conflict will occur.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 29. Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30. The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0