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
能否请教你一道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博客 ” ，链接：https://blog.itpub.net/7364032/viewspace-600645/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
