由以下语句创建的表有种子字段，请正确组合插入语句，可不分先后。CREATE TABLE Customer（id int IDENTITY PRIMARY KEY，Customer varchar（40））（）A、INSERT INTO CustomerB、SET IDENTITY_INSERT Customer ONC、VALUES（3，’garden shovel’）D、（id，Customer）

第1题：

现有表book，字段：id（int），title（varchar），price（float）；其中id字段设为标识，使用insert语句向book表中插入数据，以下语句错误的是（）。

• A、insert into book (id,title,price) values(1,'java',100)
• B、insert into book (title,price) values('java',100)
• C、insert into book values ('java',100) 这辆都不可以啊，如果不指定列需要明确的给出空值
• D、insert book values('java',100)

第2题：

现有表book，字段：id（int），title（varchar），price（float）；其中id字段设为标识，使用insert语句向book表中插入数据，以下语句错误的是（）。

• A、insert into book（id，title，price）values（1，’java’，100）
• B、insert into book（title，price）values（’java’，100）
• C、insert into book values（’java’，100）
• D、insert book values（’java’，100）

第3题：

第4题：

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code? （）

• A、SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
• B、SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';
• C、SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;
• D、SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
• E、SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;

第5题：

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);

第6题：

评估以下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语句不定义PRIMARYKEY
• D、不能在表级定义NOTNULL约束条件

第7题：

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）

• A、SELECT TOTAL(*) FROM customer;
• B、SELECT COUNT(*) FROM customer;
• C、SELECT TOTAL(customer_id) FROM customer;
• D、SELECT COUNT(customer_id) FROM customer;
• E、SELECT COUNT(customers) FROM customer;
• F、SELECT TOTAL(customer_name) FROM customer;

第8题：

第9题：

假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”，可以使用（）语句。

• A、ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGE
• B、ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGE
• C、RENAME TABLE CUSTOMER TO CUSTOMER_CHANGE
• D、RENAME TABLE CUSTOMER CUSTOMER_CHANGE

第10题：

Examine the description of the CUSTOMERS table: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?（）

• A、SELECT city_address, COUNT(*) FROM customers WHERE city_address IN ('Los Angeles', 'San Francisco');
• B、SELECT city_address, COUNT(*) FROM customers WHERE city_address IN ('Los Angeles', 'San Francisco') GROUP BY city_address;
• C、SELECT city_address, COUNT(customer_id) FROM customers WHERE city_address IN ('Los Angeles', 'San Francisco') GROUP BY city_address, customer_id;
• D、SELECT city_address, COUNT(customer_id) FROM customers GROUP BY city_address IN ('Los Angeles', 'San Francisco');