单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(

题目

单选题

You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）

SELECT* FROM customers;

SELECT name, address FROM customers;

SELECT id, name, address, phone FROM customers;

SELECT cust_name, cust_address FROM customers;

SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)COMMISSION_PCT NUMBER (6)You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value. Evaluate the SQL statement:SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide? （）

A. All of the desired results

B. Two of the desired results

C. One of the desired results

D. An error statement

参考答案：C

第2题：

The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?（）

A、Column definitions cannot be altered to add DEFAULT values.
B、A change to the DEFAULT value affects only subsequent insertions to the table.
C、Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

正确答案:B

第3题：

The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER (4) NOT NULLCUSTOMER_NAME VARCHAR2 (100) NOT NULLSTREET_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)))

参考答案：E

第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) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?（）

A、WHERE lower(country_address) = "france"
B、WHERE lower(country_address) = 'france'
C、WHERE lower(country_address) IS 'france'
D、WHERE lower(country_address) = '%france%'
E、WHERE lower(country_address) LIKE %france%

正确答案:B

第5题：

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）

A、All of the desired results
B、Two of the desired results
C、One of the desired results
D、An error statement

正确答案:C

第6题：

The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_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.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 DISTINCT UPPER(country_address)

E.COUNT(DISTINCT (UPPER(country_address)))

参考答案：E

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

正确答案:B,D

第8题：

You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:CUST_ID NUMBER(4) NOT NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_ADDRESS VARCHAR2(150)CUST_PHONE VARCHAR2(20)Which SELECT statement accomplishes this task?（）

A. SELECT* FROM customers;

B. SELECT name, address FROM customers;

C. SELECT id, name, address, phone FROM customers;

D. SELECT cust_name, cust_address FROM customers;

E. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;

参考答案：D

第9题：

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）

A、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
B、ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
C、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
D、ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E、ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
F、ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

正确答案:C

第10题：

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;

正确答案:C

单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(

题目

相似问题和答案

更多相关问题

相关内容