Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer

From 211 to 225 of 1187

Q. Operating system is responsible for

a. disk initialization

b. booting from disk

c. bad-bock recovery

d. all of the mentioned

  • 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

  • a. more expensive than

Q. A magneto-optic disk is :

a. primary storage

b. secondary storage

c. tertiary storage

d. none of the mentioned

  • c. tertiary storage

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

  • b. physical database design

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

  • b. data in bad block is usually lost

Q. Which of the following is the oldest database model?

a. relational

b. hierarchical

c. physical

d. network

  • 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

  • b. much larger than

Q. Which one of the following is not a secondary storage?

a. magnetic disks

b. magnetic tapes

c. ram

d. none of the mentioned

  • c. ram

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

  • a. raid level 1

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

  • c. users see the data in one global schema.

Q. Which of the following is not Modification of the Database

a. updating

b. sorting

c. deletion

d. insertion

  • b. sorting

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

  • c. all of the options

Q. Set of premitted values of each attribute is called

a. tuple

b. schema

c. domain

d. relation

  • c. domain

Q. Which of the following is true regarding Null Value?

a. null<0

b. null=0

c. null<>0

d. null>0

  • c. null<>0

Q. Logical design of database is called

a. all of the options

b. database schema

c. database instance

d. database snapshot

  • b. database schema
Subscribe Now

Get All Updates & News