Basics of DBMS

What is DBMS?

• DBMS is a collection of queries

• DBMS is a high-level language

• DBMS is a programming language

• DBMS stores, modifies and retrieves data

Which type of data can be stored in the database?

• Image oriented data

• Text, files containing data

• Data in the form of audio or video

• All of the above

What is a record in a database?

• A single piece of data in a table

• A collection of fields that store related data

• A database schema

• A primary key

What uniquely identifies a record in a database table?

• Foreign key

• Primary key

• Field name

• Schema

Which of the following is an example of a DBMS?

• MySQL

• Windows

• Microsoft Excel

• HTTP

What is a file processing system?

• A system used to store data in a structured format

• A system that organizes and manages files on a storage device

• A network-based database system

• A cloud storage solution

In a file processing system, what is meant by data redundancy?

• Data is stored in multiple locations unnecessarily

• Data is encrypted multiple times

• Data is deleted after backup

• Data is compressed repeatedly

How does a DBMS solve the problem of data inconsistency?

• By storing data in separate files

• By creating relationships between data

• By allowing only one user to access data at a time

• By automatically deleting duplicate records

What is a major advantage of a DBMS over the file processing system?

• Limited accessibility

• Data independence

• Data redundancy

• Increased complexity

In a file processing system, how is data typically organized?

• In tables and relationships

• In directories and flat files

• In schemas

• In objects and attributes