HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY?

Answers were Sorted based on User's Feedback



HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?..

Answer / kaleel

Each row of data in a table is uniquely
identified by a primary key
• You can logically relate data from multiple
tables using foreign keys

Is This Answer Correct ?    3 Yes 2 No

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?..

Answer / manoj byregowda

Primary key- A column (or columns)in a table which makes every row in table unique. eg - EMPLOYEE table, EMPID is column which is unique.

Foreign Key - A column (or columns) in table Whose value References to primary key of another table OR ( A column which derives its value from another tables primary key.)
eg - EMP table EMPID is PK and DEPTNO is FK.
DEPT table DEPTID is pk.

Is This Answer Correct ?    0 Yes 0 No

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?..

Answer / mkjmkumar

Primary Key Column or Columns Containt Unique Values.
Foreign Key Column or Columns does not contains Unique
Values in Table

Is This Answer Correct ?    1 Yes 2 No

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?..

Answer / mukhtiar ahmed

primary key
A column (or columns) in a table that makes the row in the
table distinguishable from every other row in the same
table.

foreign key
A column (or columns) in a table that draws its values from
a primary or unique key column in another table. A foreign
key assists in ensuring the data integrity of a table.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Oracle AllOther Interview Questions

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  


How many segment are present in Oracle Manufacturing

0 Answers   Oracle,


You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  


What background process refreshes materialized views?

1 Answers  






pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  


whats the difference between join command and Cartesian product using example?

1 Answers  


What is an Oracle database Full Backup?

0 Answers  


can we use lexical perameter in oracle plsql if yes how

0 Answers  


Are These Dff's Flexible?

0 Answers   Oracle,


Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  


What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)