25.You need to create a table with the following column specifications:
来源:互联网 发布:电子表格相同数据排序 编辑:程序博客网 时间:2024/06/05 00:33
25.You need to create a table with the following column specifications:
Employee ID (numeric data type) for each employee
Employee Name (character data type) that stores the employee name
Hire date, which stores the date of joining the organization for each employee Status (character data type),
that contains the value 'ACTIVE' if no data is entered
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',
resume CLOB(200)
);
B.CREATE TABLE 1_EMP(
emp_id NUMBER(4),
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,
emp_status VARCHAR2(10) DEFAULT "ACTIVE",
resume CLOB
);
D.CREATE TABLE EMP_1(
emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB
);
答案:D
解析:
A:错误,clob不能指定长度
B:错误,表名称不能数字开头,除非加上双引号
C:错误,默认值应该用单引号
D:正确
Employee ID (numeric data type) for each employee
Employee Name (character data type) that stores the employee name
Hire date, which stores the date of joining the organization for each employee Status (character data type),
that contains the value 'ACTIVE' if no data is entered
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',
resume CLOB(200)
);
B.CREATE TABLE 1_EMP(
emp_id NUMBER(4),
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,
emp_status VARCHAR2(10) DEFAULT "ACTIVE",
resume CLOB
);
D.CREATE TABLE EMP_1(
emp_id NUMBER,
emp_name VARCHAR2(25),
start_date DATE,
emp_status VARCHAR2(10) DEFAULT 'ACTIVE',
resume CLOB
);
答案:D
解析:
A:错误,clob不能指定长度
B:错误,表名称不能数字开头,除非加上双引号
C:错误,默认值应该用单引号
D:正确
0 0
- 25.You need to create a table with the following column specifications:
- 1Z0-051 25. You need to create a table with the following column specifications:
- 22.You need to create a table for a banking application. One of the columns in the table has the fol
- 149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
- Error with hilo in NHibernate - “could not read a hi value - you need to populate the table”
- 33.You want to create an ORD_DETAIL table to store details for an order placed having the following
- 3.You need to extract details of those products in the SALES table where the PROD_ID column contains
- 34.You created an ORDERS table with the following description:
- 165.You have an ORDERS table with the following structure:
- error "could not read a hi value - you need to populate the table".
- java.lang.IllegalArgumentException: You need to use a Theme.AppCompat theme (or descendant) with the
- Java.lang.IllegalArgumentException: You need to use a Theme.AppCompat theme (or descendant) with the
- Couldn't find a tree builder with the features you requested: lxml. Do you need to install a parser
- 14.Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount
- 30.Evaluate the following CREATE TABLE commands:
- 69.You need to generate a list of all customer last names with their credit limits from the CUSTOMER
- 37.You issued the following command to drop the PRODUCTS table:
- 1Z0-051 37. You issued the following command to drop the PRODUCTS table:
- linux
- 缓存技术PK:选择Memcached还是Redis?
- 8255 的三总线连接方法
- 一个程序员的万里长城的第一步
- 80x86汇编语言编程:三个数字进行比较
- 25.You need to create a table with the following column specifications:
- SVN提交版本时强制填写备注
- 51单片机,汇编语言,定时与计数
- 80x86汇编语言编程:查找字符串中的最大、最小值
- 80x86汇编语言编程:二进制输入、十进制输出
- 在 51 单片机系统中使用 8155
- Leetcode 155. Min Stack
- 显示一个钟表
- 80x86汇编语言编程:宏指令