what is the difference between primary key & foreign key?
Answer Posted / reddy
foreign key is NULL
foreign key reference as Primary key in another table
Primary key is unique
primary key is not NULL and
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What privilege is needed for a user to delete rows from tables in another schema?
various types of hints and their usage
How to check the server version in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain the use of file option in exp command.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to delete multiple rows from a table in oracle?
What is the difference between hot backup and cold backup in oracle?
What are the types of partitions in oracle?
What is query image?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Can we create database in oracle using command line ?
Difference between oracle's plus (+) notation and ansi join notation?