2025年计算机考试-Oracle认证考试近5年真题荟萃附答案.docx

（图片大小可自由调整）

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