Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 2 TestInside Information Co., Ltd. All rights reserved.
ImportantNote,PleaseReadCarefully
OtherTestInsideproducts
OfflineTestingEngine
UsetheofflineTestingengineproducttopracticethequestionsinanexamenvironment.
Buildafoundationofknowledgewhichwillbeusefulalsoafterpassingtheexam.
DownloadtheTestingEngineVersionof1Z0047
More TestInside Oracle OtherOracleCertification Products
LatestVersion
We are constantly reviewing our products. New material is added and old material is revised. Free
updatesareavailablefor90daysafterthepurchase.YoushouldcheckyourmemberzoneatTestInside
andupdate34daysbeforethescheduledexamdate.
Hereistheproceduretogetthelatestversion:
1.Goto http://www.TestInside.com
2.LogintheUserCenter
3.Thelatestversionsofallpurchasedproductsaredownloadablefromhere.Justclickthelinks.
Feedback
Ifyouspotapossibleimprovementthenpleaseletusknow.Wealwaysinterestedinimprovingproduct
quality.
Feedbackshouldbesendtosales@TestInside.com.Youshouldincludethefollowing:Examnumber,
version,pagenumber,questionnumber,andyourlogin Account.
Ourexpertswillansweryourmailpromptly.
Explanations
Thisproductdoesnotincludeexplanationsatthemoment.Ifyouareinterestedinprovidingexplanations
forthisexam,pleasecontactsales@TestInside.com.
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 3 TestInside Information Co., Ltd. All rights reserved.
1.YouneedtoloadinformationaboutnewcustomersfromtheNEW_CUSTtableintothetablesCUST
andCUST_SPECIAL.Ifanewcustomerhasacreditlimitgreaterthan10,000,thenthedetailshavetobe
insertedintoCUST_SPECIAL.AllnewcustomerdetailshavetobeinsertedintotheCUSTtable.Which
techniqueshouldbeusedtoloadthedatamostefficiently?
A.externaltable
B.theMERGEcommand
C.themultitableINSERTcommand
D.INSERTusingWITHCHECKOPTION
Answer:C
2.ViewtheExhibitandexaminethedescriptionoftheCUSTOMERStable.
YouwanttoaddaconstraintontheCUST_FIRST_NAMEcolumnoftheCUSTOMERStablesothatthe
valueinsertedinthecolumndoesnothavenumbers.
WhichSQLstatementwouldyouusetoaccomplishthetask?
A.ALTERTABLECUSTOMERS
ADDCONSTRAINTcust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'^AZ'))NOVALIDATE;
B.ALTERTABLECUSTOMERS
ADDCONSTRAINTcust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'^[09]'))NOVALIDATE;
C.ALTERTABLECUSTOMERS
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 4 TestInside Information Co., Ltd. All rights reserved.
ADDCONSTRAINTcust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'[[:alpha:]]'))NOVALIDATE;
D.ALTERTABLECUSTOMERS
ADDCONSTRAINTcust_f_name
CHECK(REGEXP_LIKE(cust_first_name,'[[:digit:]]'))NOVALIDATE;
Answer:C
3.WhichthreetaskscanbeperformedusingregularexpressionsupportinOracleDatabase10g?
(Choosethree.)
A.Itcanbeusedtoconcatenatetwostrings.
B.Itcanbeusedtofindoutthetotallengthofthestring.
C.Itcanbeusedforstringmanipulationandsearchingoperations.
D.Itcanbeusedtoformattheoutputforacolumnorexpressionhavingstringdata.
E.Itcanbeusedtofindandreplaceoperationsforacolumnorexpressionhavingstringdata.
Answer:CDE
4.ViewtheExhibitandexaminethestructureoftheEMPtablewhichisnotpartitionedandnotan
indexorganizedtable.
EvaluatethefollowingSQLstatement:
ALTERTABLEemp
DROPCOLUMNfirst_name;
Whichtwostatementsaretrueregardingtheabovecommand?(Choosetwo.)
A.TheFIRST_NAMEcolumnwouldbedroppedprovideditdoesnotcontainanydata.
B.TheFIRST_NAMEcolumnwouldbedroppedprovidedatleastoneormorecolumnsremaininthe
table.
C.TheFIRST_NAMEcolumncanberolledbackprovidedtheSETUNUSEDoptionisaddedtotheabove
SQLstatement.
D.TheFIRST_NAMEcolumncanbedroppedevenifitispartofacompositePRIMARYKEYprovided
theCASCADEoptionisused.
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 5 TestInside Information Co., Ltd. All rights reserved.
Answer:BD
5.EvaluatetheCREATETABLEstatement:
CREATETABLEproducts
(product_id NUMBER(6)CONSTRAINTprod_id_pk PRIMARYKEY,
product_name VARCHAR2(15));
WhichstatementistrueregardingthePROD_ID_PKconstraint?
A.Itwouldbecreatedonlyifauniqueindexismanuallycreatedfirst.
B.Itwouldbecreatedandwoulduseanautomaticallycreateduniqueindex.
C.Itwouldbecreatedandwoulduseanautomaticallycreatednonuniqueindex.
D.Itwouldbecreatedandremainsinadisabledstatebecausenoindexisspecifiedinthecommand.
Answer:B
6.Whichtwostatementsaretrue?(Choosetwo.)
A.TheUSER_SYNONYMSviewcanprovideinformationaboutprivatesynonyms.
B.TheuserSYSTEMownsallthebasetablesanduseraccessibleviewsofthedatadictionary.
C.AllthedynamicperformanceviewsprefixedwithV$areaccessibletoallthedatabaseusers.
D.TheUSER_OBJECTSviewcanprovideinformationaboutthetablesandviewscreatedbytheuser
only.
E.DICTIONARYisaviewthatcontainsthenamesofallthedatadictionaryviewsthattheusercan
access.
Answer: AE
7.ViewtheExhibitandexaminethedescriptionoftheORDERStable.
WhichtwoWHEREclauseconditionsdemonstratethecorrectusageofconversionfunctions?(Choose
two.)
