Database Questions Answers
Q31. What is the difference between a database and a data warehouse
(a) A database is a collection of related data, while a data warehouse is a repository of historical data used for analysis
(b) A database is used for transaction processing, while a data warehouse is used for reporting and analysis
(c) A database is used for small-scale applications, while a data warehouse is used for large-scale applications
(d) None of the above
Answer: (a) A database is a collection of related data, while a data warehouse is a repository of historical data used for analysis
Q32. What is normalization in database design
(a) The process of converting data from one data type to another
(b) The process of indexing data in a database to improve query performance
(c) The process of organizing data in a database to reduce redundancy and improve data integrity
(d) None of the above
Answer: (c) The process of organizing data in a database to reduce redundancy and improve data integrity
Q33. What is a trigger in a database
(a) A type of constraint that ensures data integrity
(b) A type of index that is used to improve query performance
(c) A set of instructions that are automatically executed in response to a database event
(d) None of the above
Answer: (c) A set of instructions that are automatically executed in response to a database event
Q34. What is a transaction log in a database
(a) A record of all changes made to the database since the last backup
(b) A record of all queries executed against the database
(c) A record of all users who have accessed the database
(d) None of the above
Answer: (a) A record of all changes made to the database since the last backup