071考試是OCP認(rèn)證的一個重要科目，不少考生都在這里受傷，對此我們專門收集整理了近期071考試的原題，并對071題庫進(jìn)行了講解，希望幫助大家順利通過071考試。
--------------------------------------------
071考試原題分享-第56題、choose the best answer:
You need to create a table with the following column specifications:
1. Employee ID (numeric data type) for each employee
2. Employee Name (character data type) that stores the employee name
3. Hire date, which stores the date of joining the organization for each employee
4. Status (character data type), that contains the value 'ACTIVE' if no data is entered
5. Resume (character large object [CLOG] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table?
A) CREATE TABLE 1_EMP
(emp_id NUMBER (4) ,
emp_name VARCHAR2(25),
start_date DATE,
emp_tatus VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
B) CREATE TABLE EMP_1
(emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB);
C) CREATE TABLE EMP_1
(emp_id NUMBER (4) ,
emp_name VARCHAR2(25),
start_date DATE,
e_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB(200));
D) CREATE TABLE EMP_1
(emp_id NUMBER (4) ,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT "ACTIVE",
resume CLOB);
Answer：B
(解析：A 答案錯誤是因?yàn)楸砻值谝粋€必須是字符，不能是數(shù)字;D 答案錯誤是因?yàn)樽址脝我?C答案錯誤是大對象類型不能指定長度)
-----------------------------------------------
OCP解析公開課時間：【每周五晚8點(diǎn)】
OCP解析公開課地址：https://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗(yàn)證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進(jìn)行中，OCM最新題庫大爆料-【每周四晚8點(diǎn)】，【微信群直播】，可以聯(lián)系咨詢老師進(jìn)群參與
