Database Management System

What is a database?

• A database is a programming language for creating applications.

• A database is a type of software used for web browsing.

• A database is a physical storage device for files.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

What is the purpose of a DBMS?

• To enhance the speed of the internet connection

• The purpose of a DBMS is to manage and organize data in a database.

• To provide internet access to users

• To create backups of data only

What are the different types of databases?

• Flat-file

• Graph-based

• Relational, NoSQL, In-memory, Time-series

• Object-oriented

What is a relational database?

• A relational database is a database that organizes data into tables with defined relationships.

• A relational database stores data in a single file without relationships.

• A relational database is a type of spreadsheet software.

• A relational database is a collection of unstructured documents.

What is a primary key?

• A primary key is an optional field in a database.

• A primary key is a unique identifier for a record in a database.

• A primary key is a duplicate identifier for records.

• A primary key is a type of foreign key.

What is a foreign key?

• A foreign key is a field that stores data from the same table.

• A foreign key is a type of primary key.

• A foreign key is a unique identifier for a table.

• A foreign key is a field that links two tables by referencing the primary key of another table.

What is normalization?

• Normalization is a technique for improving database speed.

• Normalization refers to the process of data encryption.

• Normalization is a database design technique that minimizes data redundancy and dependency.

• Normalization is a method for increasing data redundancy.

What is SQL?

• SQL is a type of database software.

• SQL is a programming language for creating spreadsheets.

• SQL is a programming language for managing relational databases.

• SQL is a markup language for web development.

What does SQL stand for?

• Structured Query List

• Structured Query Language

• Standard Query Language

• Simple Query Language

What is a SELECT statement used for?

• To update existing records in a database.

• To delete data from a database.

• To create a new database table.

• To retrieve data from a database.