Data Warehouse - Backup MCQ Questions
Data Warehousing Backup MCQs : This section focuses on "Backup" in Data Warehouse. These Multiple Choice Questions (MCQs) should be practiced to improve the Data Warehousing skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.
1. Which of the following backs up the entire database at the same time?
A. Complete backup
B. Partial backup
C. Cold backup
D. Online backup
View Answer
Ans : A
Explanation: Complete backup : It backs up the entire database at the same time.
2. Which of the following backup is taken when the database engine is up and running?
A. Partial backup
B. Cold backup
C. Hot backup
D. Online backup
View Answer
Ans : C
Explanation: Hot backup is taken when the database engine is up and running
3. Tape Media DLT has a Capacity of?
A. 1.6 GB
B. 14 GB
C. 20 GB
D. 40 GB
View Answer
Ans : D
Explanation: Tape Media DLT has a Capacity of 40 GB.
4. The method of loading multiple tapes into a single tape drive is known as ?
A. Tape Silos
B. Tape Stackers
C. Both A and B
D. None of the above
View Answer
Ans : B
Explanation: The method of loading multiple tapes into a single tape drive is known as tape stackers
5. Tape silos provide large store capacities
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, Tape silos provide large store capacities. Tape silos can store and manage thousands of tapes. They can integrate multiple tape drives.
6. Which of the following is not Tape Technology?
A. Standalone tape drives
B. Tape media
C. Tape stackers
D. Tape breaking
View Answer
Ans : D
Explanation: Tape breaking is not Tape Technology.
7. Which of the following is Backup software?
A. Amanda
B. Bacula
C. IBM Tivoli Storage Manager
D. All of the above
View Answer
Ans : D
Explanation: All of the above is Backup software.
8. Backing up the data from disk to disk is much smaller than to the tape.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : B
Explanation: False, Backing up the data from disk to disk is much faster than to the tape.
9. Which of the following is false?
A. The more important the data, the greater the need for backing it up
B. A backup is as useful as its associated restore strategy
C. Storing the backup copy near to its original site is best strategy
D. Automated backup and scheduling is preferred over manual operations
View Answer
Ans : C
Explanation: Storing the backup copy near to its original site is best strategy is false statement.
10. Online backup is quite similar to hot backup.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, Online backup is quite similar to hot backup.
Discussion