Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Operating system is responsible for
a. disk initialization
b. booting from disk
c. bad-bock recovery
d. all of the mentioned
Q. A typical tape drive is a typical disk drive.
a. more expensive than
b. cheaper than
c. of the same cost as
d. none of the mentioned
Q. A magneto-optic disk is :
a. primary storage
b. secondary storage
c. tertiary storage
d. none of the mentioned
Q. Which of the following are the process of selecting the data storage and data access characteristics of the database?
a. logical database design
b. physical database design
c. testing and performance tuning
d. evaluation and selecting
Q. The replacement of a bad block generally is not totally automatic because
a. data in bad block cannot be replaced
b. data in bad block is usually lost
c. bad block does not contain any data
d. none of the mentioned
Q. Which of the following is the oldest database model?
a. relational
b. hierarchical
c. physical
d. network
Q. The surface area of a tape is the surface area of a disk.
a. much lesser than
b. much larger than
c. equal to
d. none of the mentioned
Q. Which one of the following is not a secondary storage?
a. magnetic disks
b. magnetic tapes
c. ram
d. none of the mentioned
Q. Which level of RAID refers to disk mirroring with block striping?
a. raid level 1
b. raid level 2
c. raid level 0
d. raid level 3
Q. What are the correct features of a distributed database?
a. is always connected to the internet
b. always requires more than three machines
c. users see the data in one global schema.
d. have to specify the physical location of the data when an update is done
Q. Which of the following is not Modification of the Database
a. updating
b. sorting
c. deletion
d. insertion
Q. Which of the following in not Outer join?
a. left outer join
b. full outer join
c. all of the options
d. right outer join
Q. Logical design of database is called
a. all of the options
b. database schema
c. database instance
d. database snapshot