Ch. 5

Question 1

Single-Row functions may be used in which of the following (select all that apply)
- SELECT
- WHERE
- FROM
- ORDER BY

Answer 1

• SELECT
• WHERE
• ORDER BY

Question 2

What would be returned by the following:

SELECT *
FROM countries
WHERE UPPER(country_name) LIKE ‘%U%S%A%’;

• United States of America
• United States
• Australia
• usa

Answer 2

All are true

Question 3

Which of the following functions can be used to determine how many months a book has been available, from the time it is published until today’s date?

• MONTH
• MON
• MONTH_BETWEEN
• none of the choices are correct.

Answer 3

• none of these choices are correct

Question 4

Which of the following function(s) return a number? Choose all that apply.
- SUBSTR
- INSTR
- MONTHS_BETWEEN
- UPPER
- LRNGTH

Answer 4

• INSTR
• MONTHS_BETWEEN

Question 5

What is returned by the following function:

ROUND(‘17-JUN-20’, ‘MM’)

• 01-JUL-20
• 01-JUN-20
• 01-MAY-20
• 01-JAN-20

Answer 5

• 01-JUL-20

Question 6

Which of the following is a valid SQL statement?

• SELECT ROUND(TRUNC(125.38, 0) FROM DUAL;
• SELECT SUBSTR(ROUND(14.87, 2, 1), -4, 1) FROM DUAL;
• SELECT RPAD(salary, “*” ) FROM DUAL;
• SELECT TRUNC(ROUND(124.67, 1) ) FROM DUAL;

Answer 6

• SELECT TRUNC(ROUND(124.67, 1) ) FROM DUAL;

Question 7

Which of the following functions returns a number?

• UPPER
• SUBSTR
• INSTR
• TRIM

Answer 7

• INSTR

Question 8

What would be returned by the following:

SELECT *
FROM countries
WHERE UPPER(country_name) LIKE ‘u%s%a%’;

• USA
• United States of America
• Any countries with ‘u’, ‘s’, ‘a’ in their name, in that order
• no rows returned

Answer 8

• no rows returned

Question 9

What Oracle SQL function could be used to remove leading and trailing characters at the same time?

• TRIM BOTH
• LTRIM
• TRIM LEADING
• RTRIM

Answer 9

• TRIM BOTH

Question 10

What is returned when the following statement is executed?

SELECT ROUND(15607.329, -1)
FROM DUAL;

• 15607.3
• Syntax error- a negative number is not permitted as the second parameter of the ROUND function
• 15610
• 15607

Answer 10

• 15610