Sail E0 Webinar

MCQs

Total Questions : 64 | Page 6 of 7 pages
Question 51. . Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
  1.    Read committed
  2.    Read uncommitted
  3.    Repeatable read
  4.    Serializable
 Discuss Question
Answer: Option C. -> Repeatable read
Question 52. . A cursor type in which the application can only move forward through the recordset is called:
  1.    forward only.
  2.    static.
  3.    keyset.
  4.    dynamic.
 Discuss Question
Answer: Option A. -> forward only.
Question 53. . Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
  1.    Read committed
  2.    Read uncommitted
  3.    Repeatable read
  4.    Serializable
 Discuss Question
Answer: Option B. -> Read uncommitted
Question 54. . Which of the following locks the item from access of any type?
  1.    Implicit lock
  2.    Explicit lock
  3.    Exclusive lock
  4.    Shared lock
 Discuss Question
Answer: Option C. -> Exclusive lock
Question 55. . What is the overall responsibility of the DBA?
  1.    Facilitate the development and use of the database
  2.    Create and populate tables
  3.    Development, operation, and maintenance of the database and its applications
  4.    Both the first and third answers above are correct.
 Discuss Question
Answer: Option D. -> Both the first and third answers above are correct.
Question 56. . The size of a lock is called:
  1.    implicit lock.
  2.    lock granularity.
  3.    exclusive lock.
  4.    shared lock.
 Discuss Question
Answer: Option B. -> lock granularity.
Question 57. . A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
  1.    forward only.
  2.    static.
  3.    keyset.
  4.    dynamic.
 Discuss Question
Answer: Option B. -> static.
Question 58. . Locks placed by the DBMS are called ________ .
  1.    implicit locks
  2.    explicit locks
  3.    exclusive locks
  4.    shared locks
 Discuss Question
Answer: Option A. -> implicit locks
Question 59. . Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
  1.    Read committed
  2.    Read uncommitted
  3.    Repeatable read
  4.    Serializable
 Discuss Question
Answer: Option B. -> Read uncommitted
Question 60. . Which of the following locks the item from access of any type?
  1.    Implicit lock
  2.    Explicit lock
  3.    Exclusive lock
  4.    Shared lock
 Discuss Question
Answer: Option C. -> Exclusive lock

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