网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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: 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;
参考答案
参考解析
解析：
暂无解析
更多 “单选题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: 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;” 相关考题
考题
听力原文：From an early date bankers have made a charge for the services which they provide for their customers.(9)A．From an early date the banker have charged a commission for their services.B．From an early date the banker has an obligation to serve the customers.C．From an early date the customers have charged a commission.D．From an early date the customer has an obligation to serve the banker.
考题
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;
考题
The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.Which SQL statement displays the desired results? （）A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
考题
In which of the following situations should correlation names be used?（）A、A table referenced in the FROM clause has no indexed column.B、The table referenced in the FROM clause has more than 200 columns.C、Two or more tables in the FROM clause have identical column names.D、The FROM clause contains two or more tables in the SELECT statement.
考题
You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）A、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESCB、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitC、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTD、SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
考题
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）A、Each extra column in the copy with more columns must not have a default valueB、Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC、The slave database cannot have more columns than the master. Only the master database can have more columnsD、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
考题
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;
考题
The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）A、SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B、SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C、SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D、SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
考题
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）A、SELECT last_name, 12*salary* commission_pct FROM emp;B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
考题
Which two are true about aggregate functions? （）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.
考题
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
考题
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;
考题
36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）A、Rows B、Totals C、Columns D、Cells E、Data
考题
Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A、SELECT 1, "2" FROM 3 WHERE last_name = '8';B、SELECT 1, '2' FROM 3 WHERE ' last_name = '8';C、SELECT 1, 2 FROM 3 WHERE last_name = '8';D、SELECT 1, '2' FROM EMP WHERE last_name = '8';
考题
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;
考题
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');
考题
单选题You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）A
3，2，1，4B
2，3，4，1C
4，1，3，2D
3，2，4，1
考题
单选题Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?（）A
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' AND ord_date IN ('18-JUL-2000','21-JUL-2000');B
SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin'));C
SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = 'Martin');D
SELECT ord_id, cust_id, ord_total FROMorders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');
考题
单选题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?（）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;
考题
单选题It can be inferred from the passage that the writer suggests companies shouldA
attract the more profitable customers.B
pay equal attention to all the customers.C
increase the investments in customer loyalty.D
focus only on loyal customers.
考题
单选题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?（）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;
考题
单选题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;
考题
单选题36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）A
Rows B
Totals C
Columns D
Cells E
Data
考题
多选题You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）AEach extra column in the copy with more columns must not have a default valueBColumns that are common to both versions of the table must be defined in the same order on the master and the slaveCThe slave database cannot have more columns than the master. Only the master database can have more columnsDColumns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverEThe master database cannot have more columns than the slave. Only the slave deatbase can have more columns
考题
单选题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;
考题
多选题You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）ASELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESCBSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limitCSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LASTDSELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
考题
( 难度：中等)在Hive中，以下哪个SQL语句是错误的A.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE ＞ FROM CUSTOMERS c ＞ LEFT OUTER JOIN ORDERS o ＞ ON (ID = o.CUSTOMER_ID);B.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE ＞ FROM CUSTOMERS c ＞ RIGHT OUTER JOIN ORDERS o ＞ ON (ID = o.CUSTOMER_ID);C.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE ＞ FROM CUSTOMERS c ＞ FULL OUTER JOIN ORDERS o ＞ ON (ID = o.CUSTOMER_ID);D.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE ＞ FROM CUSTOMERS c ＞ FULL OUTER JOIN ORDERS o ＞ ON (ID = o.CUSTOMER_ID OR Name = o.Name);
热门标签
最新试卷