[ 答朋友問] same namespace ?
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部落格 ” ,連結:http://blog.itpub.net/7364032/viewspace-600645/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- struts2 namespace問題namespace
- Web 面試問答Web面試
- 問答專案
- 基礎問答
- 提問與問答技巧
- [MySQL Help]答朋友問:5000W記錄的Innodb表如何快速的去重複資料MySql
- https問答篇HTTP
- Redux:自問自答Redux
- QTP問與答(轉)QT
- Unicode 問答集Unicode
- C#問答 (轉)C#
- 老牌問答網站“雅虎問答”近日宣佈正式關站NRE網站
- Clone a database on the same serverDatabaseServer
- NETMicroFramework常見問題問答Framework
- QT中namespaceQTnamespace
- 關於namespacenamespace
- [namespace hdk] modintnamespace
- Apache Hive 面試問答題ApacheHive面試
- 智慧問答機器人機器人
- 新書問答:Lost and Founder新書
- 漁樵問答之IT篇
- Linux安全問答(3)Linux
- Code Review 五問五答View
- Scrivener for Mac 的問與答Mac
- 自問自答總結
- Excel列印問與答教程Excel
- Java Servlet工作原理問答JavaServlet
- Java Servlet 工作原理問答JavaServlet
- 防破解問答集 (轉)
- XHTML基礎問答(轉)HTML
- B. Same Parity Summands
- Leetcode Same TreeLeetCode
- 「火鍋問答」是啥?面向自然語言和多步推理問題,新型問答資料集HotpotQA面世
- 問答營銷怎麼做?問答網路推廣的平臺和形式
- 關於webpack問答記錄...Web
- NLP教程(7) - 問答系統
- 問答方式學 Node.jsNode.js
- 搭建智慧問答機器人機器人