Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 138991 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pravin
The primary key of a relational table uniquely identifies
each record in the table. It can either be a normal
attribute that is guaranteed to be unique (such as Social
Security Number in a table with no more than one record per
person) or it can be generated by the DBMS (such as a
globally unique identifier, or GUID, in Microsoft SQL
Server). Primary keys may consist of a single attribute or
multiple attributes in combination.
Examples:
Imagine we have a STUDENTS table that contains a record for
each student at a university. The student's unique student
ID number would be a good choice for a primary key in the
STUDENTS table. The student's first and last name would not
be a good choice, as there is always the chance that more
than one student might have the same name.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
State any two functions of oracle?
Explain about functional dependency and its relation with table design?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How many types of tables supported by oracle?
What is materialized view in Oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What do you understand by a database object? Can you list a few of them?
List out the types of joins.
What is Data Dictionary Cache in Oracle?
What is PL/SQL ?
Explain the use of full option in exp command.
How to see the table columns used in an index?
What is sequence?
Will you be able to store pictures in the database?explain.
