單項選擇題

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%'

你可能感興趣的試題

多項選擇題

The ORDERS table has these columns:

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars?（）

A. SELECT customer_id, order_id, order_total   FROM orders   RANGE ON order_total (100 AND 2000) INCLUSIVE;
B. SELECT customer_id, order_id, order_total   FROM orders   HAVING order_total BETWEEN 100 and 2000;
C. SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total BETWEEN 100 and 2000;
D. SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total >= 100 and <= 2000;
E. SELECT customer_id, order_id, order_total   FROM orders   WHERE order_total >= 100 and order_total <= 2000;

單項選擇題

Examine the data from the ORDERS and CUSTOMERS tables.
ORDERS
ORD_ID ORD_DATE CUST_ID
12-JAN-
100 15 10000
09-MAR-
101 40 8000
09-MAR-
102 35 12500
15-MAR-
103 15 12000
25-JUN-
104 15 6000
18-JUL-
105 20 5000
106 18-JUL- 35 7000
21-JUL-
107 20 6500
04-AUG-
109 10 8000
CUSTOMERS
CUST_ID CUST_NAME CITY
10 Smith Los Angeles
15 Bob San Francisco
20 Martin Chicago
25 Mary New York
30 Rina Chicago
35 Smith New York
40 Lind New York
Evaluate the SQL statement:
SELECT *
FROM orders
WHERE cust_id = (SELECT cust_id
FROM customers
WHERE cust_name = 'Smith');
What is the result when the query is executed?（）

A. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000
B. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000
C. ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000
D. The query fails because the subquery returns more than one row.
E. The query fails because the outer query and the inner query are using different tables.

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?（）

你可能感興趣的試題

The ORDERS table has these columns: The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars?（）

The ORDERS table has these columns:

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars?（）