Exploring Database Management Systems

What is a database model?

• A database model is a type of software used for data analysis.

• A database model is a framework for organizing and defining the structure of data in a database.

• A database model is a method for securing data against unauthorized access.

• A database model is a programming language for creating applications.

Name three types of database models.

• Object-oriented model

• Relational model, Document model, Key-value model

• Graph model

• Hierarchical model

What is the primary purpose of SQL?

• To manage and manipulate relational databases.

• To store and retrieve files on a server.

• To create and design websites.

• To perform complex mathematical calculations.

Write a basic SQL query to select all records from a table named 'Students'.

• SELECT ALL FROM Students;

• GET * FROM Students;

• SELECT Students;

• SELECT * FROM Students;

What does the acronym SQL stand for?

• Structured Query Language

• Standard Query Language

• Structured Query List

• Simple Query Language

Explain the concept of data integrity.

• Data integrity is the process of deleting unnecessary data.

• Data integrity is the ability to store data in multiple formats.

• Data integrity refers to the speed of data processing.

• Data integrity is the maintenance of, and the assurance of, the accuracy and consistency of data over its entire lifecycle.

What are the different types of data integrity?

• Data Redundancy

• Entity Integrity, Referential Integrity, Domain Integrity, User-Defined Integrity

• Data Compression

• Data Encryption

How can foreign keys help maintain data integrity?

• Foreign keys allow duplicate entries in a table.

• Foreign keys help maintain data integrity by ensuring that relationships between tables are valid and that referenced data exists.

• Foreign keys are only relevant for primary keys in a single table.

• Foreign keys can be used to delete all data in a database.

What is the difference between a primary key and a foreign key?

• A primary key uniquely identifies records in a table, while a foreign key links records between tables.

• A primary key is used for indexing, while a foreign key is used for sorting records.

• A primary key can be duplicated across tables, while a foreign key cannot.

• A primary key is always a string, while a foreign key is always an integer.

Write an SQL query to update a record in the 'Students' table.

• INSERT INTO Students (column_name) VALUES (new_value);

• UPDATE Students SET column_name = new_value WHERE condition;

• SELECT * FROM Students WHERE condition;

• DELETE FROM Students WHERE condition;