DBMS prelim

What is a Database Management System (DBMS)?

• A software application that manages databases

• A computer hardware component used for data storage

• A programming language for creating databases

• A network protocol for database communication

What is the primary purpose of a DBMS?

• To store and manage data efficiently

• To analyze and visualize data

• To create data backups

• To secure data from unauthorized access

Which data model is commonly used in modern DBMS?

• Hierarchical model

• Network model

• Relational model

• Object-oriented model

A collection of interrelated records is called a

• Database
• Spreadsheet
• Text File
• Management information system

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 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

Conceptual design____________

• Involves modeling independent of the DBMS
•  Is a documentation technique.
• Needs data volume and processing frequencies to determine the size of the database.
• s designing the relational model.

In the architecture of a database system, external level is the

• View level
• logical level
• conceptual level
• physical level