2024-25-1S-1CT106-BLISG3-SF EXAM

What is the primary goal of database optimization?

• a) To increase the size of the database.
• b) To reduce the number of tables in the database.
• c) To improve the speed and efficiency of database operations.
• d) To enhance the security of the database.

What is an index in a database?

• a) A physical copy of the entire database.
• b) A data structure that improves the speed of data retrieval operations.
• c) A security measure to protect sensitive data.
• d) A tool for data normalization.

Which of the following is a common technique for optimizing database queries?

• a) Increasing the number of tables.
• b) Using complex JOIN operations.
• c) Creating unnecessary indexes.
• d) Using appropriate data types for columns.

What is the purpose of normalization in database design?

• a) To increase data redundancy.
• b) To reduce data redundancy and improve data integrity.
• c) To make the database more complex.
• d) To decrease the number of tables in the database.

What is a clustered index?

• a) An index that stores data in a specific order.
• b) An index that is not physically stored with the data.
• c) An index that is used for security purposes.
• d) An index that is created automatically by the database system.

What is a non-clustered index?

• a) An index that stores data in a specific order.
• b) An index that is not physically stored with the data.
• c) An index that is used for security purposes.
• d) An index that is created automatically by the database system.

What is query optimization?

• a) The process of making database queries more complex.
• b) The process of reducing the number of tables in a database.
• c) The process of improving the performance of database queries.
• d) The process of increasing the size of a database.

What is the impact of excessive indexing on database performance?

• a) It can improve query performance.
• b) It can degrade insert and update performance.
• c) It has no impact on database performance.
• d) It can reduce the size of the database.

What is the purpose of partitioning a database?

• a) To increase the number of tables in the database.
• b) To improve query performance by dividing large tables into smaller, more manageable chunks.
• c) To reduce the security of the database.
• d) To decrease the overall size of the database.

What is the role of a database administrator (DBA) in performance optimization?

• a) To design the database schema.
• b) To write database queries.
• c) To monitor database performance and implement optimization strategies.
• d) To create and maintain user accounts.