Oracle OCP 19c 认证1Z0-082考试题库(第21题)-CUUG整理
21、Choose threeExamine this description of the PRODUCTS table:Name NULL? TYPE------------------------------------------------------------------------PROD_ID NOT NULL VARCHAR2(6)QUANTITY NUMBER(8,2)PRICE NUMBER(10.2)EXPIRY_DATE DATERows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.Which three commands execute successfully on PRODUCTS?A) ALTER TAELE products DROP COLUMN expiry_date;B) CREATE INDEX price_idx on products (price);C) ALTER TABLE products SET UNUSED(expiry_date);D) TRUNCATE TABLE products;E) ALTER TABLE products DROP UNUSED COLUMNSF) DROP TABLE products
页:
[1]