What is true regarding counting entities in a database? Choose two.

The statement that count entities on the database is correct because executing a count operation directly on the database is generally more efficient than iterating over all the entries. Databases are designed to handle such operations optimally. Most databases provide a means to quickly count records, which can leverage indexing and other optimizations that minimize resource consumption and speed up the process. This approach avoids the overhead of transferring large amounts of data to the application layer just for counting purposes.

Additionally, the choice suggesting the avoidance of iterating over entities from the database to count reinforces good practice in database management. Iteration is typically more resource-intensive and can lead to performance issues, especially with large datasets. Therefore, relying on the database to perform the counting operation simplifies the logic and enhances performance. Utilizing built-in aggregate functions within the database to get a count is preferable compared to retrieving the whole dataset and performing the count in application logic, which could lead to unnecessary complexity and inefficiency.