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

SQL parser, optimizer, and execution engine.

B

Index design, splitting, and storage retrieval.

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

Both are transactional and support row-level locking.

B

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

C

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

D

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

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

A

It mainly affects the user interface of the MySQL database.

B

It significantly impacts the database's performance and scalability.

C

It only affects the database's storage capacity.

D

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

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

A

To simplify the user interface of the database.

B

To enhance the security of the database.

C

To increase the storage capacity of the database.

D

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

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

A

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

B

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

C

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

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 mainly used for aesthetic purposes in the database layout.

B

Indexes are used only for sorting data alphabetically.

C

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

D

Index design is crucial for efficient data retrieval and filtering, impacting database 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 enhance the user interface of the database.

D

To increase the storage capacity of the database.

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

A

Reducing the number of tables in the database.

B

Increasing the number of user connections.

C

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

D

Changing the database's physical hardware.

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

A

Adjusting configuration settings like buffer sizes and thread concurrency.

B

Reducing the number of databases on the server.

C

Changing the user interface design.

D

Adjusting the server's physical location.

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

A

To change the format of date and time data.

B

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

C

To increase the amount of data stored.

D

To create more tables in the database.

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

A

They reduce the number of queries that can be executed.

B

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

C

They are primarily used for data backup purposes.

D

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

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 speeds up queries that filter by indexed columns.

C

Indexing is irrelevant to MySQL performance.

D

It generally slows down the database.