Sail E0 Webinar

MCQs

Total Questions : 40 | Page 3 of 4 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. The overall responsibility of the DBA is to facilitate the development and use of the database.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 23. A durable transaction is one in which all committed changes are permanent.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 24. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. An ACID transaction is one that is atomic, consistent isolated, and durable.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. The size of a lock is referred to as lock sizing.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 27. 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 28. 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 29. In optimistic locking, the assumption is made that conflict will occur.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 30. Locks placed by the DBMS are explicit locks.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> 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

DSP Combined 1 Free Revision Test SAIL JO E-0
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
BSP Plant Specific Review Test SAIL JO E-0
BSL Combined 1 Free Revision Test SAIL JO E-0
GFM Combined 1 Free Revision Test SAIL JO E-0