Sail E0 Webinar

MCQs

Total Questions : 40 | Page 4 of 4 pages
Question 31. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 32. SQL Server supports three recovery modes: simple, full and Bulk.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 33. A differential backup makes a copy of the entire database.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 34. SERIALIZABLE is the strictest isolation level.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 35. READ COMMITTED is the default isolation level.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 36. SQL Server AFTER Triggers may be assigned views.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 37. With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 38. By default, SQL Server will create one data file and one log file for each newly created database.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 39. Better security occurs if Windows-only authentication is selected.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 40. 'dbo' stands for database object.
  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

Chapter 3.1 : INTRODUCTION Chapter 3 : Sinter Plant SAIL E0 - GPOE/GPA 2024
Chapter 2.3 : COAL HANDLING PLANT - Set 1 Chapter 2 : Coke Ovens and Coal Chemicals SAIL E0 - GPOE/GPA 2024
Chapter 1.1 : INTRODUCTION Chapter 1 : Raw Material Handling Plant SAIL E0 - GPOE/GPA 2024
GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0
DSP Combined 1 Free Revision Test SAIL JO E-0