Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 185855 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / charu gautam
primary key:- 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 record
per person or it can be generated by the D B M S .such as a
globally unique identifier ,or G U I D, in microsoft SQL
server primary key may consist of a single attribute or
multiple attribute in combination.
foreign key:- A foreign key is a field (or fields) that
points to the primary key of another table.The purpose of
the foreign key is to ensure referential integrity of the
data.In other words ,only values that are supposed to appear
in the database are permitted.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
What advantages does DBMS have over traditional file systems?
What are indexes in oracle?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
What will happen non-clustered index will be created on clustered index?
sparse lookup and where its options we find in OCI and db2?
What happens when shared and exclusive locks are applied on data item?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
Which database does facebook use?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
Explain the table term used in database.
give a simple example of physical and logical data independence
What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?
What is Object Oriented model?
