oracle ocp 19c考題,科目082考試題(20)-set unused column
20、choose two:
Examine the structure of the DEPARTMENTS table
Name Null? Type
------------------------
DEPARTMENT NOT NULL NUMBER(4)
DEPARTMENT_NAME NOT NULL VARCHAR2(30)
MANAGER_ID NUMBER(6)
LOCATION_ID NUMBER(4)
COUNTRY VARCHAR2(20)
You execute the following command:
SQL> ALTER TABLE departments
SET UNUSED (country);
Which two statements are true?
A) A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.
B) Indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command is executed.
C) Unique key constraints defined on the COUNTRY column are removed.
D) Synonyms existing on the DEPARTMENTS table would have to be re-created.
E) Views created on the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid.
source : cuug
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2853934/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle ocp 19c考題,科目082考試題(19)-set unused columnOracle
- oracle ocp 19c考題,科目082考試題(18)-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考題11,科目082考試題 - about SET VERIFY ON commandOracle
- oracle ocp 19c考題,科目082考試題(17)-using an invisible columnOracle
- 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考題,科目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考題學習