Database Management System (DBMS) MCQs with answers Page - 82

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. A unit of storage that can store one or more records in a hash file organization is denoted as

  • (A) buckets
  • (B) disk pages
  • (C) blocks
  • (D) nodes

A

Admin • 833.24K Points
Coach

Q. The file organization which allows us to read records that would satisfy the join condition by using one block read is

  • (A) heap file organization
  • (B) sequential file organization
  • (C) clustering file organization
  • (D) hash file organization

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

Q. Each tablespace in an Oracle database consists of one or more files called

  • (A) files
  • (B) name space
  • (C) datafiles
  • (D) pfile

A

Admin • 833.24K Points
Coach

Q. The management information system (MIS) structure with one main computer system is called a

  • (A) hierarchical mis structure
  • (B) distributed mis structure
  • (C) centralized mis structure
  • (D) decentralized mis structure

A

Admin • 833.24K Points
Coach

Q. Choose the RDBMS which supports full fledged client server application development

  • (A) dbase v
  • (B) oracle 7.1
  • (C) foxpro 2.1
  • (D) ingress

A

Admin • 833.24K Points
Coach

Q. One approach to standardization storing of data?

  • (A) mis
  • (B) structured programming
  • (C) codasyl specification
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. The highest level in the hierarchy of data organization is called

  • (A) data bank
  • (B) data base
  • (C) data file
  • (D) data record

A

Admin • 833.24K Points
Coach

Q. An audit trail

  • (A) is used to make backup copies
  • (B) is the recorded history of operations performed on a file
  • (C) can be used to restore lost information
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Large collection of files are called

  • (A) fields
  • (B) records
  • (C) database
  • (D) sectors

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.