由以下语句创建的表有种子字段，请正确组合插入语句，可不分先后。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）

题目

由以下语句创建的表有种子字段，请正确组合插入语句，可不分先后。CREATE TABLE Customer（id int IDENTITY PRIMARY KEY，Customer varchar（40））（）

A、INSERT INTO Customer
B、SET IDENTITY_INSERT Customer ON
C、VALUES（3，’garden shovel’）
D、（id，Customer）

更多“由以下语句创建的表有种子字段，请正确组合插入语句，可不分先后。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题

假设需要更改表名“CUSTOMER”为“CUSTOMER_CHANGE”，可以使用（）语句。A、ALTER TABLE CUSTOMER RENAME CUSTOMER_CHANGEB、ALTER TABLE CUSTOMER RENAME TO CUSTOMER_CHANGEC、RENAME TABLE CUSTOMER TO CUSTOMER_CHANGED、RENAME TABLE CUSTOMER CUSTOMER_CHANGE

点击查看答案
第2题

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;

点击查看答案
第3题

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

点击查看答案
第4题

在Oracle中，你以SYSDBA登录，CUSTOMER表位于Mary用户方案中，下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词（）。A、CREATE PUBLIC SYNONYM cust ON mary.customerB、CREATE PUBLIC SYNONYM cust FOR mary.customerC、CREATE SYNONYM cust ON mary.customer FOR PUBLICD、不能创建CUSTOMER的公用同义词

点击查看答案
第5题

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER (4) NOT NULL CUSTOMER_NAME VARCHAR2 (100) NOT NULL STREET_ADDRESS VARCHAR2 (150) CITY_ADDRESS VARHCAR2 (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. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?（）A、COUNT(UPPER(country_address))B、COUNT(DIFF(UPPER(country_address)))C、COUNT(UNIQUE(UPPER(country_address)))D、COUNT DISTINTC UPPER(country_address)E、COUNT(DISTINTC (UPPER(country_address)))

点击查看答案
第6题

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

点击查看答案
第7题

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

点击查看答案

题目

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容