Sail E0 Webinar

MCQs

Total Questions : 40 | Page 2 of 4 pages
Question 11. A cursor type in which the application can only move forward through the recordset is called:
  1.    keyset.
  2.    static.
  3.    forward only.
  4.    dynamic.
 Discuss Question
Answer: Option C. -> forward only.
Question 12. Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
  1.    Serializable
  2.    Read committed
  3.    Repeatable read
  4.    Read uncommitted
 Discuss Question
Answer: Option A. -> Serializable
Question 13. A transaction in which either all of the database actions occur or none of them do is called:
  1.    atomic.
  2.    consistent.
  3.    isolated.
  4.    durable.
 Discuss Question
Answer: Option A. -> atomic.
Question 14. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
  1.    Phantom read
  2.    Consistent read
  3.    Nonrepeatable read
  4.    Dirty read
 Discuss Question
Answer: Option D. -> Dirty read
Question 15. Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
  1.    Serializable
  2.    Read committed
  3.    Read uncommitted
  4.    Repeatable read
 Discuss Question
Answer: Option C. -> Read uncommitted
Question 16. The size of a lock is called:
  1.    lock granularity
  2.    exclusive lock
  3.    shared lock
  4.    implicit lock
 Discuss Question
Answer: Option A. -> lock granularity
Question 17. Locks placed by the DBMS are called ________ .
  1.    shared locks
  2.    exclusive locks
  3.    explicit locks
  4.    implicit locks
 Discuss Question
Answer: Option D. -> implicit locks
Question 18. What is the overall responsibility of the DBA?
  1.    Facilitate the development and use of the database
  2.    Create and populate tables
  3.    Both the first and third answers above are correct.
  4.    Development, operation, and maintenance of the database and its applications
 Discuss Question
Answer: Option C. -> Both the first and third answers above are correct.
Question 19. Which of the following locks the item from access of any type?
  1.    Implicit lock
  2.    Shared lock
  3.    Explicit lock
  4.    Exclusive lock
 Discuss Question
Answer: Option D. -> Exclusive lock
Question 20. A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
  1.    dynamic
  2.    forward only
  3.    keyset
  4.    static
 Discuss Question
Answer: Option D. -> static

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