what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 180132 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vinodkumar
Primary key:it is a key in which uniquely identify the
answer which is stored in the DBMS.A table contains a
primary key.
Foreign key:A key used in the table to represent the primary
key i.e when the primary key is used in a table of one topic
then the same name can be used as foreign key in another topic
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is ase database?
what is data access layer?
Can you tell any two advantages of stored procedures?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Explain various types of locks in a transaction? Which is better and why?
Explain database partitioning. What is its importance?
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
Explain partial key?
What is the difference between primary and candidate key?
A lowest level of security by most RDBMS is
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is a database lookup?
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
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
