31-Examine the data in the CUST NAME

多选题
31-Examine the data in the CUST NAME column of the CUSTOMERS table:
CUST_NAME
---------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

A、 WHERE INITCAP(SUBSTR(cust_name,INSTR(cust_name,' ') +1)) IN('MC%','Mc%);

B、 WHERE UPPER(SUBSTR(cust_name,INSTR(cust_name,' ') +1)) LIKE UPPER('MC%');

C、 WHERE INITCAP(SUBSTR(cust_name,INSTR(cust_name,' ') +1)) LIKE 'Mc%';

D、 WHERE SUBSTR(cust_name,INSTR(cust_name,' ') +1) LIKE 'Mc%' OR 'MC%';

E、 WHERE SUBSTR(cust_name,INSTR(cust_name,' ') +1) LIKE 'Mc%';

查看答案

下载APP答题

由4l***8v提供分享举报纠错

相关试题

单选题
37-Choose the best answer
Examine the description of the PRODUCT_INFORMATION table:
Name NULL? Type
------------------------------------------------------------------------
PROD_ID NOT NULL NUMBER(2)
PROD_NANE VARCRAR2(10)
LIST_PRICE NUMBER(6,2)
Which query retrieves the number of products with a null list price?

A、 SELECT(COUNT(list_price) FROM Product_intormation WHERE list_price=NULL;

B、 SELECT count(NVL(list_price,0)) FROM product_information WHERE list_price is null;

C、 SELECT COUNT(DISTINCT list_price) FROM product_information WHERE list_price is null.

D、 BELECT COUNT(list_price) FROM product_information where list_price is NULL;

查看答案

单选题
45-Choose the best answer
You have been asked to create a table for a banking application.
One of the columns must meet three requirements:
1) Be stored in a format supporting date arithmetic without using conversion functions
2) Store a loan period of up to 10 years
3) Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?

A、 TIMESTAMP WITH TIMEZONE

B、 TIMESTAMP

C、 TIMESTAMP WITH LOCAL TIMEZONE

D、 INTERVAL YEAR TO MONTH

E、 INTERVAL DAY TO SECOND

查看答案

单选题
8-The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE
You want to display the date of the first Monday after the completion of six months since hiring
The NLS_TERRITORY parameter is set to AMERICA in the session and,therefore,Sunday is the first day of the week
Which query can be used?

A、 SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6),'MONDAY') FROM employees;

B、 SELECT emp_id,ADD_MONTHS(hire_date,6),NEXT_DAY('MONDAY') FROM employees;

C、 SELECT emp_id,NEXT_DAY(MONTHS_BETWEEN(hire_date,SYSDATE),6) FROM employees;

D、 SELECT emp_id,NEXT_DAY(ADD_MONTHS(hire_date,6),1) FROM employees;

查看答案

单选题
13-Choose the best answer.
Examine this query:
SELECT TRUNC(ROUND(156.00,-2),-1) FROM DUAL;
What is the result?

A、 16

B、 160

C、 150

D、 200

E、 100

查看答案

单选题
56-Choose the best answer
Examine the description of the CUSTOMERS table:
Name Null? Type
----------------------------------------------------------------
CUST_ID Not NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME Not NULL VARCHAR2(50)
ADDRRESS VARCHAR2(50)
CITY VARCHAR2(25)
You want to display details of all customers who reside in cities starting with the letter D followed by at least two character
Which query can be used?

A、 SELECT * FROM customers WHERE city='D_%';

B、 SELECT * FROM customers WHERE city='%D_';

C、 SELECT * FROM customers WHERE city LIKE 'D %';

D、 SELECT * FROM customers WHERE city LIKE 'D_';

查看答案

单选题
5-The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.
The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.
Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

A、 SELECT REPLACE(REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

B、 SELECT REPLACE(TRIM(TRALING 'son' FROM cust_last_name),'An','O') FROM customers;

C、 SELECT INITCAP(REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;

D、 SELECT REPLACE(SUBSTR(cust_last_name,-3),'An','O') FROM customers;

查看答案

单选题
1-Examine the description of the EMPLOYEES table:
Name Null Type
----------------------------------------------------
EMP_ID NOT NUL NUMBER
EMP_NAME VARCHAR2(40)
DEPT_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE
Which query is valid?

A、 SELECT dept_id,join_date,SUM(salary) FROM employees GROUP BY dept_id,join_date;

B、 SELECT depe_id,join_date,SUM(salary) FROM employees GROUP BY dept_id:

C、 SELECT dept_id,MAX(AVG(salary)) FROM employees GROUP BY dept_id;

D、 SELECT dept_id,AVG(MAX(salary)) FROM employees GROUP BY dapt_id;

查看答案

单选题
54-Choose the best answer.
Examine this query:
SELECT 2 FROM dual d1 CROSS JOIN dual d2 CROSS JOIN dual d3;
What is returned upon execution?

A、 0 rows

B、 an error

C、 8 rows

D、 6 rows

E、 1 row

F、 3 rows

查看答案