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?

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

Evaluate this SELECT statement:SELECT SYSDATE + 30FROM dual;Which value is returned by the query?

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

Which SQL function can be used to remove heading or trailing characters (or both) from a character string?

The STYLES table contains this data: STYLE_ID STYLE_NAME CATEGORY COST 895840 SANDAL 85940 12.00 968950 SANDAL 85909 10.00 869506 SANDAL 89690 15.00 809090 LOAFER 89098 10.00 890890 LOAFER 89789 14.00 857689 HEEL 85940 11.00 758960 SANDAL 86979 12.00 You query the database and return the value 79. Which script did you use?

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

For which condition would you use an equijoin query with the USING keyword?

Which comparison operator retrieves a list of values?

15. A PDSA cycle: