DP Sections 4-7 Test Review

Which of the following database design concepts is implemented with a self join?

RR format: write a query with date 27-Oct-17 and year 2001, what year is the result?

You need to subtract three months from the current date. Which function should you use?

SELECT car.vehicle_id, driver.name FROM car LEFT OUTER JOIN driver ON (driver_id) ;

Which would retrieve all rows in both the EMPLOYEES and DEPARTMENTS tables, with no matches?

Which function compares two expressions?

Which two operators can be used in an outer join condition using the outer join operator (+)?

Identify the output from the following SQL statement:SELECT RPAD('SQL',6, '*') FROM DUAL;

CASE & DECODE evaluate expressions in IF-THEN-ELSE logic. DECODE is specific to Oracle syntax

The following statement returns 0 (zero). True or False? SELECT 121/NULLFROM dual;

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

Join two tables that have two columns with the same name, datatype, and precision.

Table A =10 rows & table B =5 rows, how many rows will be returned if you perform a equi-join?

Which statement concerning single row functions is true?

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

Table aliases MUST be used with columns referenced in the JOIN USING clause.

Join EMPLOYEES table and the SCHEDULES table, but the two tables no corresponding columns.

Which General Functions will return the first non-null expression in the expression list?

What is the minimum number of join conditions required to join 5 tables together?

Return a portion of each employee's last name, with first character up to the fifth character.

Which number function may be used to determine if a value is odd or even?

Which create a join that include unmatched rows first table specified in the SELECT statement?

Which two statements concerning SQL functions are true? (Choose two.)

Which of the following statements is the simplest description of a nonequijoin?

Which symbol is used to perform an outer join?

Which best describes the TO_CHAR function?

SELECT UPPER( SUBSTR('Database Programming', INSTR('Database Programming','P'),20)) FROM dual;

Which arithmetic operation will return a numeric value?

What is produced when a join condition is not specified in a multiple-table query?

SELECT ROUND (1282.248, -2) FROM dual; What value does this statement produce?

You need to join all the rows in the EMPLOYEES table to all the rows in the EMP_REFERENCE table