Relational Databases PRL Quiz 1.

Read the paper following paper to answer the quiz below.

Šušter, I., & Ranisavljević, T. (2023). OPTIMIZATION OF MYSQL DATABASE. Journal of process management and new technologies, 11(1-2), 141-151.

https://doi.org/10.5937/jpmnt11-44471

Question 1: What are the key components involved in MySQL's query processing?

A

Index design, splitting, and storage retrieval.

B

SQL parser, optimizer, and execution engine.

C

Client interface, server, and data types.

D

Storage engine, transaction manager, and connection manager.

Question 2: How do the InnoDB and MyISAM storage engines in MySQL differ?

A

InnoDB is transactional and supports row-level locking, while MyISAM is faster for read-intensive workloads but non-transactional.

B

Both are transactional and support row-level locking.

C

MyISAM is transactional and suitable for high concurrency, while InnoDB is non-transactional.

D

Both are non-transactional and suitable for read-intensive workloads.

Question 3: What is the impact of selecting a particular storage engine in MySQL?

A

It significantly impacts the database's performance and scalability.

B

It has no significant impact on the database's performance and scalability.

C

It only affects the database's storage capacity.

D

It mainly affects the user interface of the MySQL database.

Question 4: What is the primary objective of physical programming in MySQL?

A

To increase the database's performance by reducing I/O operations.

B

To simplify the user interface of the database.

C

To enhance the security of the database.

D

To increase the storage capacity of the database.

Question 5: How does the choice of data types affect a MySQL database?

A

It significantly impacts the performance and storage requirements of the database.

B

It only changes the way data is displayed in the database.

C

It has no significant impact on the database's performance.

D

It affects the aesthetic appearance of the database only.

Question 6: What is the role of index design in the performance of a MySQL database?

A

Indexes are used only for sorting data alphabetically.

B

Index design is crucial for efficient data retrieval and filtering, impacting database performance.

C

Indexes are mainly used for aesthetic purposes in the database layout.

D

Indexes play a minor role and are not crucial to performance.

Question 7: What is the primary goal of data tuning in MySQL?

A

To locate and eliminate performance bottlenecks in the database.

B

To ensure data security and privacy.

C

To increase the storage capacity of the database.

D

To enhance the user interface of the database.

Question 8. What does query optimization in MySQL typically involve?

A

Increasing the number of user connections.

B

Changing the database's physical hardware.

C

Reducing the number of tables in the database.

D

Modifying the structure of queries, adding or removing indexes, or rewriting queries.

Question 9. What is involved in tuning the setup of the MySQL server?

A

Adjusting the server's physical location.

B

Adjusting configuration settings like buffer sizes and thread concurrency.

C

Reducing the number of databases on the server.

D

Changing the user interface design.

Question 10. What is the purpose of data normalization in MySQL?

A

To create more tables in the database.

B

To structure the database to reduce data duplication and enhance data consistency.

C

To change the format of date and time data.

D

To increase the amount of data stored.

Question 11. How do caching and replication contribute to MySQL's performance?

A

Caching stores frequently accessed data in memory, and replication copies data across servers for availability and scalability.

B

They are primarily used for data backup purposes.

C

Caching and replication are only useful for large-scale databases.

D

They reduce the number of queries that can be executed.

Question 12. What is the impact of indexing on the performance of MySQL databases?

A

It only affects the visual layout of data.

B

Indexing is irrelevant to MySQL performance.

C

Indexing speeds up queries that filter by indexed columns.

D

It generally slows down the database.