本文深入探讨了在Oracle数据库中使用ALTER TABLE命令添加PRIMARY KEY约束的场景和注意事项，强调即使存在数据，只要没有重复值，仍然可以添加主键约束。通过实例分析，确保理解数据库操作的正确性和效率。
QUESTION NO: 61
You created an ORDERS table with the following description:
Exhibit:
You inserted some rows in the table. After some time, you want to alter the table by creating the
PRIMARY KEY constraint on the ORD_ID column.
Which statement is true in this scenario?
A. You cannot add a primary key constraint if data exists in the column
B. You can add the primary key constraint even if data exists, provided that there are no duplicate
values
C. The primary key constraint can be created only a the time of table creation
D. You cannot have two constraints on one column
Answer: B
答案解析：
参考：34：http://blog.csdn.net/rlhua/article/details/12921757
Explanation:
Oracle 1z0-051 Exam
"Pass Any Exam. Any Time." - 100% Pass Guarantee 51
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
