Chinaunix首页 | 论坛 | 博客
  • 博客访问: 11332
  • 博文数量: 36
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 210
  • 用 户 组: 普通用户
  • 注册时间: 2021-11-30 10:47




发布时间: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.........【阅读全文】

阅读(285) | 评论(0) | 转发(0)

发布时间: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:.........【阅读全文】

阅读(176) | 评论(0) | 转发(0)

发布时间: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.........【阅读全文】

阅读(89) | 评论(0) | 转发(0)

发布时间: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.........【阅读全文】

阅读(79) | 评论(0) | 转发(0)

发布时间: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.........【阅读全文】

阅读(89) | 评论(0) | 转发(0)

登录 注册