Chinaunix首页 | 论坛 | 博客
  • 博客访问: 134582
  • 博文数量: 255
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 2916
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59

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







发布时间:2019-11-27 09:44:09

Examine the description of the PRODUCT_INFORMATION table:------------------------------------------------------------------------PROD_NANE           VARCRAR2 (10)Which query retrieves the number of products with a null list price?B) SELECT Count(nvl( l.........【阅读全文】

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

发布时间:2019-11-25 10:17:30

Which three statements are true about sequences in a single instance Orade database?B) Two or more tables cannot have keys generated from the same sequence.D) A sequence can issue duplicate values.F) A sequence can only be dropped by a DBA.(解析:虚拟可以一下子产生一组的数字缓存在.........【阅读全文】

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

发布时间:2019-11-25 09:40:24

Which two statenents are tue about the COUNT function?B) COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing dupicates and NULLs in the INV_AMT columnD) A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.Answer::BC.........【阅读全文】

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

发布时间:2019-11-20 09:59:00

Which two statements are true about the results of using the INTERSECT operator in compound queres?B) Column names in each SELECT in the compound query can be dfferent.D) The number of columns in each SELECT in the compound query can be dfferent.Answer::BC......【阅读全文】

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

发布时间:2019-11-20 09:27:05

Which three statements are true about a self join?B) It can be an outer join.D) It must be an equijoin.F) The ON clause can be used.(解析:左连接其实就是左外连接,是不同的称呼而已,其结果都是一样的,ANSI 语法有select emp.empno,emp.deptno,dept.deptno,dept.dnameselect emp.emp.........【阅读全文】

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

登录 注册