File Organisations - DBMS

1.

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

   A.) Centralized MIS structure
   B.) Decentralized MIS structure
   C.) Hierarchical MIS structure
   D.) Distributed MIS structure

Answer: Option 'A'

Centralized MIS structure

2.

Choose the RDBMS which supports full fledged client server application development

   A.) dBase V
   B.) Oracle 7.1
   C.) FoxPro 2.1
   D.) Ingress

Answer: Option 'B'

Oracle 7.1

3.

A top-to-bottom relationship among the items in a database is established by a

   A.) Hierarchical schema
   B.) Network schema
   C.) Relational schema
   D.) All of the mentioned

Answer: Option 'A'

Hierarchical schema

4.

The highest level in the hierarchy of data organization is called

   A.) Data bank
   B.) Data base
   C.) Data file
   D.) Data record

Answer: Option 'B'

Data base

5.

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

Answer: Option 'C'

Users see the data in one global schema.

File Organisations - DBMS Download Pdf