Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key?
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 in the Oracle directory tree structure are audit traces placed?
what is semphore explian it?
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
What is the sql query to find the employee who has Nth maximum salary?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
how can it possibble to see the report output in excel sheet in oracle applications
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
WHAT IS CARTESIAN PRODUCT?
what are the API of GL,PO,AP