Just a coupla Praccy questions ;) PDF

Preview

Summary

THE MACH 1 MUPPET STRIKES AGAIN. wink wink...

Description

JIM^

Cons i dert hi sERD:

Thei dent i fi eroft heent i t ynamedFGRDi s ?

FI D+DI D

DI D+CI D

FI D+DI D+CI D

FI D+FName

FI D

I ncor r ect Quest i on11 0/1pt s Cons i dert hes eTabl esandt heSQLst at ementbel ow: MEMBER MEMBID MEMBNAME BALANCE CATID 1 Eric 0 A 2 Ali 100 B 3 Dave 300 A 4 Karen 2000 B

CATEGORY CATID CATNAME A New B Old

SELECTM. MEMBNAME,C. CATNAME FROM MEMBERM I NNERJ OI NCATEGORYC Us i ngt hepul ldownl i stbel ow, Choos et hec l aus et hatwi l lc or r ec t l yj oi nt hes et abl es ? ONM. MEMBNAME=C. CATNAME Answer1: ONM. MEMBNAME=C. CATNAME

I ncor r ect Quest i on12 0/1pt s Cons i dert hi sTabl enamedMEMBERandt heSQLs t at ement : MEMBER

I D 1 2 3 4 5 6

NAM E Jim Alan Emma Karen Tony Helen

DEPTI D A C B A B C

YEAR S 1 2 3 3 3 3

SELECTNAME FROM MEMBER WHEREDEPTI D=' A' ORDEPTI D=' C' ANDYEARS=1 ORYEARS=3 Howmanyr owswi l lappeari nt her es ul ts et ?

4

5

1

2

3

Noneoft heabov e

Quest i on13 1/1pt s Cons i dert hef ol l owi ngERD:

Whati st hei dent i fi eroft heMemberent i t y ?

TCode

TCode+MI D

CI D+MI D

MI D

CI D

CI D+TCode

CI D+TCode+MI D

I ncor r ect Quest i on14 0/1pt s Cons i dert heent i t i esnamedYandXi nt hef ol l owi ngERDs :

Whi c hoft heabov eERDsbes tdes c r i best hi sRel at i onalSc hema? Y( Yi d,YName) PK( Yi d) X( Xi d,XName,Yi d) PK( Xi d) FK( Yi d)Ref er enc esY

B

C

A

D

Quest i on15 1/1pt s Cons i dert hef ol l owi ngERD:

Whati st hei dent i fi eroft heent i t yR?

RI D+WI D

RI D+WI D+KI D

Noneoft heabov e

RI D+WI D+KI D+ZI D

RI D

Quest i on16 1/1pt s Cons i dert hef ol l owi ngERD:

Whati st hei dent i fi eroft heent i t yJ?

J I D

Noneoft heabov e

J I D+KI D

J I D+KI D+XI D

J I D+KI D+XI D+SI D

I ncor r ect Quest i on17 0/1pt s Howmanyoft hef ol l owi ngs t at ement sr egar di ngERDsar et r ue ?   

2

Aweakent i t ymaybor r owpar t sofi t si dent i fi erf r om mul t i pl eweakent i t i es As t r ongent i t ymaybor r owpar tofi t si dent i fi erf r om aweakent i t y AnERDmayhav emanyweakent i t i esandz er os t r ongent i t i es

1

3

4

0

I ncor r ect Quest i on18 0/1pt s Cons i dert hi sERD:

As s umet hatanOr ac l edat abas ehasbeenc r eat edandpopul at edwi t hdat abas ed ont heabov eERD.Aquer yi sr equi r edt odi s pl ayt hePhoneManuf ac t ur erandt he Bus i nes sLocat i onas s oc i at edwi t ht hatphone. Whati st hef ewestnumberoft abl esr equi r edi naSQLquer yt ocor r ec t l ypr oduc et hi s i nf or mat i on?

3

1

2

4

Quest i on19 1/1pt s Cons i dert hi sERD:

Whati st hei dent i fi eroft heLi nkent i t y ?

PI D

PI D+Amount+Ar eaNo

Amount

Ar eaNo

PI D+Amount

PI D+Ar eaNo

Amount+Ar eaNo

Quest i on20 1/1pt s Cons i dert hi sTabl enamedMEMBERandt heSQLs t at ement : I D 1 2 3 4

MEMBER NAM DEPTI E D Jim A Alan C Emma B Karen A

YEAR S 1 1 3 3

SELECTNAME FROM MEMBER WHEREDEPTI D' B' ORDEPTI D' C' Howmanyr owswi l lappeari nt her es ul ts et ?

4

1

2

3

0...