This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Failure with Nonvolatile Storage”.
1. The silicon chips used for data processing are called
a) RAM chips
b) ROM chips
c) Micro processors
d) PROM chips
View Answer
Explanation: PROM is Programmable Read Only Memory.
2. Which of the following is used for manufacturing chips?
a) Control bus
b) Control unit
c) Parity unit
d) Semiconductor
View Answer
Explanation: A semiconductor is a material which has electrical conductivity between that of a conductor such as copper and that of an insulator such as glass.
3. What was the name of the first commercially available microprocessor chip?
a) Intel 308
b) Intel 33
c) Intel 4004
d) Motorola 639
View Answer
Explanation: The Intel 4004 is a 4-bit central processing unit (CPU) released by Intel Corporation in 1971
4. The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as
a) Magnetic core memory
b) Magnetic tape memory
c) Magnetic disk memory
d) Magnetic bubble memory
View Answer
Explanation: Bubble domain visualization by using CMOS-MagView.
5. The ALU of a computer normally contains a number of high speed storage element called
a) Semiconductor memory
b) Registers
c) Hard disks
d) Magnetic disk
View Answer
Explanation: External control unit tells the ALU what operation to perform on that data, and then the ALU stores its result into an output register.
6. Which of the following is used only for data entry and storage, and never for processing?
a) Mouse
b) Dumb terminal
c) Micro computer
d) Dedicated data entry system
View Answer
Explanation: Dumb terminals are those that can interpret a limited number of control codes.
7. Non-volatile storage needs to have a _________ where the loses in future can be recovered.
a) Dump
b) Recover place
c) Disk
d) Redo plan
View Answer
Explanation: The basic scheme is to dump the entire contents of the database to stable storage periodically—say, once per day.
8. A dump of the database contents is also referred to as an _____________ dump.
a) Archival
b) Fuzzy
c) SQL
d) All of the mentioned
View Answer
Explanation: We can archive the dumps and use them later to examine old states of the database.
9. ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re-create the database.
a) Archival
b) Fuzzy
c) SQL
d) All of the mentioned
View Answer
Explanation: Such dumps are useful when migrating data to a different instance of the database, or to a different version of the database software, since the physical locations and layout may be different in the other database instance or database software version.
10. _________ dump schemes have been developed that allow transactions to be active while the dump is in progress.
a) Archival
b) Fuzzy
c) SQL
d) All of the mentioned
View Answer
Explanation: The simple dump procedure described here is costly and so fuzzy dump is used.
Sanfoundry Global Education & Learning Series – Database Management System.
- Check DBMS Books
- Practice Programming MCQs
- Practice RDBMS MCQ
- Check Computer Science Books
- Check Programming Books
