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

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







发布时间:2019-10-21 11:39:52

Which three statements are true about dropping and unused columns in an Oracle database?B) A DROP COLUMN command can be rolled backD) An UNUSED column's space is redaimed automatially when the row containing that column is next queried.F) A column that is set to NNUSED still counts tow.........【阅读全文】

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

发布时间:2019-10-21 10:25:04

Which two statements are true about a self join?B) It can be a left outer join.D) It can be an inner join.Answer:BD不过在进行内连接时为了区别表的名字,需要加别名from emp2 won w.mgr=m.empno;)......【阅读全文】

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

发布时间:2019-10-18 14:51:08

Which two statements are true about Oracle synonyms?B) All private synonym names must be unique in the database.D) A synonym can be created on an object in a package.(解析:同义词也是 Oracle 的一个对象;......【阅读全文】

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

发布时间:2019-10-18 09:36:29

Which three statements are true about views in an Orade batabase?B) Rows inserted into a table using a view are retained in the table if the view is doppedD) Views have no segment.F) A view can be created that refers to a non-existent table in its defining query.(解析:.........【阅读全文】

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

发布时间:2019-10-17 11:49:07

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATEThe NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day ofthe weekA) SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6), 'MONDAY') FROM employees;C) S.........【阅读全文】

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

登录 注册