Sail E0 Webinar

MCQs

Total Questions : 30 | Page 1 of 3 pages
Question 1. Poor data administration can lead to which of the following?
  1.    Missing data elements
  2.    A single definition of the same data entity
  3.    Familiarity with existing data
  4.    All of these
 Discuss Question
Answer: Option A. -> Missing data elements
Question 2. A traditional data administrator performs which of the following roles?
  1.    Tune database performance
  2.    Resolve data ownership issues
  3.    Establish backup and recovery procedures
  4.    Protect the security of the database
 Discuss Question
Answer: Option B. -> Resolve data ownership issues
Question 3. Backward recovery is which of the following?
  1.    Where the before-images are applied to the database
  2.    Where the after-images and before-images are applied to the database
  3.    Where the after-images are applied to the database
  4.    Switching to an existing copy of the database
 Discuss Question
Answer: Option A. -> Where the before-images are applied to the database
Question 4. Which of the following is part of an administrative policy to secure a database?
  1.    Authentication policies
  2.    All of these
  3.    Limiting particular areas within a building to only authorized people
  4.    Ensure appropriate responses rates are in external maintenance agreements
 Discuss Question
Answer: Option B. -> All of these
Question 5. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
  1.    All of these
  2.    Database design
  3.    Data modeling
  4.    Metadata
 Discuss Question
Answer: Option B. -> Database design
Question 6. The transaction log includes which of the following?
  1.    The before-image of a record
  2.    The essential data of the record
  3.    The before and after-image of a record
  4.    The after-image of a record
 Discuss Question
Answer: Option B. -> The essential data of the record
Question 7. Which of the following could cause data to be unavailable?
  1.    All of these
  2.    Planned database maintenance activities
  3.    Data becoming lost or inaccurate
  4.    The database server
 Discuss Question
Answer: Option A. -> All of these
Question 8. Locking may cause which of the following problems?
  1.    Versioning
  2.    Erroneous updates
  3.    All of these
  4.    Deadlock
 Discuss Question
Answer: Option D. -> Deadlock
Question 9. A shared lock allows which of the following types of transactions to occur?
  1.    Read
  2.    Insert
  3.    Update
  4.    Delete
 Discuss Question
Answer: Option A. -> Read
Question 10. Performance analysis and tuning is which of the following?
  1.    Undertaken one time at the time of the implementation of a new application
  2.    Undertaken as an ongoing part of the backup of a database
  3.    Undertaken one time at the time of a DBMS installation
  4.    Undertaken as an ongoing part of managing a database
 Discuss Question
Answer: Option D. -> Undertaken as an ongoing part of managing a database

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