Could it be a question with no 'WHERE param=value' statement?
Apologies for the simplicity that one...
An unbounded totally one in which the search criteria isn't particularly specific, and it is thus prone to return a really large result set. A question with no WHERE clause would likely fall under this category, but let us consider as it were another options. Let us say we've tables the following:
CREATE TABLE SALES_DATA (ID_SALES_DATA NUMBER PRIMARY KEY, TRANSACTION_DATE DATE NOT NULL LOCATION NUMBER NOT NULL, TOTAL_SALE_AMOUNT NUMBER NOT NULL, ...etc...); CREATE TABLE LOCATION (LOCATION NUMBER PRIMARY KEY, DISTRICT NUMBER NOT NULL, ...etc...);
Guess that you want to pull inside a specific transaction, and that we be aware of ID from the purchase:
SELECT * FROM SALES_DATA WHERE ID_SALES_DATA = <whatever>
Within this situation the totally bounded, and that we can promise it is going to pull either in one or zero rows.
Another illustration of a bounded query, however with a sizable result set will be the one created once the director of district 23 states "I wish to begin to see the total sales for every store during my district for each day this past year", which may be something similar to
SELECT LOCATION, TRUNC(TRANSACTION_DATE), SUM(TOTAL_SALE_AMOUNT) FROM SALES_DATA S, LOCATION L WHERE S.TRANSACTION_DATE BETWEEN '01-JAN-2009' AND '31-DEC-2009' AND L.LOCATION = S.LOCATION AND L.DISTRICT = 23 GROUP BY LOCATION, TRUNC(TRANSACTION_DATE) ORDER BY LOCATION, TRUNC(TRANSACTION_DATE)
Within this situation the query should return 365 (or less, if stores aren't open every single day) rows for every store in district 23. If there's 25 stores within the district it'll return 9125 rows or less.
However, let us say our Vice president of Sales wants some data. He/she/it is not quite certain what's wanted, but he/she/it's confident that anything happened within the first six several weeks of the season...less than sure about which year...and never sure concerning the location, either - most likely in district 23 (he/she/it's were built with a running feud using the individual that runs district 23 within the last 6 years, since that golf tournament where...well, let alone...but when an issue could be held on the doorway of district 23's director so whether it is!)...not to mention he/she/it wants all of the particulars, and also have it on his/her/its desk toot sweet! And therefore we obtain a question that appears something similar to
SELECT L.DISTRICT, S.LOCATION, S.TRANSACTION_DATE, S.something, S.something_else, S.some_more_stuff FROM SALES_DATA S, LOCATIONS L WHERE EXTRACT(MONTH FROM S.TRANSACTION_DATE) <= 6 AND L.LOCATION = S.LOCATION ORDER BY L.DISTRICT, S.LOCATION
It is really an illustration of an unbounded query. The number of rows does it return? Good question - that is dependent how business conditions were, the number of location were open, the number of days there have been in Feb, etc.
Put another way, if you can try a question and also have a very good concept of the number of rows it is going to return (despite the fact that time may be relatively large) the totally bounded. If you cannot, it's unbounded.
Share and revel in.