发布时间：2022-01-26 16:42:33

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.........【阅读全文】

发布时间：2022-01-25 13:19:47

20、choose two:Examine the structure of the DEPARTMENTS tableName 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:.........【阅读全文】

发布时间：2022-01-24 10:15:48

19、choose the best answer Evaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A) Any views created on the EMP table that include the MGR_ID column would be automatically modified and re.........【阅读全文】

发布时间：2022-01-21 17:13:53

18、Evaluate the following ALTER TABLEstatement:ALTER TABLE orders SET UNUSED (order_date);Which statement is true?A. After executing the ALTER TABLEcommand, you can add a new column called ORDER_DATE to the ORDERS table.B. The ORDER_DATE column should be empty for the ALTER TABLE.........【阅读全文】

发布时间：2022-01-20 10:29:39

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 decl.........【阅读全文】