OCP19C-82

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?

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

【多选题】
A The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
B The DESCRIBE commands in SQL *Plus will not display the invisible column in t he output.
C Referential integrity constraint cannot be set on t he invisible column.
D The invisible column cannot be made visible and can only be marked as unused.
E A primary key constraint can be added on t he invisible column.

关注者

0

被浏览

179

153****1698 2023-04-25

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

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

1 个回答

撰写答案

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

关于作者

leidengsen

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

提问

回答

303

被采纳

204

关注TA

发私信

相关问题

1

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?

2

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?

3

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?

4

Which two statements are true? (Choose two.)

5

(Choose three.)

6

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

7

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

8

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

9

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

10

<{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}>

发布
问题

手机
浏览

扫码手机浏览

在线
客服