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
- 12468 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
What is parameterized cursor in oracle?
What are the various oracle database objects?
How many memory layers are in the oracle shared pool?
How do we display rows from the table without duplicates?
What is an Oracle Instance?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Explain temporal data types in oracle
what is the scripts in data base?
What is hot backup and logical backup?
How to shutdown your 10g xe server?
How to set up autotrace for a user account?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What are the uses of a database trigger?
How to synchronize 2 schema's objects?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
