OCP-1Z0-051 第25题 create table 建表

最新推荐文章于 2024-06-08 09:42:14 发布

hello_holly

最新推荐文章于 2024-06-08 09:42:14 发布

阅读量5.8k

点赞数 2

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 CLOB DEFAULT 11g

本文链接：https://blog.csdn.net/holly2008/article/details/23750995

版权

这是一篇关于创建包含员工ID、姓名、雇佣日期、状态（默认'ACTIVE'）和CLOB类型的简历字段的数据库表的文章。讨论了正确的CREATE TABLE语句语法，并指出选项A、B和C的错误原因。

摘要由CSDN通过智能技术生成

一、原题

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 [CLOB] data type), which contains the resume submitted by the employee
Which is the correct syntax to create this table?
A. CREATE TABLE EMP_1 (emp_id NUMBER(4),
                                              emp_name VARCHAR2(25),
                                              start_date DATE,
                                              e_status VARCHAR2(10) DEFAULT 'ACTIVE',