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

（图片大小可自由调整）

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

第I卷

一.参考题库(共80题)

1.Which?two?are?regarding?automatic?space?management?segments？（）

A、A

B、B

C、C

D、D

2.WhenexecutingaSQLworkload,youchoosetogenerateexecutionplansonly,withoutcollectingexecutionstatistics.Whichtwostatementsdescribetheimplicationsofthis?（）(Choosetwo.)

A、Itproduceslessaccurateresultsofthecomparisonanalysis.

B、ItautomaticallycallstheSQLTuningAdvisorforrecommendations.

C、Itshortensthetimeofexecutionandreducestheimpactonsystemresources.

D、Onlythechangesintheexecutionplan,andnotperformanceregression,aredetected.

3.YouwouldliketodisplaythesystemdateintheformatMonday,01June,2001.WhichSELECTstatementshouldyouuse?（）

A、SELECTTO_DATE(SYSDATE,FMDAY,DDMonth,YYYY)??FROMdual;

B、SELECTTO_CHAR(SYSDATE,FMDD,DYMonth,YYY)??FROMdual;

C、SELECTTO_CHAR(SYSDATE,FMDay,DDMonth,YYYY)??FROMdual;

D、SELECTTO_CHAR(SYSDATE,FMDY,DDDMonth,YYYY)??FROMdual;

E、SELECTTO_DATE(SYSDATE,FMDY,DDDMonth,YYYY)??FROMdual;

4.You?issue?the?following?RMAN?command?to?set?a?retention?policy?on?a?database：???????RMANCONFIGURE?RETENTION?POLICY?TO?REDUNDANCY?2；?? What?will?be?the?outcome?of?the?above?command？（）

A、?After?two?days，?the?backup?will?be?marked?obsolete.

B、?After?two?days，?the?backup?will?be?deleted?from?the?media.

C、?If?the?RMAN?repository?has?records?of?two?or?more?recent?backups?of?a?file，?then?the?older?backup?will?be?deleted?from?the?media.

D、?If?the?RMAN?repository?has?records?of?two?or?more?recent?backups?of?a?file，?then?the?older?backup?will?be?marked?obsolete.

5.William?specified?the?following?initialization?parameter?settings?in?the?pfile：?? BACKGROUND_DUMP_DEST?=?’u01/oradata/dir_A’?? USER_DUMP_DEST?=?’u01/oradata/dir_B’?? DB_CREATE_FILE_DEST?=?’u01/oradata/dir_C’?? DB_CREATE_ONLINE_LOG_DEST_n