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

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








发布时间:2019-11-18 15:01:27

Evalute these conmands which execate sucestullyINCREMENT BY 1MAXVALUE 100000CACHE 5000;A) Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.C) Sepuence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 timesE) Se.........【阅读全文】

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

发布时间:2019-11-18 14:36:48

·MANAGER is an existing role with no privileges or roles.·EMPLOYEES is an existing table in the HR schema.A) GRANT CREATE SEQUENCE TO manager, emp;C) GRANT CREATE TABLE, emp TO manager;E) GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;(解析:DAnswer::不能同时授权.........【阅读全文】

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

发布时间:2019-11-14 14:27:26

The ORDERS table has a column ORDER_DATE of date type DATEWhich two WHERE conditions demonstrate the correct usage of conversion functions?B) WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'D) WHERE order_date IN (TO_DATE ('Oct 21 2018', 'MON DD YYYY'), TO_CHAR('Nov 21 2018','M.........【阅读全文】

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

发布时间:2019-11-14 13:26:48

Which two statements are true about the DUAL table?B) It can be accessed only by the SYS user.D) It can display multiple rows but only a single column.F) It can be used to display only constants or pseudo columns.(解析:dual 这个虚拟的表可以显示多行多列;任何用户都可以访问它。这道题.........【阅读全文】

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

发布时间:2019-11-11 10:57:48

Which three actions can you perfom only with system privileges?B) Access flat files via a database, which are stored in an operating system directory.D) Query any table in a database.F) Execute a procedure in another schema.(解析:这道题考的就是可以授权哪些系统权限去做哪些活儿。.........【阅读全文】

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

登录 注册