评估此CREATE TABLE语句的执行结果： CREATE TABLE sales（ sales_id NUMBER， customer_id NUMBER， employee_id NUMBER， sale_date TIMESTAMP WITH LOCAL TIME ZONE， sale_amount NUMBER（7，2））； 以下关于SALE_DATE列哪个说法是的（）A、数据将以客户的时区为标准进行设置。B、存储的数据将不包含秒。C、数据将以精度为5的小数秒的形式存储。D、存储在列中的数据将会以数据库的本地时区格式返回。
评估此CREATE TABLE语句的执行结果： CREATE TABLE sales（ sales_id NUMBER， customer_id NUMBER， employee_id NUMBER， sale_date TIMESTAMP WITH LOCAL TIME ZONE， sale_amount NUMBER（7，2））； 以下关于SALE_DATE列哪个说法是的（）
- A、数据将以客户的时区为标准进行设置。
- B、存储的数据将不包含秒。
- C、数据将以精度为5的小数秒的形式存储。
- D、存储在列中的数据将会以数据库的本地时区格式返回。
相关考题：
（32）下列 SQL 的数据定义语句组中，（ ）包含了不正确的数据定义语句。Ⅰ．CREATE TABLE? CREATE VIEW? CREATE INDEX?Ⅱ．DROP TABLE? DROP VIEW? DROP INDEX?Ⅲ．ALTER TABLE? ALTER VIEW? ALTER INDEX?A）仅ⅠB）仅ⅡC）仅ⅢD）都包含
Which is a valid CREATE TABLE statement? () A. CREATE TABLE EMP9$# AS (empid number(2));B. CREATE TABLE EMP*123 AS (empid number(2));C. CREATE TABLE PACKAGE AS (packid number(2));D. CREATE TABLE 1EMP_TEST AS (empid number(2));
阅读以下说明，回答问题1至问题3，将答案写在对应栏内。【说明】关于一位花商有以下一些事实。(1)销售在不同地区生长的花，这些地区一年的量低温度在一定范围内变化。(2)想用编号来表示发货类型。(3)要出售某些类型的花。假定已经通过SQL语句建立了基本表：CREATE TABLE Zone(ID Char(2) PRIMARY KEY，LowerTemp Number (3)，UpperTemp Number (3))；CREATE TABLE Delivery(ID char(2)PRIMARY KEY，Category VarChar (5)，DelSize Number (5，3))：CREATE TABLE FlowerInfo(ID Char(3) CONSTRAINTFlowerinfo_ id _ pk PRIMARY KEY，ComName VarChar (25)，LatName VarChar (30)，Czone Number (3)，Hzone Number (3)，Delivered Number (3)，SunNeed Char (3)，PRIMARY KEY (ID))：地区(ID，最高温度，最低温度)发货(ID，发货类型，发货规格)花的信息(ID，普通名，拉丁名，花能够生长的最冷地区，花能够生长的最热地区，发货类型，日光需求)写出语句，将(ID=1，Category=pot，DelSize=1.5)的数据插入DELIVERY表中。
下列SQL的数据定义语句组中，哪一(些)组包含了不正确的数据定义语句?Ⅰ．CREATE TABLE… CREATE VIEW… CREATE INDEX…Ⅱ．DROP TABLE… DROP VIEW… DROP INDEX…Ⅲ．ALTER TABLE… ALTER VIEW… ALTER INDEX…A．仅ⅠB．仅ⅡC．仅ⅢD．都包含
改写函数为存储过程create or replace function two_number(v_one number,v_two number)return number isbeginreturn v_one*v_twoend;请将该函数改写为存储过程，注意传值参数如何设置
评估此CREATE TABLE语句的执行结果： CREATE TABLE part( part_id NUMBER, part_name VARCHAR2(25), manufacturer_id NUMBER(9), retail_price NUMBER(7,2) NOT NULL, CONSTRAINT part_id_pk PRIMARY KEY(part_id), CONSTRAINT cost_nn NOT NULL(cost), CONSTRAINT FOREIGN KEY (manufacturer_id) REFERENCES manufacturer(id)); 哪一行会导致产生错误（）A、6B、7C、8D、9
“雇员”表包含以下列： EMPLOYEE_ID NOT NULL, Primary Key SSNUM NOT NULL, Unique LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER 部门表中 DEPARTMENT_ID 列的外键 SALARY NUMBER(8,2) 如果执行以下语句： CREATE INDEX emp_name_idx ON employees(last_name, first_name); 以下哪个说法是的（）A、此语句会创建一个基于函数的索引B、因为语法错误，此语句将失败C、该语句将创建一个组合唯一索引D、该语句将创建一个组合非唯一索引
评估以下CREATETABLE语句的执行结果： CREATET ABLE customers （customer_id NUMBER，customer_name VARCHAR2（25）， address VARCHAR 2（25）， city VARCHAR 2（25）， region VARCHAR 2（25）， postal_code VARCHAR 2（11）， CONSTRAINT customer_id_un UNIQUE（customer_id）， CONSTRAINTcustomer_name_nnNOTNULL（customer_name））； 为什么执行时此语句会失败（）A、NUMBER数据类型要求精度值B、UNIQUE约束条件必须在列级定义C、CREATETABLE语句不定义PRIMARYKEYD、不能在表级定义NOTNULL约束条件
在客户/服务器结构的数据库中，在数据库中还可以存放程序，因为这种程序以数据库对象的形式存储在数据库中，所以称为（）。存储过程可以避免在网络上传输大量无用的信息或（），只需要传输调用存储过程的指令和数据库服务器返回的（）；把完成某一数据库处理的功能设计为存储过程，则可以在各个程序中（），从而减轻程序的编写工作量；可以利用存储过程间接实现一些（）。在存储过程中不可以使用（）的语句（数据定义语言，如CREATE TABLE等各种CREATE语句）
数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键是Number，数据类型为Varchar（20）。要求写删除学号为“20140001”的学生，下列哪个SQL语句是正确的（）A、Delete Student‘20140001’B、Delete Student“20140001”C、Delete Student Where Number=‘20140001’"D、Delete From Student Where Number=”20140001”"
Which is a valid CREATE TABLE statement? （）A、CREATE TABLE EMP9$# AS (empid number(2));B、CREATE TABLE EMP*123 AS (empid number(2));C、CREATE TABLE PACKAGE AS (packid number(2));D、CREATE TABLE 1EMP_TEST AS (empid number(2));
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));
Which statement accomplish this? （）A、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);C、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);D、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);E、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);F、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）A、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);B、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));C、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));D、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）A、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );B、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );C、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );D、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );E、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );F、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes this?（）A、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);B、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);C、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);D、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);E、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);F、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
多选题数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键是Number，数据类型为Varchar（20）。要求写删除学号为“20140001”的学生，下列哪个SQL语句是正确的（）ADelete Student‘20140001’BDelete Student“20140001”CDelete Student Where Number=‘20140001’DDelete From Student Where Number=”20140001”
单选题Which is a valid CREATE TABLE statement?（）ACREATE TABLE EMP9$# AS (empid number(2));BCREATE TABLE EMP*123 AS (empid number(2));CCREATE TABLE PACKAGE AS (packid number(2));DCREATE TABLE 1EMP_TEST AS (empid number(2));
填空题在客户/服务器结构的数据库中，在数据库中还可以存放程序，因为这种程序以数据库对象的形式存储在数据库中，所以称为（）。存储过程可以避免在网络上传输大量无用的信息或（），只需要传输调用存储过程的指令和数据库服务器返回的（）；把完成某一数据库处理的功能设计为存储过程，则可以在各个程序中（），从而减轻程序的编写工作量；可以利用存储过程间接实现一些（）。在存储过程中不可以使用（）的语句（数据定义语言，如CREATE TABLE等各种CREATE语句）
单选题评估此CREATE TABLE语句的执行结果： CREATE TABLE part( part_id NUMBER, part_name VARCHAR2(25), manufacturer_id NUMBER(9), retail_price NUMBER(7,2) NOT NULL, CONSTRAINT part_id_pk PRIMARY KEY(part_id), CONSTRAINT cost_nn NOT NULL(cost), CONSTRAINT FOREIGN KEY (manufacturer_id) REFERENCES manufacturer(id)); 哪一行会导致产生错误（）A6B7C8D9
单选题You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes this? （）ACREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);BCREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);CCREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);DCREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);ECREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);FCREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
单选题Which statement accomplish this? （）ACREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);BCREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);CCREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);DCREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);ECREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);FCREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);
单选题You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）ACREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );BCREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );CCREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );DCREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );ECREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );FCREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
单选题“客户财务”表包含以下列： 客户标识NUMBER（9） 新余额NUMBER（7，2） 上次余额NUMBER（7，2） 付款NUMBER（7，2） 财务费用NUMBER（7，2） 信贷限额NUMBER（7） 您创建了Top-n查询报表，其中显示新余额值最高的800个帐户的帐户编号和新余额。结果将按付款从高到低进行排序。查询中应包括哪个SELECT语句子句（）A内部查询：ORDER BY新余额DESCB内部查询：WHERE ROWNUM=800C外部查询：ORDER BY新余额DESCD内部查询：SELECT客户标识，新余额ROWNUM