ORACLE OCP007最新题库

Oracle1Z0-007IntroductiontoOracle9i:SQL156Q&ALookingforRealExamQuestionsforITCertificationExams!WeguaranteeyoucanpassanyITcertificationexamatyourfirstattemptwithjust10-12hoursstudyofourguides.Ourstudyguidescontainactualexamquestions,youwillgetwordtowordsameonyouractualtest;accurateanswerswithdetailedexplanationverifiedbyexpertsandallgraphicsanddrag-n-dropexhibitsshownjustasontherealtest.Totestthequalityofourguides,youcandownloadtheone-fourthportionofanyguidefrom♦Microsoft:70-270,70-305,70-526,MB2-421♦Cisco642-901,642-871,642-611,642-502,642-425,646-561♦Oracle:1Z0-001,1Z0-007,1Z0-040,1Z0-200♦Novell:50-676,50-565♦Adobe:9A0-019♦Apple:9L0-004,9L0-505,9L0-606♦3COM:3M0-211♦Citrix:1Y0-223,1Y0-256♦CIW:1D0-420♦EMC:E20-001♦Enterasys:2B0-011♦ExamExpress:EE0-011♦Foundry:FN0-100♦Hyperion:4H0-002♦HP:HP0-045,HP0-052,HP0-055,HP0-090,HP0-216,HP0-417♦Juniper:JN0-120,JN0-330♦Lotus:190-510♦NetworkAppliances:NS0-121♦NetworkGeneral:1T6-520♦Nortel:920-430,920-803♦OMG:UM0-100♦Sybase:510-015♦SAIR:3X0-101,201♦SAS:A00-201♦Tibco:TB0-103…..Forpricingandplacingorder,[e-mail]:1ExaminethestructureoftheEMPLOYEEStable:EMPLOYEE_IDNUMBERPrimaryKeyFIRST_NAMEVARCHAR2(25)LAST_NAMEVARCHAR2(25)Whichthreestatementsinsertarowintothetable?(Choosethree.)A.INSERTINTOemployeesVALUES(NULL,'John','Smith');B.INSERTINTOemployees(first_name,last_name)VALUES('John','Smith');C.INSERTINTOemployeesVALUES('1000','John',NULL);D.INSERTINTOemployees(first_name,last_name,employee_id)VALUES(1000,'John','Smith');E.INSERTINTOemployees(employee_id)VALUES(1000);F.INSERTINTOemployees(employee_id,first_name,last_name)VALUES(1000,'John','');Answer:C,E,FQ:2EvaluatetheSQLstatement:SELECTROUND(45.953,-1),TRUNC(45.936,2)FROMdual;Whichvaluesaredisplayed?A.46and45B.46and45.93C.50and45.93D.50and45.9E.45and45.93F.45.95and45.93Answer:C(Chooseallthatapply.)A.COMMITB.MERGEC.UPDATED.DELETEE.CREATEF.DROP...Answer:B,C,DQ:4EvaluatethesetofSQLstatements:CREATETABLEdept(deptnoNUMBER(2),dnameVARCHAR2(14),locVARCHAR2(13));ROLLBACK;DESCRIBEDEPTWhatistrueabouttheset?A.TheDESCRIBEDEPTstatementdisplaysthestructureoftheDEPTtable.B.TheROLLBACKstatementfreesthestoragespaceoccupiedbytheDEPTtable.C.TheDESCRIBEDEPTstatementreturnsanerrorORA-04043:objectDEPTdoesnotexist.D.TheDESCRIBEDEPTstatementdisplaysthestructureoftheDEPTtableonlyifthereisaCOMMITstatementintroducedbeforetheROLLBACKstatement.Answer:AQ:5EvaluatethisSQLstatement:SELECTename,sal,12*sal+100FROMemp;TheSALcolumnstoresthemonthlysalaryoftheemployee.Whichchangemustbemadetotheabovesyntaxtocalculatetheannualcompensationasmonthlysalaryplusamonthlybonusof$100,multipliedby12?A.Nochangeisrequiredtoachievethedesiredresults.*(sal+100)FROMemp;C.SELECTename,sal,(12*sal)+100FROMemp;D.SELECTename,sal+100,*12FROMemp;Answer:BQ:6ExaminetheSQLstatementthatcreatesORDERStable:CREATETABLEorders(SER_NONUMBERUNIQUE,ORDER_IDNUMBER,ORDER_DATEDATENOTNULL,STATUSVARCHAR2(10)CHECK(statusIN('CREDIT','CASH')),PROD_IDNUMBERREFERENCESPRODUCTS(PRODUCT_ID),ORD_TOTALNUMBER,PRIMARYKEY(order_id,order_date));ForwhichcolumnswouldanindexbeautomaticallycreatedwhenyouexecutetheaboveSQLstatement?(Choosetwo.)A.SER_NOB.ORDER_IDC.STATUSD.PROD_IDE.ORD_TOTALF.compositeindexonORDER_IDandORDER_DATEAnswer:A,FQ:7ExaminethestructureoftheEMP_DEPT_VUview:ColumnNameTypeRemarksEMPLOYEE_IDNUMBERFromtheEMPLOYEEStableEMP_NAMEVARCHAR2(30)FromtheEMPLOYEEStableJOB_IDVARCHAR2(20)FromtheEMPLOYEEStableSALARYNUMBERFromtheEMPLOYEEStableDEPARTMENT_IDNUMBERFromtheDEPARTMENTStableDEPT_NAMEVARCHAR2(30)FromtheDEPARTMENTStable*FROMemp_dept_vu;B.SELECTdepartment_id,SUM(salary)FROMemp_dept_vuGROUPBYdepartment_id;C.SELECTdepartment_id,job_id,AVG(salary)FROMemp_dept_vuGROUPBYdepartment_id,job_id;D.SELECTjob_id,SUM(salary)FROMemp_dept_vuWHEREdepartment_idIN(10,20)GROUPBYjob_idHAVINGSUM(salary)20000;E.Noneofthestatementsproduceanerror;allarevalid.Answer:EQ:8ClicktheExhibitbuttonandexaminethedatafromtheORDERSandCUSTOMERStables.EvaluatethisSQLstatement:SELECTcust_id,ord_totalFROMordersWHEREord_totalANY(SELECTord_totalFROMordersWHEREcust_idIN(SELECTcust_idFROMcustomersWHEREcityLIKE'NewYork'));Whatistheresultwhentheabovequeryisexecuted?:9EvaluatethisSQLstatement:SELECTe.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID,d.DEPARTMENT_NAMEFROMEMPLOYEESe,DEPARTMENTSdWHEREe.DEPARTMENT_ID=d.DEPARTMENT_ID;Inthestatement,whichcapabilitiesofaSELECTstatementareperformed?A.selection,projection,joinB.difference,projectio