what is the difference between primary key & foreign key?
Answer Posted / harish
primary key does not allow duplicate and null values
but foreign key allows null values it refers primary key
| Is This Answer Correct ? | 25 Yes | 10 No |
Post New Answer View All Answers
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is recycle bin in Oracle?
How to execute a stored procedure in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Calculate difference between 2 date / times in oracle sql?
What is user managed backup in Oracle?
How to connect to a remote server?
What is hash cluster in oracle?
When system tablespace is created?
What is a user role in oracle?
What is dual table oracle?
What is different types of joins?
Explain the use of indexes option in exp command.
What is where clause in oracle?
Can group functions be used in the order by clause in oracle?