• Author / Uploaded
• Anca Vochescu

Citation preview

Section 4 Quiz (Answer all questions in this section) 1. You issue this SQL statement: SELECT TRUNC(751.367,-1) FROM dual; Which value does this statement display?

Mark for Review (1) Points

750 (*) 751 700 751.3

Incorrect. Refer to Section 4 Lesson 2.

2. ROUND and TRUNC functions can be used with which of the following Datatypes?

Mark for Review (1) Points

Dates and numbers (*) Dates and characters Numbers and characters None of the above

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

Mark for Review (1) Points

TRUNC BINARY ROUND MOD (*)

Correct

4. The answer to the following script is 456. True or False? SELECT TRUNC(ROUND(456.98)) FROM dual;

True False (*)

Correct

Mark for Review (1) Points

5. You issue this SQL statement:

Mark for Review

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

(1) Points

1282 1282.25 1200 1300 (*)

Correct

6.

The STYLES table contains this data:

Mark for Review

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

(1) Points

You query the database and return the value 79. Which script did you use?

SELECT SUBSTR(category, 2,2) FROM styles WHERE style_id = 895840; SELECT SUBSTR(category, -2,2) FROM styles WHERE style_id = 758960; (*) SELECT INSTR(category, -2,2) FROM styles WHERE style_id = 895840; SELECT INSTR(category, 2,2) FROM styles WHERE style_id = 895840; Correct 7.

Evaluate this SELECT statement: SELECT LENGTH(email) FROM employee; What will this SELECT statement display?

The maximum number of characters allowed in the EMAIL column The email address of each employee in the EMPLOYEE table The number of characters for each value in the EMAIL column in the employees table (*)

Mark for Review (1) Points

The longest e-mail address in the EMPLOYEE table

Correct 8.

Which three statements about functions are true? (Choose three.)

Mark for Review (1) Points

(Choose all correct answers) The CONCAT function can only be used on character strings, not on numbers. The SUBSTR character function returns a portion of a string beginning at a defined character position to a specified length. (*) The ROUND number function rounds a value to a specified decimal place or the nearest whole number. (*) The SYSDATE function returns the Oracle Server date and time. (*) Correct

9.

Character functions accept character arguments and only return character values. True or False?

Mark for Review (1) Points

True False (*)

Correct 10. You query the database with this SQL statement:

Mark for Review

SELECT CONCAT(last_name, (SUBSTR(LOWER(first_name), 4))) (1) Points "Default Password" FROM employees; Which function will be evaluated first?

CONCAT SUBSTR LOWER (*) All three will be evaluated simultaneously.

Correct 11. Which Mark for Review function would you use to (1) Points return the current database server date and time? CURRENTDATE

DATETIME SYSDATE (*) DATE

Correct 12.

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

Mark for Review (1) Points

ROUND MONTHS_BETWEEN ADD_MONTHS (*) TO_DATE

Correct

13.

What function would you use to return the highest date in a month?

Mark for Review (1) Points

END_DAY HIGHEST_DAY FINAL_DAY LAST_DAY (*)

Correct 14.

Which SELECT statement will return a numeric value?

Mark for Review (1) Points

SELECT SYSDATE - 7 FROM employees; SELECT SYSDATE + 600 / 24 FROM employees; SELECT ROUND(hire_date, DAY) FROM employees; SELECT (SYSDATE - hire_date) / 7 FROM employees; (*)

Correct

15.

Which query would return a whole number if the sysdate is 26-May-2004?

Mark for Review (1) Points

SELECT TRUNC(MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12) AS YEARS FROM DUAL;

(*) SELECT TRUNC(YEARS_BETWEEN(SYSDATE,'19-Mar-1979') /12) AS YEARS FROM DUAL; SELECT MONTHS_BETWEEN(SYSDATE,'19-Mar-1979') /12 AS YEARS FROM DUAL; None of the above

Incorrect. Refer to Section 4 Lesson 3.