Introduction to Database Concepts

What is a database?

• A type of software program

• A type of video game

• A type of computer monitor

• A structured collection of data stored and accessed electronically.

Explain the concept of database user roles.

• Database user roles are used to define the physical structure of a database.

• Database user roles are used to manage permissions and access control for users in a database system.

• Database user roles are only applicable to non-relational databases.

• Database user roles are used for data encryption in a database system.

Define Primary Key in the context of databases.

• A Primary Key is not necessary for database tables.

• A Primary Key in databases is a unique identifier for each record in a table.

• A Primary Key is a secondary identifier for each record in a table.

• A Primary Key can be duplicated within a table.

What is the purpose of a Foreign Key in a database?

• To create a backup of the database

• To store large amounts of data efficiently

• To improve the performance of queries

• To establish a relationship between two tables and enforce referential integrity.

Discuss the importance of Data Integrity Constraints in databases.

• Data Integrity Constraints are unnecessary and slow down database operations.

• Data Integrity Constraints are only useful for small databases.

• Data Integrity Constraints are crucial in databases to ensure data accuracy, consistency, and quality by enforcing rules on data values.

• Data Integrity Constraints can lead to data corruption in databases.

What are the basic components of an SQL query?

• SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

• INSERT

• SELECT

• JOIN

• UPDATE

How does a database user interact with the database?

• By physically visiting the database server

• Through direct manipulation of the database files

• Through queries sent to the database management system (DBMS)

• Via telepathic communication with the DBMS

Why is it essential to have a Primary Key in a database table?

• It helps in organizing data alphabetically

• It is essential to uniquely identify each record and ensure data integrity.

• It slows down the database performance

• It increases the database size unnecessarily

Write a simple SQL query to retrieve all records from a table named 'Students'.

• SELECT * FROM Students;

• SELECT * FROM Teachers;

• SELECT * FROM Classes;

• SELECT * FROM Users;

What is the role of a Foreign Key in maintaining data integrity?

• Foreign Key is used to store large amounts of data efficiently.

• Foreign Key is used to create a backup of the database.

• Foreign Key is used to establish a relationship between two tables and enforce referential integrity.

• Foreign Key is not important for maintaining data integrity.