多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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 the 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 the output.
  • C、Referential integrity constraint cannot be set on the 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 the invisible column.
正确答案:A,B,C
答案解析:
进入题库查看解析

微信扫一扫手机做题