Sail E0 Webinar

MCQs

Total Questions : 63 | Page 4 of 7 pages
Question 31. SERIALIZABLE is the strictest isolation level.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 32. 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 33. Better security occurs if Windows-only authentication is selected.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 34. SQL Server AFTER Triggers may be assigned views.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 35. 'dbo' stands for database object.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 36. 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 37. 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 38.  
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
  1.    Differential recovery
  2.    Full recovery
  3.    Simple recovery
  4.    Bulk-logged recovery
 Discuss Question
Answer: Option D. -> Bulk-logged recovery
Question 39.  Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
  1.    #
  2.    %
  3.    &
  4.    @
 Discuss Question
Answer: Option D. -> @
Question 40.  What mode of authentication does SQL Server NOT provide?
  1.    Windows-only security
  2.    Both SQL Server and Windows-only security
  3.    Mixed security
  4.    SQL Server only security
 Discuss Question
Answer: Option D. -> SQL Server only security

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