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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2853153/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle ocp 19c考題,科目082考試題(18)-unused columnOracle
- oracle ocp 19c考題,科目082考試題(19)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(20)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題-Oracle NetOracle
- oracle ocp 19c考題,科目082考試題-temporary undoOracle
- oracle ocp 19c考題,科目082考試題-INTERSECT operatorOracle
- ocp 19c考題,科目082考試題(28) - oracle profilesOracle
- oracle ocp 19c考題7,科目082考試題-listener tnsnamesOracle
- oracle ocp 19c考題,科目082考試題-date/time functionsOracleFunction
- oracle ocp 19c考題10,科目082考試題 - shared server dispatchersOracleServer
- ocp 19c考題,科目082考試題(31) - resource_limitMIT
- ocp 19c考題,科目082考試題(25)- instance situations
- oracle ocp 19c考題8,科目082考試題-logical and physical database structuresOracleDatabaseStruct
- oracle ocp 19c考題11,科目082考試題 - about SET VERIFY ON commandOracle
- oracle ocp 19c考題,科目082考試題(21)-read-only tableOracle
- ocp 19c考題,科目082考試題(14)-starting with the letter D
- ocp 19c考題,科目082考試題(23)- space management within blocks managed ASSMBloCSSM
- Oracle 19c OCP 1Z0-082認證考試題庫(19-23)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(24-29)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(30-35)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(36-41)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(51-60)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(7-12)Oracle
- Oracle 19c OCP 1Z0-082認證考試題庫(13-18)Oracle
- OCP考試題庫-185題
- oracle 11g ocp各考試科目題量、時間和通過率要求Oracle
- oracle ocp考試程式的登入問題Oracle
- Oracle 10g OCP DBA的考試科目減少到兩門Oracle 10g
- OCP考試題庫-IZ0-052 第10題
- 【每日一練】Oracle OCP認證考試題庫解析052-1Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-2Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-3Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-4Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-5Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-6Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-7Oracle
- 【每日一練】Oracle OCP認證考試題庫解析052-8Oracle
- 關於OCP考題學習