Database

Tertiary Storage

Question 1
Marks : +2 | -2
Pass Ratio : 100%
A magneto-optic disk is :
primary storage
secondary storage
tertiary storage
none of the mentioned
Explanation:
Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
The replacement of a bad block generally is not totally automatic because
data in bad block cannot be replaced
data in bad block is usually lost
bad block does not contain any data
none of the mentioned
Explanation:
Physical database design is the process of selecting the data storage and data access characteristics of the database.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
Operating system is responsible for
disk initialization
booting from disk
bad-bock recovery
all of the mentioned
Explanation:
Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
Tertiary storage is built with :
a lot of money
unremovable media
removable media
secondary storage
Explanation:
Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
Which of the following are the process of selecting the data storage and data access characteristics of the database?
Logical database design
Physical database design
Testing and performance tuning
Evaluation and selecting
Explanation:
Physical database design is the process of selecting the data storage and data access characteristics of the database.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
Which one of the following is not a secondary storage?
magnetic disks
magnetic tapes
ram
none of the mentioned
Explanation:
Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
A typical tape drive is ________ a typical disk drive.
more expensive than
cheaper than
of the same cost as
none of the mentioned
Explanation:
Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
The surface area of a tape is ________ the surface area of a disk.
much lesser than
much larger than
equal to
none of the mentioned
Explanation:
Network model has data stored in a hierarchical network flow.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
During recovery from a failure
each pair of physical block is examined
specified pair of physical block is examined
first pair of physical block is examined
none of the mentioned
Explanation:
Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
Which of the following is the oldest database model?
Relational
Hierarchical
Physical
Network
Explanation:
Network model has data stored in a hierarchical network flow.