大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
071考試題庫之前是比較穩(wěn)定的，但隨著Oracle的調(diào)整，071考試不斷的增加新的考題，增加了考試的難度，所以我們專門收集整理了這些考試，并對(duì)這些考題進(jìn)行解析，希望可以對(duì)考生有幫助。
每周五晚8點(diǎn)，我們有免費(fèi)的OCP解析公開課，地址：https://ke.qq.com/course/326223 OCP題庫交流群：1015267481，驗(yàn)證ocp
-------------------------------------------------------
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 答案錯(cuò)誤是因?yàn)楸砻值谝粋(gè)必須是字符，不能是數(shù)字;D 答案錯(cuò)誤是因?yàn)樽址脝我?hào);C答案錯(cuò)誤是大對(duì)象類型不能指定長度)
CUUG與ORACLE公司建立最核心、最權(quán)威、最深層次的戰(zhàn)略合作伙伴關(guān)系；
CUUG是唯一一家只做DBA就業(yè)培訓(xùn)和oracle認(rèn)證的授權(quán)機(jī)構(gòu)，28年培養(yǎng)數(shù)萬名oracle技術(shù)人才；
CUUG金牌講師授課，來自一線的資深ORACLE OCM技術(shù)專家團(tuán)隊(duì)；
CUUG頂尖完善的學(xué)習(xí)體系，以甲骨文原廠ORACLE數(shù)據(jù)庫核心技術(shù)為教學(xué)課程；