OCP19C-82

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

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

【多选题】
A After executing the ALTER TABLEcommand, you can add a new column called ORDER_DATE to the ORDERS table.
B The ORDER_DATE column should be empty for the ALTER TABLE command to execute succsessfully.
C ROLLBACK can be used to get back the ORDER_DATE column in the ORDERStable.
D The DESCRIBE command would still display the ORDER_DATE column.

关注者

0

被浏览

75

LM1998 2023-04-25

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

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

1 个回答

撰写答案

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

关于作者

子豪、

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

提问

回答

739

被采纳

739

关注TA

发私信

相关问题

1

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?

2

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?

3

Which two statements are true? (Choose two.)

4

(Choose three.)

5

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?

6

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

7

Examine the structure of the DEPARTMENTS table You execute the following command: SQL> ALTER TABLE departments SET UNUSED (country); Which two statements are true?

8

25 . 在环境风险和机遇的识别和应对过程中，责任部门应对可能存在风险的运行部、生产过程存在的风险进行逐一的筛选识别，风险识别过程中应识别包括但不限于以下方面的风险：（　）

9

<{p}>37.关子NAT地址池的配置命令如下，则其中no-pat参数的含义是: nat address-group 1<{/p}> <{p}>section 0 202.202.168.10 202.202 168.20<{/p}> <{p}>nat-mode no-pat<{/p}><{br/}><{p}><{/p}>

10

滚动轴承摩擦阻方比滑动轴承摩擦阻力_______.

发布
问题

手机
浏览

扫码手机浏览

在线
客服