ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [ 答朋友问] same namespace ?

[ 答朋友问] same namespace ?

原创 Linux操作系统 作者:yxyup 时间:2009-05-21 10:35:48 0 删除 编辑
kerryyu 说 (10:01):
能否请教你一道ORACLE题目
Young more think、more practise、more sum-up 说 (10:01):
 好
kerryyu 说 (10:01):
10. Which of the following objects share the same namespace and therefore cannot have the same name?
A. Tables and sequences
B. Tables and indexes
C. Tables and tablespaces
D. Tables and constraints

答案是A,
见以下验证过程


SQL> create table t1(id number);

Table created.

SQL>
SQL> create index t1 on t1(id);

Index created.

SQL>
SQL> alter table t1 add constraint t1 primary key(id);

Table altered.

SQL> create sequence t1 increment by 1 start with 1 ;
create sequence t1 increment by 1 start with 1
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7364032/viewspace-600645/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1325915