071考試不僅是OCP11g的考試科目，同時也是OCP 12c的考試科目，所以關(guān)心071考題的同學有很多，對此我們專門收集整理了近期071考試的原題，并對這些考題進行講解，希望幫助廣大考生順利通過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 答案錯誤是因為表名字第一個必須是字符，不能是數(shù)字;D 答案錯誤是因為字符要用單引號;C答案錯誤是大對象類型不能指定長度)
-----------------------------------------------
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：https://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯(lián)系咨詢老師進群參與
