【優(yōu)技教育】Oracle 19c OCP 082題庫(Q 8題)- 2024年修正版

考試科目：1Z0-082

考試題量：90

通過分?jǐn)?shù)：60%

考試時(shí)間：150min

本文為(CUUG 原創(chuàng))整理并解析，轉(zhuǎn)發(fā)請(qǐng)注明出處，禁止抄襲及未經(jīng)注明出處的轉(zhuǎn)載。

原文地址：http://www.mudan321.com/ocp/082kaoshitiku/38167699730.html

第8題：

8、Choose two.

Examine this statement:

CREATE TABLE employees

(emp_id NUMBER(5) PRIMARY KEY,

ename VARCHAR2 (15) ,

email VARCHAR2(40) UNIQUE,

address LONG ,

resume LONG,

dept_id NUMBER(3) CONSTRAINT emp_dept_id_fk REFERENCES departments (dept_id) ,

CONSTRAINT ename_nn NOT NULL

);

Which two things must be changed for it to execute successfully?

A) The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.

B) The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.

C) One of the LONG columns must be changed to a VARCHAR2 or CLOB.

D) The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

E) The primary key constraint on EMP_ID must have a name.

Answer：AC

(解析：非空約束必須在列級(jí)聲明;實(shí)驗(yàn)證明一張表只能有一個(gè) long 數(shù)據(jù)類型的列，但是可以有多個(gè) clob 數(shù)據(jù)類型的類，這一點(diǎn)需要注意;列級(jí)定義外鍵約束的時(shí)候無需 foreign key 關(guān)鍵字。)

Oracle 19c OCP認(rèn)證需要到Oracle指定的WDP機(jī)構(gòu)，有了培訓(xùn)記錄之后才能考試，考試需要考2科，分別是082(60%及格)和083(57%及格)，兩科都通過之后才能拿到證書。證書如下：

CUUG是甲骨文的金牌WDP合作機(jī)構(gòu)，30多年品牌，培養(yǎng)了數(shù)萬名數(shù)據(jù)庫人才。想快速通過19c OCP考試的同學(xué)可以掃碼聯(lián)系老師咨詢。