An application has submitted the following query to the database: Select count(*

Question

An application has submitted the following query to the database:

Select count(*)
from CSC342.Factory_Order
where order_date = sysdate;

Using all you've learned this semester, list and describe the logical steps the DBMS will process through once it receives the query to produce the result set. I do not want you to perform a calculation, but rather show me that you understand the process. List the logical steps, what does each step do, and what things does each step use to complete its decision.

Explanation / Answer

This query returns number of orders placed in the current day from CSC342.factory_order table. To get the result first all factory order column are fetched by mapping order date to current date and then the number of rows are counted to give output of the total no of orders placed in current day.

1. FROM: The query gives all the rows from CSC342.factory_order

2. WHERE: The query filters only rows where the order_date is current system date.

3. SELECT: For the available rows, the query returns the count of the orders that were placed in current day by using count function on the available rows.

4. The query presents the result in the form of counting numbers ie. 1, 45, 56, 112 etc.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.