Interested to Buy Any Domain ? << Click Here >> for more details...
If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
- 8 Answers
- 11873 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sujith
no it is not.......... you may have some other columns which
have not null and unique constraints on it..... the thing is
that you should explicitly choose which one should be
treated as primary key so that clustered index can be put on
it, and non clustered on others where needed.........
foreign key may be used to refer to unique constraint
column, but while dropping you may loose relative unique
constraint also.. where as in case of primary referred by
foreign, will not allow so to happen............
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Write a syntax for update query in oracle?
What is oracle rowcount?
How to check database size in Oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What happens to the indexes if a table is recovered?
What is the data type of dual table?
How index is implemented in oracle database?
How to call a stored function with parameters?
How to drop a stored procedure in oracle?
Explain rename?
20. Using a set operator, display the client number of all clients who have never placed an order.
Explain coalesce function?
What are the attributes that are found in a cursor?
How to define and use table alias names in oracle?
How do I find my oracle client driver version?
