DBMS - Introduction

A collection of interrelated records is called a

• Database
• Spreadsheet
• Text File
• Management information system

The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the

• Sequential access method
• Queuing method
• Predetermined method
• Direct access method

In a database, related fields are grouped to

• Record
• File
• Attribute
• Data bank

The database environment is controlled by

• Database administrator
• Database user
• Data Communicator
• Application

Which of the following is not a DBMS

• Drupal
• Oracle
• MySql
• MS Access

Which of the following is not the advantage of database?

• Increase Data Inconsistency
• Data Security
• Reduce Data Redundancy
• Sharing of Data

Which type of data can be stored in the database?

• All of the above
• image oriented data
• Text, files containing data
• Data in the form of audio or video

Which of the following is not a type of database?

• Decentralised
• Hierarchical
• Network
• Relational

__________ are used to identify which type of data we are going to store in the database.

• Datatype
• Tuple
• Table
• Attribute

A logical schema_____________

• Is the entire database.
• describe data in terms of relational tables and columns, object-oriented classes, and XML tags.
• Describes how data is actually stored on disk.
• Both (A) and (C)