Interested to Buy Any Domain ? << Click Here >> for more details...
Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
- 1 Answers
- 4838 Views
- I also Faced
- E-Mail Answers
Answer / ramachandra
we are using primary key and foreign key database designer identify an entity
diffencee b/w primary key and foreign key
1.every table should have one primary key
but foreign key it doesnt any rule we keep more than one foreign key
2.primary key doesn't accept null values
3primary key is parent key
but foreign key is child key it depends only primary key table or column it doesn't allow more than primary key column attributes.
4.primary key doesn't accept duplicate values
but foreign key accepting duplicate values
| Is This Answer Correct ? | 3 Yes | 0 No |
Where would you look for errors from the database engine?
deference between & and &&
When creating a user, what permissions must you grant to allow them to connect to the database?
which one is currently in used software cmpanies.
how to create an user in oracle 10g.please give me an example..
How do you add a data file to a tablespace?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Give two examples of how you might determine the structure of the table DEPT.
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
3. Steps in UAT?
Could you please let me know the interfaces in OM / FA??
Oracle General 
