Database Transaction Log Management
Which of following contains a complete record of all activity that affected the contents of database during a certain period of time
مندرجہ ذیل میں سے کون تمام سرگرمیوں کا مکمل ریکارڈ رکھتا ہے جس نے ایک مخصوص مدت کے دوران ڈیٹا بیس کے مواد کو متاثر کیا۔
Answer: Transaction log
Explanation
A transaction log is a history of actions executed by a "Database Management System" (DBMS) to guarantee "ACID" properties over crashes or hardware failures.
Physically, a log is a file listing changes to the database, stored in a stable storage format.
This question appeared in
Past Papers (2 times)
Computer Operator Past Papers (1 times)
ETEA Past Papers (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- Identify the sentence using the correct verb: Five hours enough time to complete the assignment., Five hours is enough time to complete the assignment., Five hours are enough time to complete the assignment., Five hours have enough time to complete the assignment.
- Which one is the complete information about the database?
- Period of extensive metabolic activity, in which cell grow, enzymes are synthesizes?
- __________ tags when placed on a book in a library, can be used to record and track in a database all of the book's movements.
- Which of the following models or diagrams is used to describe the structure of a database and represent the relationships within the database?
- Change the voice: I ran the obstacle course in record time.
- The following database object can you import from one Microsoft Access database to another?
- Which activity involves the use of weather stations to gather real-time data, like temperature, pressure, etc.?
- What MS Excel 2016 feature can you use if you want to work with one record at a time?
- The time period is reciprocal of
