Figuer: -What Programmer's or User's Decision Typically Will Affect the Performance

question 58

Multiple Choice

Figuer:
-What programmer's or user's decision typically will affect the performance of the query?

• A) Placing the condition "PICKUP = 'ERIE' OR PICKUP = 'CARY'" before the condition "CUSTOMER.CID = RENTALS.CID" in the query.
• B) Placing the condition "PICKUP = 'ERIE' OR PICKUP = 'CARY'" after the condition "CUSTOMER.CID = RENTALS.CID" and before the condition "RENTALS.MAKE = RENTCOST.MAKE" in the query.
• C) Selecting the attributes CID in CUSTOMERS and CID in RENTALS as indexes on the tables.
• D) None of the above

---

Definitions:

Deconditioning

The loss of physical fitness or muscle strength due to inactivity or not exercising.

Physical Exercise

Activities requiring physical effort, carried out to sustain or improve health and fitness.

Development

The process of growth or progress, typically involving the gradual increase in complexity or capability.

Catch A Ball

The act of using one's hands to stop and hold a ball that has been thrown, kicked, or hit in one's direction.