1)Whi

choft
hef
oll
owi
ngi
sani
l
legal
symbol
fort
abl
ename

a.
$
b.
#
C.
!
D.
_
Ans:
!
2)USER_
SOURCEt
abl
eisuesdt
odi
spl
ay
a.Thepl
sql
codef
orwhi
chwehav
eex
ecut
eper
missi
on
b.
plsql
funct
iont
haty
ouown
c.
thesour
cecodef
oral
lthef
unct
ionsi
nurschema
d.Noneoft
heabov
e
Ans:
3
3)sayt
rueorf
alsei
njoi
n,ONcl
ausei
susedt
ojoi
ncol
umnt
hathav
edi
ff
erentname
a.
tr
ue
b.
fal
se
Ans:
A
4)TOO_
MANY_
ROW i
sa
a.Pr
edef
inedexcept
ion
b.Non-
predef
inedexcept
ion
c.Userdef
inedexcept
ion
d.
noneoft
heabov
e
Ans:
A
5)
PLSQLengi
nei
sresponsi
blef
or
a.St
artupofdat
abase
b.
shut
ti
ngdownofdat
abase
c.
creat
ingofdat
abaseobj
ect
d.
processi
ngofpl
sql
code
Ans:
D
6)
whi
chcommandwi
l
lmakeat
ransact
ionper
manent
a.
inser
t
b.
updat
e
c.
del
ete
d.
commi
t
Ans:
D
7)
Whi
chj
oini
susedt
otaket
heunmat
cheddat
afr
om 2t
abl
e
a.
Lef
tout
erj
oin
b.
ful
lout
erj
oin
C.
ri
ghtout
erj
oin
d.
equi
j
oin
Ans:
B
8)pr
edi
ctt
heout
put
Sel
ectr
ound(
123.
4567890)f
rom dual
;
a.
123.
456789
b.
123456789. I
f(
123.
4567890,
-
3)ansi
s0
C.
123
D.
123.
45
Ans:
C
9)
%Ty
pecanbeusedt
odecl
areav
ari
abl
ebasedon_
___v
ari
bal
e
a.
host
b.
bli
nd
c.
anot
herl
ocal
d.
global
Ans:
C
10)j
oinwi
tht
hesamet
abl
eiscal
l
ed
a.
sel
fjoi
n
b.
out
erj
oin
c.
simpl
ejoi
n
d.
none
Ans:
A
11)userdef
inedexcept
ionar
e
a.
impl
i
cit
lyr
aised
b.
expl
i
cit
lyr
aised
c.
nev
err
aised
d.
noneoft
heabov
e
ANS:
B
12)
whati
snott
rueaboutol
tp
a.
tr
ansact
ionpr
ocess
b.
ti
mesenst
ive
c.
vol
i
tal
edat
a
d.
fel
xi
ble
Ans:
D
13)Decl
ari
ngt
hecur
sor
a.
thedecl
aredcur
sori
sopendandmemor
yisal
l
oted
b.
onl
ymemor
yisal
l
oted
c.
rel
easi
ngt
hememor
y
d.
ini
ti
ali
zet
hecur
sori
ntomemor
y
Ans:
14)
whi
choft
hesei
sat
ypeofgr
ahi
cal
model
usedt
orepr
esentadat
abase
a.f
lowchar
t
b.
E-Rdi
agr
am
c.
nor
mal
i
zat
ion
d.
oragni
zat
ionmodel
Ans:
E-Rdi
agr
am
15)Bussi
nessobj
ectsuppor
twhi
cht
ypeofol
tp
a.
MOLAP
b.
DOLAP
c.
ROLAP
d.
HOLAP
Ans:
MOLAP
16)
Adhocaccesspat
hlowt
ransact
ionv
olumel
ownumberofuserar
ethechar
act
eri
sti
csof
whi
chsy
tem
a.
inf
ormat
ional
.sy
stem
b.
deci
sionsuppor
tsy
stem
c.
oper
ati
onal
syst
em
d.
tr
ansact
ional
syst
em
Ans:
D
17)mul
ti
plecol
umncannotbecompar
edb/
wout
erandi
nnerquer
y
a.
tr
ue
b.
fal
se
Ans:
A
18)v
iewi
scodeobj
ect
a.
tr
ue
b.
fal
se
Ans:
B
19)t
hei
risanagr
eegat
ert
ansf
ormerhav
ingnogr
oupbypor
tonanycol
umnf
ort
heempt
abl
e
now1000r
owsar
epassedt
hroughaggr
egat
orhowmanyr
owswi
l
lbet
heout
put
a.
fi
rstr
ow
b.
1000r
ow
c.
lastr
ow
d.
dependsont
hedept
nocol
umnv
alue
Ans:
C
20)
Int
ype2mappi
ngnewl
yaddedr
owscanbei
dent
if
iedby
1)v
ersi
onnumber
2)
fal
gval
ue
3)
eff
ect
ivedat
arange
a.
2&3
b.
1&2
c.
1&3
d.
all
.t
het
hree
Ans:
D
21)
whi
choper
tori
susedt
ochecknonequal
condt
ion
a.
=
b.
ne
c.
!=
d.
eq
Ans:
C
22)
Let
'sconsi
dert
hef
oll
owi
ngt
abl
e
T1(
eno,
name,
sal
,
doj
,
grade)
Ext
ractt
hedet
ail
from t
1,whoev
ergott
hegr
ade1i
ntot
abl
e1,
grade2i
ntot
abl
e2,
el
sei
ntot
abl
e
3whi
cht
ransf
ormat
ioni
susedf
ort
hispr
obl
em
a.
joi
ner
b.
fi
lt
er
c.
uni
on
d.
rout
er
Ans:
D
23)
whati
saddi
ti
vi
tyofmeasur
e
a.
ist
heabi
l
ityofmeasur
etobeaddedacr
ossal
lthedi
mensi
onsoft
hef
actt
abl
e
b.
ist
heabi
l
ityofmeasur
etobeaddedacr
ossal
lthef
actt
abl
e
c.
ist
omeasur
ethenumberofnumbercol
umni
nfactt
abl
e
d.
isunav
ail
abi
l
ityofmeasur
etobeaddedacr
ossal
lthedi
mensi
onsoft
hef
actt
abl
e
Ans:
A
24)
Nonequi
j
oincanbeper
for
medbywhi
cht
ransf
ormat
ion
a.
joi
ner
s
b.
fi
lt
er
c.
lookup
d.
aggr
egat
or
Ans:
C
25)
%rowcounti
susedt
o
a.
checknumberofr
owf
etched
b.
checkweat
hercur
sorhasf
ect
chedanyr
ow
c.
checkweat
hercur
sori
sopenornot
d.
all
oft
heabov
e
Ans:
D
26)whi
choft
hef
oll
owi
nghast
hecapabi
l
itest
oloaddat
aint
odi
ff
erentpl
atf
orms
a.
inf
ormat
ica
b.
dat
ast
ages
c.
abi
nit
io
d.
all
oft
heabov
e
Ans:
D
27)
Apr
ocedur
ecanbecal
l
edf
rom whi
choft
hebel
owopt
ions
a.
packagespeci
fi
cat
ion
b.
anony
mousbl
ock
c.
inser
tst
atement
d.
noneoft
heabov
e
Ans:
B
28)
whatwi
l
lresul
toff
oll
owi
ngquer
ry?
sel
ect*f
rom emp,
dept
a.
equi
j
oinr
esul
t
b.
car
ti
sti
onpr
oduct
c.
nonequi
joi
n
d.
err
orwi
l
loccur
ed
Ans:
B
29)expl
i
citcour
sori
susedf
or
a.
processi
ngonl
yoner
owi
npl
sql
b.
processi
ngmul
ti
pler
owsi
npl
sql
c.
processi
ngmul
ti
plecol
umnsi
npl
sql
d.
noneoft
heabov
e
Ans:
B
30)wecanusesubqui
esi
nDMLst
atement
s
a.
tr
ue
b.
fal
se
Ans:
A
31)
whi
chsect
ionsofpl
sql
blockwoul
dmostl
i
kel
ycont
ainar
aisest
atement
a.
execut
abl
e
b.
except
ion
c.
execut
abl
eandexcept
ion
d.
noneoft
heabov
e
Ans:
A
32)
val
i
ddel
i
mit
ersi
nOr
acl
ear
e
a.
;
(semi
col
on)and,
(comma)
b.
'
(col
on)
and,
(comma)
c.
;
(semi
col
on)and'
(col
on)
d.Noneoft
heabov
e
Ans:
A
33)
Afunct
ionbynamecal
cul
ate_
5per
cent
_incr
ementhasbeencr
eat
edi
ndat
abase.Pl
ease
checki
fthef
oll
owi
ngst
atementi
scor
rect
.
a.
Canext
endSQLwher
eact
ivi
ti
esar
etoocompl
ex,
tooawkwar
d,orunav
ail
abl
ewi
thSQL
b.
Cani
ncr
easeef
fi
ciencywhenusedi
ntheWHEREcl
auset
ofi
l
terdat
a,asopposedt
ofi
l
ter
ing
t
hedat
aint
heappl
i
cat
ion
c.
Canmani
pul
atedat
aval
ues
d.
All
oft
heabov
e
Ans:
D
34)
Predi
ctt
heout
put
Sel
ectt
runc(
987654-
3)f
rom dual
a.
0
b.
100
c987
d.
1000
Ans:
A
35)
MOLAPabr
ivat
ioni
s
a.
Mul
tiOLAP
b.
Mul
ti
dimensi
onal
OLAP
c.
Mut
ual
OLAP
d.
Mast
erOLAP
Ans:
B
36)
Topr
ovi
det
heuseoft
heI
F-THEN-
ELSEl
ogi
cwi
thi
naSQLst
atementwhi
char
ethet
woway
s
a.
Caseanddecode
b.
Caseandnul
l
if
c.
Decodeandnul
l
if
dCaseandcoal
esce
Ans:
A
37)
Oracl
edoesnotal
l
owv
iewi
ngof
___
_packagecode
a.
Userdef
ined
b.
Bui
l
t-i
n
c.
Remot
e
d.
Noneoft
heabov
e
Ans:
B
38)
Todr
opunusedcol
umns
a.
Alt
ert
abl
eempdr
opunusedcol
umns
b.
Alt
ert
abl
eempdr
opcol
umns
c.
Alt
ert
abl
eempdr
opal
l
aunusedcol
umns
d.
None
Ans:
A
39)
%isopen_
___
a.
Eval
uat
esofTRUEi
fcur
sori
sopen
b.
Eval
uat
est
oTRUEi
fthemostr
ecentf
etchdoesnotr
etur
nar
ow
c.
Eval
uat
est
othet
otal
numberofr
owr
etur
nedsof
ar
d.
Eval
uat
est
oTUREi
fthemostr
ecentf
etchr
etur
nsar
ow
Ans:
A
40)
InPLSQLbl
ocks,
sect
iont
hatst
art
swi
tht
hebegi
nkey
wor
disr
eff
erdas_
__
a.
Decl
arat
ionsect
ion
b.
Except
ionhandl
i
ngsect
ion
c.
Execut
abl
esect
ion
d.
Ter
minat
ionsect
ion
Ans:
C
41)
Scal
arv
ari
abl
ehol
ds_
___
a.
Singl
eval
ue
b.
Mul
ti
plev
alues
c.
Nov
alues
d.
Mor
ethanonev
alue
Ans:
A
42)
Whi
chr
epr
esent
sasetofr
eusabl
etr
ansf
ormat
ion?
aMappi
ng
b.
Mappl
et
c.
Wor
kfl
ow
d.
Wor
klet
Ans:
B
43)
Rear
rangi
ngt
hegr
oupofsour
cedat
a,del
i
ver
ingi
ttot
hedest
inat
iondat
abase,
andensur
ing
t
hequal
i
tyofdat
aar
ecr
uci
alt
othepr
ocessofl
oadi
ngt
hedat
awar
ehouse.
Dat
a__
__i
svi
tal
l
y
i
mpor
tantt
otheov
eral
lheal
thofawar
ehousepr
oject
a.
Cleansi
ng
b.
Cleani
ng
c.
Scr
ubbi
ng
d.
Dat
atr
ansmi
ssi
on
Ans:
B
44)
Whi
chj
oincl
ausei
susedt
ojoi
ntwot
abl
eswhen1col
umnnamei
scommoni
nbot
htabl
es?
a.
Crossj
oin
b.
Nat
ural
joi
n
c.
Nonegui
j
oin
d.
Sel
fjoi
n
Ans:
B
45)
___
__i
sasetofi
nst
ruct
ionst
hatdescr
ibeshowandwhent
omov
edat
afor
m sour
cest
o
t
arget
s.
aWor
kfl
owmanager
b.
Wor
ker
c.
Sessi
on
d.
Map
Ans:
C
46)
Whi
cht
ransf
ormat
ionact
sli
keaWHEREcondi
ti
on?
a.
uni
on
b.
Joi
ner
c.
Fil
ter
d.
Expr
essi
on
Ans:
C
47)
Ter
m degr
eei
nRDBMSi
ndi
cat
es
a.
Thenoofat
tri
but
esi
nat
abl
e
b.
Thenoofr
owsi
nat
abl
e
c.
Acol
umni
nat
abl
e
d.
Arowi
nat
abl
e
Ans:
A
48)
Whi
char
ethef
oll
owi
ngi
samustt
ousei
ntheDMLst
atement
swhi
l
eusi
ngf
orupdat
eofi
n
t
hecur
sordecl
arat
ion?
a.
Lockedr
ows
b.
Wher
ecur
rentof
c.
Wher
elockof
d.
Wher
ecur
sorof
Ans:
B
49)
Adat
apar
tsi
nthedat
abaseshoul
dber
epr
esent
edi
noneandonl
yoneway
-asv
aluesi
na
t
abl
e
a.
Foundat
ionr
ule
b.
Inf
ormat
ionr
ule
c.
Compr
ehensi
vesubl
anguager
ule
d.
Logi
cal
dat
aindependencer
ule
Ans:
B
50)
Consi
dert
hef
oll
owi
ngst
atementCr
eat
etabl
enew_
tab(
I'
dnum const
rai
ntpk_
idpr
imar
ykey
,
namechar
(20)
;Nowt
hepr
imar
ykeyconst
rai
nti
scr
eat
edat_
___
__l
evel
a.
Tabl
e
bCol
umn
c.
Bot
haandb
d.
Nei
theranorb
Ans:
B
51)
Acasest
atementi
s__
__
a.
Simi
l
art
obadcl
oop
b.
Simi
l
art
onest
edi
f
c.
Notsuppor
tedi
nPLSQL
d.
Notsuppor
tedi
nSQL
Ans:
B
52)
Predef
inedandnon-
predef
inedexcept
ionsar
e?
a.
Impl
i
cit
lyr
aised
b.
Expl
i
cit
lyr
aised
c.
Can'
tber
aised
d.
Noneoft
heabov
e
Ans:
A
53)
Publ
i
cconst
ruct
scan_
__
a.
Notbecal
l
edf
rom anot
herpr
obl
ems
b.
Canbedi
rect
lycal
l
edf
rom ot
herpr
ogr
amsusi
ngnameofpr
ocedur
e
c.
Canbedi
rect
lycal
l
edf
rom ot
herpr
ogr
amsusi
ngpackagename
d.
Noneoft
heabov
e
Ans:
B
54)
___
isacol
l
ect
ionofl
ogi
cal
rel
ateddat
aatonepl
ace
a.
Dat
abase
b.
Dat
a
c.
Dat
amanagementsy
stem
d.
Comput
erbasedi
nfor
mat
ionsy
stem
Ans:
A
55)Whi
cht
ransf
ormat
ioncannotchanget
henumberofr
owst
hatpasst
hroughi
t?
a.
Act
ive
b.
Passi
ve
c.
Bot
haandb
d.
Nei
theranorb
Ans:
B
56)
Inst
oredf
unct
ionswhatar
ethedef
aul
tmodeofpar
amet
er?
a.
Out
in
b.
Lout
c.
Oin
d.
Noneoft
heabov
e
Ans:
D.(I
Niscor
rectans)
57)
Nor
mal
i
sat
ioni
sapr
ocessofr
est
ruct
uri
ngadat
abaset
o
a.
Mini
mizedupl
i
cat
iondat
ainadat
abase
b.
Mini
mizedupl
i
cat
ionofdat
a
c.
Makei
tofuni
for
m si
ze
d.
All
owaddi
ti
onofdat
a
Ans:
A
58)
Asequencei
scr
eat
edl
i
ket
his.CREATEsequences1st
artwi
th1i
ncr
ementby1Maxv
alue
10Mi
nval
ue5CACHE.Whatwi
l
lbet
heout
puti
fwegi
vet
hef
oll
owi
ngquer
ry?SELECTS1
CURRVALFROM DUAL
a.
1
b.
2
3.
5
4.
Err
orwi
l
loccur
ed.
Bef
orest
art
ingt
hesequence.
wecannotf
indCURRVAL
Ans:
D
59)
Asi
ngl
eli
necommenti
spr
efi
xedwi
th_
__
a.
Thr
eehy
phens(
---
)
b.
Twohy
phens(
--
)
c.
/*/
*
d.Al
loft
heabov
e
Ans:
B
60)
___
_isasetosi
nst
ruct
ionst
hatdescr
ibeshowandwhent
omov
edat
afr
om sour
cet
otar
get
a.
Wor
kfl
owmanager
b.
Wor
klet
c.
Sessi
on
d.
Map
Ans:
C
61)
Predi
ctt
heout
put
Sel
ectr
ound(
1234567890)
from dual
a.
123456789
b.
123456789
c.
123
d.
12345
Ans:
C
62)
Indexsmustbecr
eat
edmanual
l
yal
way
s
a.
True
b.
Fal
se
Ans:
B
63)TheusercanRol
l
backcommi
tt
edt
ransact
ion
a.
True
b.
Fal
se
Ans:
B
64)
Whi
choft
hef
oll
owi
ngsel
ectst
atementwi
l
lexecut
ewi
thouter
ror
s
a.
Sel
ectal
lfr
om emp
b.
Sel
ectename,
sal
from emp
C.
Sel
ect*
,sal
*12asAnnual
Sal
from emp
d.
Sel
ectj
ob,
dist
inctdept
nof
rom emp
Ans:
B
65)
PLsql
ext
endt
heSQLpr
ogr
ammi
ngl
anguageby
___
_
a.
Addi
ngpr
ocedur
alconst
ruct
s
b.
Addi
ngi
ter
ati
vecont
rol
c.
Addi
ngcondi
ti
onal
cont
rol
d.
All
oft
heabov
e
Ans:
D
66)
Whati
sthenameofScal
adev
eloper
a.
Mor
ti
nor
eder
sky
b.
JhonTi
m
c.
Gingosol
i
n
d.
Hidenhi
tt
er
Ans:
A
67)
Whati
stheout
putoft
hef
oll
owi
ngf
unct
ionadd_
mont
hs(
'31_
jan_
12'
,
1)
a.01-
feb-
12
b.
31-
feb-12
c.
40968
d.
31-
jan-
12
Ans:
B
68)
Anony
msbl
ocksar
e?
a.
Unnamedbl
ock
b.
Namedbl
ock
c.
Dat
abaseobj
ect
s
d.
Noneoft
heabov
e
Ans:
A
69)
PL/
SQLr
aisesanexcept
ion_
__
a.
WhenaSELECTst
atmentr
etur
nsnor
ows
b.
WhenaSELECTst
atementr
etur
nsexact
lyoner
ow
c.
Whent
hedat
aty
pesofSELECTcl
auseandI
NTOcl
ause
d.
Noneoft
heabov
e
Ans:
c
70)
Tabl
escannothav
ethesamenameunderagi
venuser
a.
True
b.
Fal
se
Ans:
A
71)
Whi
chSQLst
atementi
susedt
oex
tractdat
afr
om adat
abase?
a.
Ext
ract
b.
Sel
ect
c.
Get
d.Open
Ans:
B
72)
Rel
ati
onal
cal
cul
atscomesi
ntwof
lav
our
ssel
ctt
hecor
rectpai
r
a.
tupl
erel
ati
oncal
cusl
us.
domi
nrel
ati
onal
cal
cul
us
b.
Tupl
erel
ati
oncal
cusl
us.
dat
arel
ati
onal
cal
cul
us
c.t
abl
erel
ti
oncal
cul
us.
domi
nrel
ati
onal
cal
cul
us
d.
Tabl
ereal
ti
oncal
cusl
us.
dat
arel
ati
onal
cal
cusl
us
Ans:
A
73)
Accor
dingt
he4t
hnor
mal
for
mal
whi
chi
str
ue
a.
Ther
eshoul
dbeapr
imar
ykeyi
nar
elat
ion
b.
Ther
eshoul
dnotbeanyt
ranset
ivedepency
c.Ther
eshoul
dnotbepar
ti
aldepency
d.I
tst
atest
hatt
her
eshoul
dnotbeanymul
tiv
alueddepencyi
nar
elat
ion
Ans:
D
74)
User
-def
inedexcept
ionsar
e__
__
a.I
mpl
i
cit
lyr
aised
b.
Expl
i
cit
lyr
aised
c.
Nev
err
aised
d.
Noneoft
heabov
e
Ans:
B
75)I
naPLSQLbl
ock,
var
iabl
eval
uescanbepr
int
edusi
ng_
___
a.Pr
int
b.
Dbms_
out
put
.put
_li
ne
c.
Bot
haandb
d.
Noneoft
heabov
e
Ans:
B
76)
Whati
sthedi
ff
erencebet
weenadat
awar
ehouseordat
amar
tandanoper
ati
onal
dat
a
st
ore?
a.
Anoper
ati
onal
dat
ast
orecont
ainsmor
ecur
rentdat
athanei
theradat
awar
ehouseoradat
a
mar
t
b.
Anoper
ati
onal
dat
ast
oreandadat
awar
ehouseordat
amar
ttr
ackdi
ff
erentsubj
ectar
easi
n
t
heor
gani
zat
ion
c.
Anoper
ati
onal
dat
ast
orei
sacopyoft
hedat
awar
ehouseordat
amar
t
dTheOper
ati
onal
dat
ast
oret
endst
obel
argert
hant
hedat
awar
ehouseordat
amar
t
Ans:
A
77)Whi
chi
snonpl
/sql
var
iabl
e?
a.
LOB
b.
Ref
erence
c.
Host
d.
Scal
ar
Ans:
C
78)
Whati
sthedef
aul
tdi
spl
ayf
ormatf
ort
heDATedat
aty
peofcol
umn?
a.
DD-
MM-
YY
b.
DD-
MM-
RR
c.
DD-
MON-
RR
d.
DD-
MON-
YYYY
Ans:
A
79)
Int
hef
oll
owi
ngquer
ry
Sel
ectempno,
ename,
sal
,
depno
Fr
om empl
oyee
Wher
esal
=1000orsal
=2500orsal
=4000
Whi
chot
heroper
atorcanr
epl
acet
heORcondi
ti
on?
a.Bet
ween_
and
b.
In
c.
Like
d.
And
Ans:
B
80)
InE-
Rmodel
att
ri
but
esar
erepr
esent
edby
a.
Cir
cles
b.
Rect
angul
ar
c.
Diamond
d.
Oval
Ans:
D
81)
Whi
cht
ypeofcol
l
ect
ionswhi
chmaynotconsumememor
yunt
ilt
heyar
eaccessed
a.
Lazycol
l
ect
ion
b.
Mut
abl
ecol
l
ect
ion
c.
Immut
abl
eCol
l
ect
ion
d.
Str
ictcol
l
ect
ion
Ans:
A
82)
Whi
choft
hef
oll
owi
ngquer
ryi
sinv
ali
d
a.
Sel
ectdept
noDNOav
g(sal
)fr
om sampl
egr
oupbydept
noor
derbyav
g(sal
)
b.
Sel
ectdept
noDNO,
avg(
sal
)fr
om sampl
egr
oupbydept
noor
derbyDNO
c.
Sel
ectdept
noDNO,
avg(
sal
)f
rom sampl
egr
oupbyDNOor
derbydept
no
d.
Sel
ectdept
noDNO.
avg(
sal
)f
rom sampl
egr
oupf
rom dept
noor
derbydept
no
Ans:
B
83)
Var
iabl
ev_
tax_
rat
ehasbeendecl
aredi
nthepackagespeci
fi
caat
ionasnumber
(4,
2)whi
chof
t
hef
oll
owi
ngabouti
nit
ial
i
zat
ioni
str
ue?
a.v
_tax_
rat
ehasnotbei
nit
ial
i
zed
b.
V_t
ax_
rat
ewoul
dbei
nit
ial
i
zednul
l
c.V_
tax_
rat
ehasbeeni
nit
ial
i
zed0
d.
Noneoft
heabov
e
Ans:
2
84)
PLSQLl
ocal
var
iabl
ear
eusedf
or_
__
a.
Tempor
aryst
orageofdat
a
b.
Passv
aluef
rom onepr
ogr
am t
oanot
her
c.
Readonl
ypur
pose
d.
All
oft
heabov
e
Ans:
A
85)
Whati
sther
oleofpar
ti
ti
oneri
nmapr
educej
ob
a.
Maki
ngr
educeout
puti
ntoequal
par
ti
ti
ons
b.
Whenmapout
putexceedst
hel
i
mit
,cr
eat
eanewone
c.mapout
putkey
stor
educer
s
d.Noneoft
heabov
e
Ans:
C
86)
Whi
choft
hef
oll
owi
ngst
atementi
sfal
ser
egar
dingf
il
emanagementsy
stem
a.
Dat
aissepar
atedf
orev
eryi
ndi
vi
dual
progr
am
b.
Dat
acanbedupl
i
cat
ed
c.
Nouni
for
mlycanbef
oundi
nthedat
a
d.
Secur
it
iesatdi
ff
erentl
evel
canbemai
ntai
ned
Ans:
87)Def
aul
tval
uescanbeassi
gnedonl
yforpar
amet
ershav
ing_
___
mode
a.
In
b.
Out
c.
Inout
d.
Noneoft
heabov
e
Ans:
A
88)Dur
ingETLpr
ocessofanor
gani
zat
ion,
supposey
ouhav
edat
awhi
chcanbet
ransf
ormed
usi
nganyoft
het
ransf
ormat
ionmet
hod.
whi
choft
hef
oll
owi
ngst
rat
egywi
l
lbey
ourchoi
cef
or
l
eastcompl
exi
ty
1.
one-
to-
onescal
ert
ransf
ormat
ion
2.
one-
to-
manyel
ementt
ransf
ormat
ion
3.
many
-to-
manyel
ementt
ransf
ormat
ion
4.
many
-to-
oneel
ementt
ransf
ormat
ion
Ans:
A
89)
Predi
ctt
heout
putoff
oll
owi
ngquer
ry
Sel
ect'
hel
l
o'|
|
'wor
ld'
from emp
a.
Displ
ayHel
l
oWor
ldexact
lyonceasnocol
umnnamesar
esel
ect
ed
b.
Displ
aynt
imesHel
l
oWor
ldwhenni
sthenoofr
owsi
ntheempt
abl
e
c.
Displ
ayser
rornocol
umnf
ound
d.
Displ
aysnoout
put
Ans:
B
90)
___i
sacol
l
ect
ionofobj
ect
sunderauser
a.
Tabl
e
b.
Schema
c.
Col
umn
d.
Transact
ion
Ans:
B
91)Whi
choft
hesest
atement
sar
etr
uer
egar
dingSQLf
unct
ions
St
atementA:
SQLf
unct
ionssomet
imest
akear
gument
sandal
way
sret
urnav
alue
St
atementB:
SQLf
unct
ionscannotbeusedt
oconv
ertcol
umndat
aty
pes
a.
Bot
hAandBar
etr
ue
b.
Bot
hAandBf
alse
c.
Aist
rueBi
sfal
se
d.
Aisf
alseBi
str
ue
Ans:
A
92)
Whi
chst
atementi
scor
rect
?
a.
Procedur
emayormaynotr
etur
nav
alue
b.
Procedur
emustr
etur
nasi
ngl
eval
ue
c.Pr
ocedur
emustr
etur
na2v
alue
d.
Noneoft
heabov
e
Ans:
D
93)
Combi
neri
s
a.
Likea'
mini
-Reducer
'
b.Runsl
ocal
l
yonasi
ngl
eMapper
'sout
put
c.
Out
putf
rom t
hecombi
neri
ssentt
other
educer
s
d.
All
oft
heabov
e
Ans:
D
94)Cur
sorFORl
oopi
susedt
o__
_
a.
Impl
i
cit
lyopen,
fet
ch,
exi
tandcl
ose
b.
Expl
i
cit
lyopen,
fet
ch,
exi
tandcl
ose
c.Al
l
ocat
ememor
yonl
y
d.oft
heabov
e
Ans:
A
95)
Whi
chcl
ausecanbeusedt
ofi
l
terr
owsf
rom at
abl
einaHQL
a.
Groupby
b.
Orderby
c.
Wher
e
d.
Hav
ing
Ans:
C
96)
Out
putofr
educer
iswr
it
tent
o
a.
Tempdi
rect
ory
b.
HDFS
c.
Local
disk
d.
Noneoft
heabov
e
Ans:
B
97)
Whi
chj
oinhasacondi
ti
onot
hert
hant
heequal
i
ty.
oper
ator
?
a.
Nat
ural
joi
n
b.Equi
joi
n
c.
Sel
fjoi
n
d.
Nonequi
j
oin
Ans:
D
98:
TheOr
acl
eser
ver
___
_opensacur
sort
opr
ocesseachSQLst
atementt
hati
snotassoci
ated
wi
than_
__decl
aredcur
sor
?
a.
Expl
i
cit
ly,
impl
i
cit
ly
b.
Impl
i
cit
ly,
expl
i
cit
ly
c.
Impl
i
cit
ly,
impl
i
cit
ly
d.
Expl
i
cit
ly,
expl
i
cit
ly
Ans:
B
99)
Whenwear
ewr
it
ingascal
apr
ogr
am weal
way
sst
artwi
thobj
ecti
nst
eadusi
ngacl
ass
unl
i
kej
avawhati
sthatt
ypeofobj
ecti
s
a.
def
inesobj
ect
b.
Descr
ibedobj
ect
c.Si
ngl
etonobj
ect
dSi
ngl
enot
eobj
ect
Ans:
C
100:
HIVEi
sNOTdesi
gnedf
or
a.
OLPT
b.
Lowl
atencyappl
i
cat
ion
c.Userf
aci
ngi
nter
act
iveappl
i
cat
ion
d.
All
oft
heabov
e
Ans:
A
101)
TheANSIst
andar
dlanguagef
oroper
ati
ngr
elat
ional
dat
abases
a.
Str
uct
ural
quer
ryl
anguage
b.
Standar
dquer
ryl
anguage
c.
Str
ongquer
ryl
anguage
d.
Standar
diz
edquer
ryl
anguage
Ans:
A
102)
Whati
snott
ureaboutdat
amar
t
a.Pr
ojector
ient
ed
b.
Dat
aor
ient
ed
c.
Shor
tli
fe
d.Nonext
ensi
ble
Ans:
B
103)Whi
choper
aterwi
l
lnotacceptmor
ethanonev
aluef
rom t
hesubquer
ry
Ans:
equal
to
104)
Howt
oref
erbi
ndv
ari
abl
ewi
thi
naPLSQLbl
ock
Ans: :
104I
nmodei
s?
a.Def
aul
tmode
b.
Val
uei
spausedi
ntosubpr
ogr
am
c.
Acct
ual
par
amet
ercanbeal
i
ter
al,
expr
essi
on,
const
antor
d.
All
oft
heabov
e
Ans:
D
105)
Whi
choft
hef
oll
owi
nghast
hecapabi
l
iti
est
oloaddat
aint
odi
ff
erentpl
atf
orm
Ans:
All
oft
heabov
e
106)Thecommandusedt
oADDcol
umn
a.
Alt
ert
abl
eempadd(
addr
essv
archar2(
20)
)
b.
Alt
ert
abl
eempaddcol
umnaddr
ess
cAl
tert
abl
eempaddaddr
essv
archar2
d.
None
Ans:
A
107)
Thesl
owel
ychangi
ngdi
mensi
ont
ypeIwecanf
indt
hehi
stor
ical
dat
aandor
gani
sat
ional
changes
a.
True
b.
Fal
se
Ans:
B
108)
Acct
ual
par
amet
erar
e__
__
a.
Local
var
iabl
esdecl
aredi
nthepar
amet
erl
i
stofasubpr
ogr
am speci
fi
cat
ion
b.
Lit
eral
val
ues,
var
iabl
esusedi
nthepar
amet
erl
i
stoft
hecal
l
ingpr
ogr
am
c.Gl
obal
var
iabl
es
d.
Noneoft
heabov
e
Ans:
B
109)
Whati
sthecommanduset
orenamet
abl
einHI
VE
a.
Alt
ert
abl
elog_
messageRENAMEl
og_
msg(
toi
smi
ssi
ng)
b.
Alt
ert
abl
eRENAMEl
og_
mesaagel
og_
msg
c.Al
tert
abl
elog_
messageRENAMEWI
THl
og_
msg
d.
ALTERTABLERENAMEl
og_
messageWI
THl
og_
msg
Ans:
A
110)
Whi
chcommandI
'
dusedt
oconnectHI
VEcommandl
i
nei
nter
face?
a.
hiv
e
b.
Hiv
eshel
l
cHi
vecmd
d.
Apachehi
ve
Ans:
A
111)
Cor
rectsy
ntaxf
orcr
eat
ingpr
ocedur
e__
_
a.Cr
eat
eorr
epl
acepr
ocedur
epr
ocedur
ename(
par
amet
erl
i
st.
..)
Local
var
iabl
edecl
arat
ionsi
s
Begi
n
Execut
abl
est
atement
s
End
b.
Creat
eorr
epl
acepr
ocedur
epr
ocedur
ename(
par
amet
erl
i
st.
..
.)
I
s
Local
var
iabl
edecl
arat
ions
Begi
n
Execut
abl
est
atement
s
Except
io
Except
ionhandl
ers
End
c.
Creat
eorr
epl
acepr
ocedur
epr
ocedur
ename
Local
var
iabl
edecl
arat
ions
I
s
Execut
abl
est
atement
s
Except
ion
Ans:
B
112)
Whi
choft
hef
oll
owi
ngst
atementi
scor
rectaboutdat
awar
ehouse
a.
Adat
awar
ehousei
snonsubj
ector
ient
ed,
int
egr
ated,
non-
vol
ati
l
e,t
imev
ari
entcol
l
ect
ionof
dat
a
b.
Adat
awar
ehousei
ssubj
ector
ient
ed,
noni
ntegr
ated,
non-
vol
ati
l
e,t
imev
ari
entcol
l
ect
ionof
dat
a
c.
Adat
awar
ehousei
ssubj
ector
ient
ed,
int
egr
ated,
non-
vol
ati
l
e,t
imev
ari
entcol
l
ect
ionof
dat
a
dAdat
awar
ehousei
snonsubj
ector
ient
ed,
int
egr
ated,
vol
ati
l
e,t
imev
ari
entcol
l
ect
ionof
dat
a
Ans:
C
113)
Acasest
atementi
s
a.
simi
l
art
obasi
cloop
b.
simi
l
art
onest
edi
f
c.
notsuppor
tedi
npl
sql
d.
notsuppor
tedi
nSQL
Ans:
B
114)
Whywi
l
lthef
oll
owi
ngquer
yresul
tinaner
ror
SELECTDEPARTMENT_
ID,
SUM(
SALARY)f
rom empl
oyeewher
elastname_
li
ke'
A'
%hav
ing
sum(
sal
ary
)>10000
a.
hav
ingcl
ausecannotcont
ainagr
oupf
unct
ion
b.
Thegr
oupbycl
ausei
smi
ssi
ng
c.
thei
risnoer
rori
nthest
atement
d.
hav
ingcl
auseshoul
dcomebef
orewher
ecl
ause
Ans:
B
115)
InOr
acl
ethedef
aul
tcat
chef
orsequencei
s
a.
5
b.
10
c.
15
d.
20
Ans:
D
116)
Usageofpl
sql
blockr
educes_
___
andi
ncr
ease_
___
_
a.
net
wor
ktr
aff
ic,
accur
acy
b.
net
wor
ktr
aff
ic,
per
for
mance
c.
accur
acy
d.
stor
agespace
Ans:
B
117)
Whati
sthemostcommonuseofamul
ti
dimensi
onal
dat
abase(
MDDB)
a.
axcesspr
e-det
ermi
nedaggr
egat
edat
aacr
osssev
eral
dimensi
ons
b.
acesshugedat
awar
ehouses
c.
acessappl
i
cat
ionpackages
d.
Ast
heonl
yty
peofdat
abasemanagementsy
stem usedf
oradat
awar
ehouses
Ans:
B
118)Themaxi
mum numberofsubquer
ylev
elusedi
nFROM cl
ausei
s
a.
1
b.
32
c.
255
d.
unl
i
mit
ed
Ans:
D
119)
Whati
sthepur
poseofshuf
fl
einHadoopmapr
educe
a.
Tor
andoml
ydi
str
ibut
emapperout
putAmongr
educernodes
b.
Topr
e-sor
tthedat
abef
oreent
erseachmapnode
c.
Todi
str
ibut
einputspl
i
tsamongmapper
snodes
d.
Tot
ransf
ereachmapperout
putt
otheoppr
ori
ater
educernodebasedonaper
manent
f
unct
ion
Ans:
D
120)
Whatdoy
oumeanbyr
ecur
siv
erel
ati
onshi
p
a.
Arel
ati
onshi
pty
peent
it
yref
ert
oeachot
her
b.
Arel
ati
onshi
pty
pewher
eanent
it
yty
pepar
ti
cipat
emor
ethanoncei
ndi
ff
erentr
oles
c.
Arel
ati
onshi
pty
pewher
eanent
it
yty
pepar
ti
cipat
emor
ethanoncei
ndi
ff
erentent
it
y
d.
Arel
ati
onshi
pty
pewher
eanat
tri
but
ety
pepar
ti
cipat
emor
ethanoncei
ndi
ff
erent
Ans:
C
121)Packagespeci
fi
cat
ionconat
ins
a.
procedur
ecode
b.
funct
ioncode
c.
decl
arat
ionofpr
ocedur
e,f
unct
ion,
var
iabl
es
d.
onl
yvar
iabl
es
Ans:
3
122)
Topr
ovi
det
heuseoft
hei
f-
then-
logi
cwi
thi
naSQLst
atementwhi
chf
unct
ioni
sused
a.
tr
im
b.
decode
c.
coal
esce
d.
nul
l
if
Ans:
B
123)
Whi
choft
hebel
owopt
ioni
sav
ali
dcur
sorat
tri
but
e
a.
SQL%open
b.
SQL%count
c.
%found
d.
SQL%not
found
Ans:
C
124)
Desi
gnerwhi
chi
susedt
ocr
eat
ereusabl
eobj
ect
sthatr
epr
esent
sasetoft
ransf
ormat
ion
a.
mappi
ngdesi
gner
b.
mapl
etdesi
gner
c.
tar
getdesi
gner
d.
reuser
abl
edesi
gner
Ans:
B
125)
whatt
ypeofol
apdoest
hemi
crosof
tanal
ysi
sser
vicesandcongnossuppor
ts
a.
mol
ap
b.
dol
ap
c.
rol
ap
d.
hol
ap
Ans:
A
126)Br
ingt
oget
herdat
athati
sst
oredi
ndi
ff
erentt
abl
esbyspeci
fyi
ngl
i
nkB/
wthem
asel
ect
ion
bpr
oject
ion
c.
joi
n
d.
uni
on
AnsC
127)
Whi
choft
hebel
owst
atementi
sassoci
atedwi
thcur
sor
?
*
Sel
ect
*
Inser
t
*
Del
ete
*
Updat
e
Ans:
A
128)
Wewantt
oext
ractdat
afr
om empl
oyeesf
rom HRschemaanddept
abl
efr
om SCOTT
schemawhatpossi
blet
ransf
ormat
ion(
s)f
ort
his?
*
Sour
cequal
i
fier
*
Joi
ner
*
Bot
haandb
*
Nei
theranotb
Ans:
C
129)
Opencur
sori
susedt
o?
*
Ident
if
ytheact
iveset
*
Loadt
hecur
rentr
owi
ntov
ari
abl
es
*
Rel
easet
heact
iveset
*
Creat
eanamedSQL.
area
Ans:
A
130)
Whi
choft
hebel
owst
atement
saboutpackagespeci
fi
caat
ionandbosui
snott
rue?
*
Packagespeci
fi
caat
ioni
smandat
oryf
orcr
eat
ingpackagebody
*Packagebodyi
snotmandat
ory
*
Packagescanhav
eanynumberofpr
ivat
eandpubl
i
ccomponent
s
*
Onepackagespeci
fi
caat
ioncancer
tai
nanynumberofpackagebody
Ans:
B
131)
Packagescanbe_
___
*
Usedonl
yonce
*
Reused
*
Needspeci
alsy
ntaxi
fitneedt
obeused
*
Noneoft
heabov
e
Ans:
B
132)
Ofst
arschemaDesi
gni
stosi
mpl
i
fy_
___
_
*
Logi
cal
dat
amodel
*
Phy
sical
dat
amodel
*
Concept
ual
dat
amodel
*
Noneoft
hese
Ans:
B
133)
InETLact
ivi
ti
esdat
aext
ract
ionact
ivi
tyi
sto
*
Transpor
tst
hedat
aov
eront
oanot
herf
il
eordat
abase
*
Renor
mal
i
zeddat
a
*
Ini
ti
alandi
ncr
ement
all
oadi
ng
*
Dat
aint
egr
it
ycheck
Ans:
A
134)Outmodepar
amet
ers
*
Canpassv
aluet
othesubpr
ogr
am,
ret
urnv
aluet
ocal
l
ingenv
ironment
*
canbeani
nit
ial
i
zedv
ari
abl
e
*
Cannotbeassi
gnedadef
aul
tval
ue
*
All
oft
heabov
e
Ans:
A
135)
Predi
ctt
heout
put
Sel
ectROUND(
1234567890,
-
3)f
rom dual
*
0
*
100
*
123
*
1000
Ans:
A
136)
InETLact
ivi
ti
esdat
atr
ansf
ormat
ionact
ivi
tyi
sto
a.
Ident
if
yqual
i
fieddat
a
bSummar
izi
ngdat
a
C.
dat
aint
egr
it
ycheck
d.
updat
ionofmet
adat
a
Ans:
B
137)
Whi
choft
hef
oll
owi
ngi
sar
eresponsi
blef
orr
eleasi
ngt
hel
ocks?
(
I)
COMMi
T(i
i
)ROLLBACK
*
(I)onl
y
*
(ii
)onl
y
*
bot
h(I
)and(
ii
)
*
Niet
her(
I)nor
(i
i)
Ans:
C
138)Decl
ari
ngt
hecur
sor
*
Thedecl
aredcur
sori
sopendandmemor
y
*
Onl
ymemor
yisal
l
ott
ed
*
Rel
easi
ngt
hememor
y
*
Ini
ti
ali
zest
hecur
sori
ntomemor
y
Ans:
A
139)
Whenwedr
oppedat
abl
e,sequenceal
sodr
opped
*
True
*
Fal
se
Ans:
B
140)
InETLact
ivi
ti
esdat
aext
ract
ioncl
eanupact
ivi
tyi
sto
*
Ident
if
yqual
i
fieddat
a
*
Summar
izi
ngdat
a
*
Suppl
yi
ngofmi
ssi
ngf
iel
dval
ues
*
Updat
ionofmet
adat
a
Ans:
A
141)Cur
sorv
ari
abl
eisusedt
o
*Passquer
ryr
esul
tsset
sbet
ween.PLSQLst
oredsubpr
ogr
am andv
ari
ouscl
i
ent
s
*
Shar
eapoi
ntert
othequer
rywor
kar
eai
nwhi
cht
her
esul
tseti
sst
ored
*
Passt
hev
alueofacur
sorv
ari
abl
efr
eel
yfr
om onescopet
oanot
her
*Al
loft
heabov
e
Ans:
D
142)
Whi
choft
hef
oll
owi
ngmustbeaf
unct
ionofadat
aext
ract
ionandt
ransf
ormat
iont
ool
?
*
Abi
l
ityt
oret
ri
evedat
afr
om al
lknowndat
abasemanagementsy
stem
*
Abi
l
ityt
ost
oret
hedat
amar
tdat
abasedesi
gnsandmaket
hosedesi
gnsav
ail
abl
etot
he
bussi
nessanal
ysi
s
*Abi
l
ityt
otr
ansl
atedat
ael
ement
sint
hesour
cesy
stem i
ntodat
awar
ehousedat
a
*
Abi
l
ityt
orunonal
lknownpl
atf
orm andoper
ati
ngsy
stem
Ans:
3
143)
Wht
aer
rorwi
l
loccuri
fthesei
sani
nconsi
stencybet
weent
hesour
ce
qual
i
fierandt
hesour
cet
abl
e?
*
Unboundf
iel
dinsour
cequal
i
fier
*
Nodat
afound
*
Dat
aty
pemi
smat
ch
*
Twomanyr
ows
Ans:
A
144)I
nbui
l
dingawar
ehouse60-
80%ofwor
kisr
equi
redi
nwhi
chst
age
*
Dat
abasedesi
gns
*
ETLdepl
oyment
*
OLAPdepl
oyment
*
Cleani
ng
Ans:
B
145)
Whi
choft
hef
oll
owi
ngi
str
ueaboutuni
ont
ransf
ormat
ion
*
Theuni
ont
ransf
ormat
ioni
sanpassi
vet
ransf
ormat
ion
*
Theuni
ont
ransf
ormat
ionr
emov
esdupl
i
cat
erows
*
Uni
ont
ransf
ormat
ioni
ssi
mil
art
ouni
onal
l
aSQLst
atement
*
All
inputgr
oupsandt
heout
putgr
oupneednohav
emat
chi
ngpor
tst
Ans:
3
146)
SQLERRM r
etur
nst
he
a.
Err
orcodeoft
hel
atester
ror
b.
err
ormsgassoci
atedwi
tht
hel
atester
rorcode
c.
bot
haandb
d.
noneoft
heabov
e
Ans:
2
147)di
sadv
ant
agesofdat
amar
t
a.
doesnotpr
ovi
deI
ntegr
atedv
iewofi
nfor
mat
ica
b.
uncont
rol
l
edpr
oli
fer
ati
onr
esul
tinr
edundency
c.
mor
enumberofdat
amar
tar
ecompl
ext
omai
ntai
n
d.
all
oft
heabov
e
Ans:
D