Understanding Databases and DBMS

What is a database?

• An integrated collection of logically organised data

• A collection of unrelated data

• A type of software application

• A method for storing data

What does a data dictionary contain?

• Metadata about the database

• User data

• Backup information

• Data processing instructions

What is the purpose of Data Definition Language (DDL)?

• To create and destroy databases

• To manipulate data

• To query data

• To secure data

What is the main disadvantage of file-based systems?

• Data redundancy

• High performance

• Easy integration

• Low cost

What is the difference between databases and traditional files?

• Databases automatically retrieve data

• Traditional files are more secure

• Databases are slower

• Traditional files are easier to manage

What is a bit?

• A value that represents the presence or absence of an electronic signal

• A group of interrelated fields

• A collection of records

• A type of database

What is the purpose of Data Manipulation Language (DML)?

• To retrieve, insert, and modify database information

• To define database structures

• To manage user access

• To create backups

What is the role of a database management system (DBMS)?

• To enable storage, modification, and extraction of information from a database

• To create physical storage devices

• To manage hardware resources

• To develop software applications

What is the significance of a database schema?

• It describes the logical structure of the database

• It contains user data

• It is a backup of the database

• It is a type of software

What is the main function of Structured Query Language (SQL)?

• To query, insert, update, and modify data

• To create database backups

• To manage user permissions

• To define data types