what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.
Answer Posted / ravi singh
Primary Keys: Primary keys are the identifier and applied
on the table in the form of constraints. Primary key
provides uniqueness in the data.
Foreign Key: Foreign Keys are the relationship and applied
on the table in the form of constraints. Foreign key in a
table is a primary key of another table and use to make
relationship between two tables.
| Is This Answer Correct ? | 59 Yes | 3 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
What is connection pool in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to drop an existing table in oracle?
Explain the use of online redo log files in oracle.
What is a trigger and what are its types?
How to convert times to characters in oracle?
How to use "if" statements on multiple conditions?
What is a user role in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is raw datatype?
State some uses of redo log files?
What is Segment Advisor in Oracle?
What is an Oracle index?
Is truncate autocommit in oracle?