Database Systems and Integration Assessment

What does SQL stand for?

• Simple Query Language

• Structured Query List

• Structured Query Language

• Standard Query Language

Explain the purpose of a primary key in a database.

• The purpose of a primary key in a database is to uniquely identify each record in a table.

• To group related records together in a table.

• To store large amounts of data efficiently.

• To define the data type of each column in a table.

What is the difference between INNER JOIN and LEFT JOIN in SQL?

• INNER JOIN returns matching rows from both tables; LEFT JOIN returns all rows from the left table and matched rows from the right table.

• INNER JOIN returns all rows from both tables; LEFT JOIN returns only unmatched rows from the left table.

• INNER JOIN includes all rows from the right table; LEFT JOIN excludes unmatched rows from the left table.

• INNER JOIN returns all rows from the left table; LEFT JOIN returns only matching rows from both tables.

Define normalization in the context of databases.

• Normalization is the technique of merging all data into a single table.

• Normalization is the process of organizing data in a database to minimize redundancy and dependency.

• Normalization is the process of increasing data redundancy in a database.

• Normalization refers to the method of encrypting data in a database.

What is the purpose of the SELECT statement in SQL?

• To delete data from a database.

• To create new tables in a database.

• To update existing records in a database.

• To retrieve data from a database.

List three common data types used in MySQL.

• TEXT

• INT, VARCHAR, DATE

• BOOLEAN

• FLOAT

What does CRUD stand for in database operations?

• Create, Read, Update, Delete

• Construct, Read, Update, Delete

• Create, Retrieve, Update, Remove

• Create, Read, Alter, Destroy

How do you connect to a MySQL database using Python?

• Connect using 'mysql.connect()' with parameters.

• Use 'connect_to_mysql()' with host and user details.

• Use 'mysql.connector.connect(host='hostname', user='username', password='password', database='dbname')' to connect.

• Use 'db.connect()' to establish a connection.

What is the function of the WHERE clause in SQL?

• The WHERE clause filters records based on specified conditions.

• The WHERE clause defines the structure of a database table.

• The WHERE clause sorts records in ascending order.

• The WHERE clause groups records by specified fields.

Explain the concept of foreign keys in relational databases.

• Foreign keys are used to store large amounts of data in a single table.

• Foreign keys are used to link two tables together in a relational database, ensuring data integrity and establishing relationships.

• Foreign keys are a type of data type used in SQL queries.

• Foreign keys are primarily used for indexing data in a database.