Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116502 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / raghuram
Candidate Key is a Key which identifies each row of a table
uniquely. Generally a Candidate Key becomes a Primary Key
of the table. If table has more than one Candidate Keys
then one is called Primary key and rest are called
Alternative Keys.
A key is formed by two or more columns is called Composite
Keys.
| Is This Answer Correct ? | 80 Yes | 28 No |
Post New Answer View All Answers
Explain cross join or cartesian product in sql?
What are the drawbacks of reporting in ssrs?
How to find out the list schema name and table name for the database?
Explain can SSRS reports Cache results?
How to select some specific columns from a table in a query in ms sql server?
What causes index fragmentation?
What are different replication agents and what's their purpose? : sql server replication
What is bulkcopy in sql?
What are “phantom rows”?
What are translations and its use? : sql server analysis services, ssas
What is page in sql server?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How do you trace the traffic hitting a sql server?
How to create a Master database in SQL server ?
How you can get a list of all the table constraints in a database?
