what are primary key and foreign key ?

Answer Posted / neo devan

Primary key is the attribute which satisfies both
uniqueness and Not null constraints.
The foreign key is a attribute that points to a valid
column in a parent table.
its used for referencing primary key.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load a file into database column?

591


Define ddl and dml.

697


What is system catalog or catalog relation?

691


Explain the term ‘relations’?

551


What is the best way to determine whether firebird server is running?

619






How to find the size of database?

651


What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1551


Explain primary key and composite key.

609


Is database a storage?

583


Can you have more than one cursor open at any one time in a program ?

596


What is rdbms table?

638


What is cold backup and hot backup (in case of oracle)?

567


How to use events with zebedee, ssh or stunnel?

611


What is database management definition?

563


What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

535