Sail E0 Webinar

MCQs

Total Questions : 64 | Page 4 of 7 pages
Question 31. The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 32. Locks placed by command are implicit locks.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 33. Database administration refers to a function that applies to the entire organization.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 34. The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 35. A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 36. A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 37. A point of synchronization between the database and the transaction log is generally referred to as a stop point.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 38. An exclusive lock locks the item from change but not from read.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 39.  Locks placed by command are called ________ .
  1.    implicit locks
  2.    explicit locks
  3.    exclusive locks
  4.    shared locks
 Discuss Question
Answer: Option B. -> explicit locks
Question 40.  A transaction for which all committed changes are permanent is called:
  1.    atomic.
  2.    consistent.
  3.    isolated.
  4.    durable.
 Discuss Question
Answer: Option D. -> durable.

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