Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key and foreign key when and where have to use
- 5 Answers
- 7481 Views
- I also Faced
- E-Mail Answers
Answer Posted / raveendran
Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.
foreign key points to primary key of another table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which are the five query types available in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What do you mean by merge in oracle?
Explain the use of file option in exp command.
What is the recommended interval at which to run statspack snapshots, and why?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is oracle sid?
Explain drop constraint oracle?
How do you tell what your machine name is and what is its IP address?
When do we use group by clause in a sql query?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the differences between date and timestamp in oracle?
Explain what are synonyms used for?
What is a read write transaction in oracle?
How do I escape a reserved word in oracle?
