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

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

文章分类

全部博文(255)

文章存档

2019年(217)

2018年(38)

我的朋友

发布时间:2019-10-14 11:25:39

Which three are true about the CREATE TABLE command?B) The owner of the table should have space quota available on the tablespace where the table is defined.D) It implicitly rolls back any pending transactions.F) The owner of the table must have the UNLIMITED TABLESPACE system privileg.........【阅读全文】

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

发布时间:2019-10-14 10:24:31

Exanine the desciption of the EMPLOYEES table:----------------------------------------------------------EMP_NAME VARCHAR2 (40)SALARY NUMBER(8,2)Which query is valid?B) SELECT depe_id,join_date, SUM(salary) FROM employees GROUP BY dept_id:D) SELECT dept_ id,AVG (MAX (salary).........【阅读全文】

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

发布时间:2019-09-30 14:01:41

Which two actions must you take?B)Grant access to the Oracle software owner O/S account to all database administrators.D)Assign different O/S groups to the OSOPER and OSDBA credentials.Answer: CD题译:你已经决定实行最少权限和职责分离的原则。principle 原则。D 译:向 OSOPER 和 OS.........【阅读全文】

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

发布时间:2019-09-30 13:31:08

  The database default tablespace is EXAMPLE.Examine these commands;User created.User alteredA)USER1 can create tables in EXAMPLE tablespaceC)USER1 can create tables in the EXAMPLE tablespaceE)USER1 can login to the database instance.赵:AC 错,没有授权表空间的.........【阅读全文】

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

发布时间:2019-09-29 14:38:45

DEFERRED_SEGMENT_CREATION IS FALSE.SQL.>CREATE USER user1 IDENTIFIED BY oracle_4U password expire;SQL>ALTER USER user1 ACCOUNT UNLOCK;SQL>GRANT CREATE SESSION TO user1;SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;Which three are true?B)USER1 can grant the CREATE TABLE .........【阅读全文】

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

登录 注册