Challenging MYSQL and RDBMS Concepts

What is the primary purpose of database normalization?

• To create more complex data relationships and dependencies.

• To simplify database queries and enhance performance.

• To reduce data redundancy and improve data integrity.

• To increase data duplication and decrease data integrity.

Which normal form eliminates transitive dependencies?

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

• First Normal Form (1NF)

• Second Normal Form (2NF)

In a SQL JOIN, what does the INNER JOIN keyword do?

• The INNER JOIN keyword only returns rows from the first table.

• The INNER JOIN keyword merges two tables without any conditions.

• The INNER JOIN keyword returns all rows from both tables.

• The INNER JOIN keyword returns rows with matching values in both tables.

What is the difference between a LEFT JOIN and a RIGHT JOIN?

• A LEFT JOIN is used for inner joins, while a RIGHT JOIN is used for outer joins.

• A LEFT JOIN includes all records from the left table, while a RIGHT JOIN includes all records from the right table.

• A LEFT JOIN includes all records from both tables, while a RIGHT JOIN includes only matching records.

• A LEFT JOIN excludes records from the left table, while a RIGHT JOIN excludes records from the right table.

How does indexing improve database performance?

• Indexing eliminates the need for queries.

• Indexing increases data redundancy.

• Indexing slows down data retrieval.

• Indexing speeds up data retrieval and improves query performance.

What is a clustered index?

• A clustered index is an index that sorts and stores the data rows of a table based on the indexed column(s), determining the physical order of the data.

• A clustered index is an index that duplicates data rows for faster access.

• A clustered index is an index that only sorts data in memory, not on disk.

• A clustered index is a type of non-clustered index that does not affect data storage.

What are the ACID properties of a transaction?

• Atomicity, Consistency, Isolation, Durability

• Consistency, Durability, Performance, Scalability

• Atomicity, Concurrency, Isolation, Reliability

• Accuracy, Clarity, Simplicity, Flexibility

Which of the following is NOT an ACID property?

• Isolation

• Scalability

• Durability

• Consistency

What is the purpose of a stored procedure in SQL?

• The purpose of a stored procedure in SQL is to encapsulate and execute a set of SQL statements as a single unit.

• To store data permanently in the database.

• To create a new database table.

• To manage user permissions in SQL.

How do stored procedures differ from functions in SQL?

• Stored procedures can only return values and cannot perform actions.

• Functions can modify database state while stored procedures cannot.

• Stored procedures are always faster than functions in SQL.

• Stored procedures can perform actions and control flow, while functions return a value and cannot modify database state.