Sail E0 Webinar

MCQs

Total Questions : 46 | Page 2 of 5 pages
Question 11. 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 12. 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 13. 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 14. 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 15. 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 16. To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 17. Failure to control confidentiality may lead to loss of competitiveness.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 18. A transaction log shows before and after images of records that have been modified by transactions.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 19. Authorization tables contain highly sensitive data and should be protected by stringent security rules.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 20. The greatest threat to business security is often internal rather than external.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True

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