Section 4 Quiz

Section 4 Quiz

(Answer all questions in this section)  You ou issue this SQL statement: 1.  Y SELECT TRUNC(7!"#$7%&!) 'R *ual+ ,hich -alue *oes this statement *is.la/0

ar1 2or Re-iew (!) 3oints

74 (5) 7! 744 7!"#

6ncorrect" Re2er Re2er to Section  Lesson 8"

2. RUN9 an* TRUNC 2unctions can e use* with which o2 the 2ollowin; 9atat/.es0

ar1 2or Re-iew (!) 3oints

9ates an* numers (5) 9ates an* characters Numers an* characters None o2 the ao-e

Correct

3. ,hich numer 2unction ma/ e use* to *etermine i2 a -alue is o** or e-en0

ar1 2or Re-iew

(!) 3oints  TRUNC <6NARY RUN9 9 (5)

Correct

the 2ollowin; scri.t scri.t is $" True or 'alse0 'alse0 4.  The answer to the SELECT TRUNC(RUN9($"=>)) 'R *ual+

 True  T rue 'alse (5)

Correct

ar1 2or Re-iew (!) 3oints

5.  You issue this SQL statement:

ar1 2or Re-iew

SELECT RUN9 (!8>8"8>% &8) 'R *ual+ ,hat -alue *oes this statement .ro*uce0

(!) 3oints

!8>8 !8>8"8 !844 !#44 (5)

Correct

6.

 The STYLES tale contains this *ata:

ar1 2or Re-iew

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

(!) 3oints

 You quer/ the *ataase an* return the -alue 7=" ,hich scri.t *i* /ou use0

SELECT SU=>4+ SELECT SU=$4+ (5) SELECT 6NSTR(cate;or/% &8%8) 'R st/les ,?ERE st/le@i*  >=>4+ SELECT 6NSTR(cate;or/% 8%8) 'R st/les ,?ERE st/le@i*  >=>4+ Correct

7.

E-aluate this SELECT statement: SELECT LENBT?(email) 'R em.lo/ee+ ,hat will this SELECT statement *is.la/0

 The maimum numer o2 characters allowe* in the EA6L column  The email a**ress o2 each em.lo/ee in the E3LYEE tale  The numer o2 characters 2or each -alue in the EA6L column in the em.lo/ees tale (5)

ar1 2or Re-iew

(!) 3oints

 The lon;est e&mail a**ress in the E3LYEE tale

Correct

8.

,hich three statements aout 2unctions are true0 (Choose three")

ar1 2or Re-iew

(!) 3oints (Choose all correct answers)

 The CNCAT 2unction can onl/ e use* on character strin;s% not on numers"  The SU
9.

Character 2unctions acce.t character ar;uments an* onl/ return character -alues" True or 'alse0

ar1 2or Re-iew (!) 3oints

 True 'alse (5)

Correct

10.  You quer/ the *ataase with this SQL statement:

SELECT CNCAT(last@name% (SU
CNCAT SU
Correct

11. ,hich

ar1 2or Re-iew 2unction woul* /ou use to (!) 3oints return the current *ataase ser-er *ate an* time0 CURRENT9ATE

ar1 2or Re-iew

(!) 3oints

9ATET6E SYS9ATE (5) 9ATE

Correct

12.

 You nee* to sutract three months 2rom the current *ate" ,hich 2unction shoul* /ou use0

ar1 2or Re-iew (!) 3oints

RUN9 NT?S@
Correct

13.

,hat 2unction woul* /ou use to return the hi;hest *ate in a month0

ar1 2or Re-iew (!) 3oints

EN9@9AY ?6B?EST@9AY '6NAL@9AY LAST@9AY (5)

Correct

14.

,hich SELECT statement will return a numeric -alue0

ar1 2or Re-iew

(!) 3oints SELECT SYS9ATE & 7 'R em.lo/ees+ SELECT SYS9ATE F $44 G 8 'R em.lo/ees+ SELECT RUN9(hire@*ate% 9AY) 'R em.lo/ees+ SELECT (SYS9ATE & hire@*ate) G 7 'R em.lo/ees+ (5)

Correct

15.

,hich quer/ woul* return a whole numer i2 the s/s*ate is 8$&a/&8440

ar1 2or Re-iew (!) 3oints

SELECT TRUNC(NT?S@
(5) SELECT TRUNC(YEARS@
6ncorrect" Re2er to Section  Lesson #"