2025年计算机考试-Oracle认证考试近5年真题集锦（频考类试题）带答案.docx

（图片大小可自由调整）

2025年计算机考试-Oracle认证考试近5年真题集锦（频考类试题）带答案

第I卷

一.参考题库(共80题)

1.You?work?as?a?database?administrator?for?S.?You?want?to?be?notified?when?the?number?of?disk?I/O?increases?by?10%?of?what?it?was?yesterday.?You?create?a?baseline?metric?for?yesterday’s?disk?I/O?performance.?How?do?you?use?the?baseline?metrics?to?achieve?your?objective？（）

A、Save?the?baseline?in?the?database

B、Save?the?baseline?in?the?Database?Control?Home?Page

C、Create?a?procedure?to?read?and?apply?the?baseline?to?disk?I/O?metrics

D、Apply?the?baseline?to?the?disk?I/O?metrics?in?the?Mange?Metrics?page

E、Alter?the?disk?I/O?metrics?to?include?baseline?by?using?the?ALTER?METRICScommnd

2.WhichareDMLstatements?（）

A、COMMIT

B、MERGE

C、UPDATE

D、DELETE

E、CREATE

F、DROP...

3.Given： What?is?the?result？（）

A、Compilation?fails.

B、aAaA?aAa?AAaa?AaA

C、AAaa?AaA?aAa?aAaA

D、AaA?AAaa?aAaA?aAa

E、aAa?AaA?aAaA?AAaa

4.Whichthreearetrue?（）

A、AMERGEstatementisusedtomergethedataofonetablewithdatafromanother.

B、AMERGEstatementreplacesthedataofonetablewiththatofanother.

C、AMERGEstatementcanbeusedtoinsertnewrowsintoatable.

D、AMERGEstatementcanbeusedtoupdateexistingrowsinatable.

5.ExaminethestructureoftheEMPLOYEESandNEW_EMPLOYEEStables: EMPLOYEES EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE NEW_EMPLOYEES EMPLOYEE_IDNUMBERPrimaryKey NAMEVARCHAR2(60) WhichDELETEstatementisvalid?（）

A、DELETEFROMemployeesWHEREemployee_id=(SELECTemployee_idFROMemployees);

B、DELETE*FROMemployeesWHEREemployee_id=(SELECTemployee_idFROMnew_employees);

C、DELETEFROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMnew_employeesWHEREname=carrey);

D、DELETE*FROMemployeesWHEREemployee_idIN(SELECTemployee_idFROMne