Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 20 TestInside Information Co., Ltd. All rights reserved.
setareprocessed.
Answer: AC
29.Anoncorrelatedsubquerycanbedefinedas____.
A.asetofsequentialqueries,allofwhichmustalwaysreturnasinglevalue
B.asetofsequentialqueries,allofwhichmustreturnvaluesfromthesametable
C.aSELECTstatementthatcanbeembeddedinaclauseofanotherSELECTstatementonly
D.asetofoneormoresequentialqueriesinwhichgenerallytheresultoftheinnerqueryisusedasthe
searchvalueintheouterquery
Answer:D
30.Youneedtocreateatableforabankingapplicationwiththefollowingconsiderations:
1)Youwantacolumninthetabletostorethedurationofthecreditperiod.
2)Thedatainthecolumnshouldbestoredinaformatsuchthatitcanbeeasilyaddedandsubtracted
with
3)datetypedatawithoutusingtheconversionfunctions.
4)Themaximumperiodofthecreditprovisionintheapplicationis30days.
5)Theinteresthastobecalculatedforthenumberofdaysanindividualhastakenacreditfor.
Whichdatatypewouldyouuseforsuchacolumninthetable?
A.INTERVALYEARTOMONTH
B.INTERVALDAYTOSECOND
C.TIMESTAMPWITHTIMEZONE
D.TIMESTAMPWITHLOCALTIMEZONE
Answer:B
31.WhichstatementsaretrueregardingthehierarchicalqueryinOracleDatabase10g?(Chooseallthat
apply.)
A.Itispossibletoretrievedataonlyintopdownhierarchy.
B.Itispossibletoretrievedataintopdownorbottomuphierarchy.
C.Itispossibletoremoveanentirebranchfromtheoutputofthehierarchicalquery.
D.Youcannotspecifyconditionswhenyouretrievedatabyusingahierarchicalquery.
Answer:BC
32.Whichtwostatementsaretrueregardingviews?(Choosetwo.)
A.Asimpleviewinwhichcolumnaliaseshavebeenusedcannotbeupdated.