（图片大小可自由调整）
2025年计算机考试-Oracle认证考试近5年真题荟萃附答案
第I卷
一.参考题库(共80题)
1.EvaluatethisSQLstatement: SELECTe.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID,d.DEPARTMENT_NAME FROMEMPLOYEESe,DEPARTMENTSd WHEREe.DEPARTMENT_ID=d.DEPARTMENT_ID; Inthestatement,whichcapabilitiesofaSELECTstatementareperformed?（）
A、selection,projection,join
B、difference,projection,join
C、selection,intersection,join
D、intersection,projection,join
E、difference,projection,product
2.Which?of?the?following?most?closely?represents?an?image?copy??（）
A、Unix?cp?command?of?a?file
B、Bit-by-bit?copy?of?a?file
C、Windows?COPY?command?of?a?file?
D、All?of?the?above
3.Whichsubstitutionvariablewouldyouuseifyouwanttoreusethevariablewithoutpromptingtheusereachtime?（）
A、
B、ACCEPT
C、PROMPT
D、
4.YouwanttocreateatemporarytablenamedOLD_INVENTORYintheOLD_INVENTORYdatabaseonthemasterserver.Thistableisnottobereplicatedtotheslaveserver. Whichtwochangeswouldensurethatthetemporarytabledoesnotpropagatetotheslave?（）
A、Usethe–replicate-do-db,—replicate-do-table,or–replicate-wild-do-tableoptionwiththevalueequaltoOLD_INVENTORY
B、Changethebinlog_formatoptiontoROWandrestartmysqldbeforeyoucreatetheOLD_INVENTORYtable
C、StopSQL_THREADontheslaveuntilyouhavefinishedusingtheOLD_INVENTORYtemporarytable
D、Setbinlog_format=MIXEDwiththe–replicate-ignore-temp-tableoption
E、Usethe–replicate-ignore-tableoptionwiththevalueequaltoOLD_INENTORY.OLD_INVENTORYandrestartmysqldbeforecreatingthetemporarytable
5.Whichtwostatementsaboutsequencesaretrue?（）
A、YouuseaNEXTVALpseudocolumntolookatthenextpossiblevaluethatwouldbegeneratedfromasequence,withoutactuallyretrievingthevalue.
B、YouuseaCURRVALpseudocolumntolookatthecur