Chinaunix首页 | 论坛 | 博客
  • 博客访问: 152859
  • 博文数量: 263
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 2686
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

Oracle dba培训、OCP、OCM、MYSAL认证,可以找我们,cuug专业做这些

文章分类

全部博文(263)

文章存档

2020年(3)

2019年(222)

2018年(38)

我的朋友

发布时间:2019-02-19 11:51:23

20.choose twoExamine the description of the EMP_DETAILS table given below:Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?A) You cannot add a new column to the table with LONG as the data type.B) An EMP_IMAGE column can be included .........【阅读全文】

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

发布时间:2019-02-19 10:53:58

1.choose the best answerWhat is the primary difference between the relational database (RDB) andobject-oriented database (OODB) models?A) RDB allows the definition of relationships between different tables, whereas OODBdoes not allow this.B) OODB incorporates methods with data structure definit.........【阅读全文】

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

发布时间:2019-02-19 10:04:36

18、(8-7) choose twoWhich two statements are true regarding views? (Choose two.)A) A simple view in which column aliases have been used cannot be updated.B) The OR REPLACE option is used to change the definition of an existing view without droppingand re-creating it.C) The WITH CHECK OPTION.........【阅读全文】

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

发布时间:2019-02-19 09:23:51

17、(7-11) choose twoView the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 inthe ORDERS table.Which two DELETE statements are valid? (Choose two.)A) DELETEFROM order_itemsWHE.........【阅读全文】

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

发布时间:2019-02-18 16:45:42

16、(7-5) choose the best answerThe PRODUCTS table has the following structure:Evaluate the following two SQL statements:SQL>SELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15,'')FROM products;SQL>SELECT prod_id, NVL(prod_expiry_date, prod_expiry_date + 15)FROM products;Which stat.........【阅读全文】

阅读(1310) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册