OCP19C-82

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

发布于 2021-04-25 04:04:27

【多选题】
A SELECT * FROM customers WHERE city LIKE ‘D_%’;
B SELECT * FROM customers WHERE city = ‘%D_’;
C SELECT * FROM customers WHERE city LIKE ‘D_’;
D SELECT * FROM customers WHERE city = ‘D_%’;

关注者

0

被浏览

76

色即是空 2023-04-25

你要求的次数愈多，你就越容易得到你要的东西，而且连带地也会得到更多乐趣。

此回答被采纳为最佳答案，开通VIP会员可查看

1 个回答

撰写答案

请登录后再发布答案，点击登录

关于作者

hyz860210

这家伙很懒，什么也没写！

提问

回答

1120

被采纳

1120

关注TA

发私信

相关问题

1

现金购买的电子客票，自退票之日起180天内（含当日），持购票时使用的( )前往任一铁路车站窗口领取现金。

2

A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?

3

You have been tasked to create a table for a banking application. One of the columns must meet three requirements: Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

4

7.In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: Which statement is true?

5

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used?

6

Which two statements are true? (Choose two.)

7

(Choose three.)

8

Examine the following command: CREATE TABLE ( prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in t he PRODUCTS table?

9

ALTER TABLE orders SET UNUSED (order_date); Which statement is true?

10

ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement?

发布
问题

手机
浏览

扫码手机浏览

在线
客服