hybrid03Quiz
docx
keyboard_arrow_up
School
Algonquin College *
*We aren’t endorsed by this school
Course
8215
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by MateWaspMaster1017
Quiz
Question 1
(1 point)
Saved
Databases are important, but they do not need backup and data recovery strategies.
Question 1 options:
True
False
Question 2
(1 point)
Saved
For recovering through reprocessing, the data goes back to an unknown point and reprocesses the workload from there.
Question 2 options:
True
False
Question 3
(1 point)
Saved
Database backup strategies include all of the following except:
Question 3 options:
Full database backup
Differential backup
Incremental backup
Dominating backup
Question 4
(1 point)
Saved
Which of the following statements is not correct: In the rollback approach, you are required to:
Question 4 options:
Undo the erroneous changes made to the database
Reprocess the valid transactions
Ignore the erroneous changes made to the database and do not reprocess the valid transactions.
Question 5
(1 point)
Saved
Computer systems can fail due to hardware, human or program errors, and this means that database applications are subject to failure.
Question 5 options:
True
False
Question 6
(1 point)
Saved
When database failure occurs, the system should be returned to a state as close as possible to its state before the failure.
Question 6 options:
True
False
Question 7
(1 point)
Saved
Recovery through reprocessing is not a feasible strategy because:
Question 7 options:
The recovered system may never catch up if the computer is heavily scheduled
The recovered system may catch up if the computer is heavily scheduled
All of the answers are correct
Question 8
(1 point)
Saved
In recovery through rollback/rollforward, you are not allowed to periodically save the database nor to keep a database change log.
Question 8 options:
True
False
Question 9
(1 point)
Saved
Checkpoints speed up database recovery and is done automatically by most DBMS.
Question 9 options:
True
False
Question 10
(1 point)
Saved
Databases can be recovered using after-images since the last checkpoint.
Question 10 options:
True
False
Question 11
(1 point)
Saved
In an organization, the person responsible for developing a failure recovery plan is:
Question 11 options:
The Chief Executive Officer
The Database Operator
The Database Administrator
Question 12
(1 point)
Saved
Both the differential and incremental backup only backup changed files, but they differ in how it is done.
Question 12 options:
True
False
Question 13
(1 point)
Saved
Reprocessing and rollback/forward approaches can be used for data recovery
when failure occurs.
Question 13 options:
True
False
Question 14
(1 point)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Saved
Using the rollforward approach:
Question 14 options:
The database is restored using saved data and valid transactions since the last save.
The database is restored using saved data and valid transactions before the last save.
Using saved data and valid transactions since the last save are not important.
Question 15
(1 point)
Saved
The database can be in two states after failure. Both states cannot be resolved with backup and correct data. False
Question 15 options:
True
False
Question 16
(1 point)
Saved
Developing a good and functional backup and recovery strategy can help keep the database safe from potential issues.
Question 16 options:
True
False
Question 17
(1 point)
Saved
When failure has occurred, you cannot apply rollback or rollforward approaches.
Question 17 options:
True
False
Question 18
(1 point)
Saved
Database backups are an essential aspect of database administration.
Question 18 options:
True
False
Question 19
(1 point)
Saved
A checkpoint is a point of:
Question 19 options:
Synchronization between the database and the transaction log
Failure between the database and the transaction log
Synchronization between the database and computer operators
Question 20
(1 point)
Saved
Select the correct option from the following statements:
Question 20 options:
At the checkpoint, the DBMS accepts new requests
At the checkpoint, the DBMS cannot wait until the writing is successfully completed
At the checkpoint, the DBMS refuses new requests
Submit Quiz
20 of 20 questions saved
SavedSaved