oracle ocp 19c考题,科目082考试题(17)-using an invisible column

2022/1/20 19:16:50

本文主要是介绍oracle ocp 19c考题,科目082考试题(17)-using an invisible column,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

17. 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?

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.

source : cuug



这篇关于oracle ocp 19c考题,科目082考试题(17)-using an invisible column的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!


扫一扫关注最新编程教程