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 |
how to display last 5 letters from a name (take emp table ename )
Where in the Oracle directory tree structure are audit traces placed?
How can you enable a trace for a session?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Name two files used for network connection to a database.
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
8. Supporting AP, AR and GL?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
how to create an user in oracle 10g.please give me an example..
Give the two types of tables involved in producing a star schema and the type of data they hold.
How can you rebuild an index?
Explain the process of recievables in oracle financials. : oracle accounts receivable