You have been asked to create a report that lists all customers who have placed orders of at least $2,500. The report’s date should be displayed in the Day, Date Month, Year format (For example, Tuesday, 13 April, 2004 ). Which statement should you issue?

Which SELECT statement will NOT return a date value?

Evaluate this SELECT statement: SELECT p.player_id, m.last_name, m.first_name, t.team_name FROM player p LEFT OUTER JOIN player m ON (p.manager_id = m.player_id) LEFT OUTER JOIN team t ON (p.team_id = t.team_id); Which join is evaluated first?

Which statement concerning single row functions is true?

Which operator can be used with subqueries that return only one row?

The PRICE table contains this data: PRODUCT_ID MANUFACTURER_ID 86950 59604 You query the database and return the value 95. Which SQL script did you use?

Which of the following best describes the meaning of the ANY operator?

You issue this SQL statement: SELECT INSTR (‘organizational sales’, ‘al’) FROM dual; Which value is returned by this command?

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2(20) FIRST_NAME VARCHAR2(20) HIRE_DATE DATEEVAL_MONTHS NUMBER(3) Evaluate this SELECT statement: SELECT hire_date + eval_months FROM employees; The values returned by this SELECT statement will be of which data type?

Which statement about the join syntax of an Oracle Proprietary join syntax SELECT statement is true?