Sail E0 Webinar

MCQs

Total Questions : 46 | Page 5 of 5 pages
Question 41. .  Which of the following is true concerning open-source DBMS?
  1.    Is free or nearly free database software whose source code is publicly available
  2.    Is free or nearly free database software whose source code is not publicly available
  3.    Is not competitive against PC-oriented packages and is fully SQL compliant
  4.    Is competitive against PC-oriented packages and is not fully SQL compliant
 Discuss Question
Answer: Option A. -> Is free or nearly free database software whose source code is publicly available
Question 42. .  Concurrency control is important for which of the following reasons?
  1.    To ensure data integrity when updates occur to the database in a multiuser environment
  2.    To ensure data integrity when updates occur to the database in a single-user environment
  3.    To ensure data integrity while reading data occurs to the database in a multiuser environment
  4.    To ensure data integrity while reading data occurs to the database in a single-user environment
 Discuss Question
Answer: Option A. -> To ensure data integrity when updates occur to the database in a multiuser environment
Question 43. . Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
  1.    Rollback
  2.    Rollforward
  3.    Switch to duplicate database
  4.    Reprocess transactions
 Discuss Question
Answer: Option A. -> Rollback
Question 44. . Which of the following is the preferred way to recover a database after a system failure?
  1.    Rollback
  2.    Rollforward
  3.    Switch to duplicate database
  4.    Reprocess transactions
 Discuss Question
Answer: Option C. -> Switch to duplicate database
Question 45. . A data warehouse administrator is concerned with which of the following?
  1.    The time to make a decision but not the typical roles of a database administrator
  2.    The time to make a decision and the typical roles of a database administrator
  3.    The typical roles of a data administrator and redesigning existing applications
  4.    The typical roles of a database administrator and redesigning existing applications
 Discuss Question
Answer: Option B. -> The time to make a decision and the typical roles of a database administrator
Question 46. . A data warehouse administrator is concerned with which of the following?
  1.    The time to make a decision but not the typical roles of a database administrator
  2.    The time to make a decision and the typical roles of a database administrator
  3.    The typical roles of a data administrator and redesigning existing applications
  4.    The typical roles of a database administrator and redesigning existing applications
 Discuss Question
Answer: Option B. -> The time to make a decision and the typical roles of a database administrator

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