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

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

文章分类

全部博文(487)

文章存档

2024年(2)

2023年(37)

2021年(151)

2020年(37)

2019年(222)

2018年(38)

我的朋友

分类: Oracle

2019-07-04 09:55:51

56题、choose two

In your database, USERS is the default permanent tablespace.

Examine the commands and their outcome:

SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users;

User created.

SQL> GRANT create session, sysdba TO user02;

Grant succeeded.

You plan to execute the commands:

SQL> CONN user02/us123 AS SYSDBA

SQL> CREATE TABLE mytab (id number, lname varchar2(20));

Which two statements are true?

A) The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

B) The MYTAB table is owned by the SYS user.

C) The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

D) The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

E) The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

Answer:BE

(解析:当以sysdba权限登录时,用户名就是sys,跟user02没有关系了,所有创建的表都是属于sys,存放在system表空间。)

阅读(723) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~