Which of the Following Will Display All Books That Were

question 80

Multiple Choice

Which of the following will display all books that were published at least three years before they were ordered?

• A) SELECT title
• FROM customers NATURAL JOIN orders
• NATURAL JOIN orderitems NATURAL JOIN books
• WHERE orderdate - pubdate >= 3;
• B) SELECT title,
• FROM orders o, orderitems oi, books b
• WHERE
• C)isbn = oi.isbn AND oi.order# = o.order# AND (orderdate-pubdate)/365 >= 3;.
• D)isbn = oi.isbn AND oi.order# = o.order# AND orderdate - pubdate >= 3;,
• E) SELECT title.
• FROM orders o, orderitems oi, books b
• WHERE..

---

Definitions:

Representativeness Heuristic

A cognitive shortcut where people categorize situations or individuals based on how similar they are to typical cases or categories they know.

Prototypes

Original models or first forms from which subsequent forms are derived or developed; in psychology, widely accepted examples of a certain category.

Heuristic

A mental shortcut or rule of thumb that simplifies decision-making but may not always lead to optimal outcomes.

Framing

How information is presented affects how that information is perceived and influences decisions.