what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.
Answer Posted / nimmi
PRIMARY KEY : IS THE UNIQUE KEY OF A SINGLE TABLE THAT IS
THE UNIQUE IDENTIFICATION OF THE SAME TABLE.
FOREIGN KEY: MEANS A UNIQUE KEY IDENTIFICATION COMMON TO TWO
TABLES .
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the uses of synonyms?
What is oracle datasource?
How do we display rows from the table without duplicates?
What are the different types of trigger and explain its various uses and functions?
What is raw datatype?
How a database is related to tablespaces?
what is the use of system.effective.date variable in oracle?
How to install oracle odbc drivers?
What happens in oracle commit?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Does oracle partitioning improve performance?
What do you mean by a tablespace?
Which environment variables are absolutely critical in order to run the OUI?
What are the data types in oracle?