WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.
Answer / sakthi
Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.
Composite key:
It same as Primary key but combination of more that one
column.
| Is This Answer Correct ? | 14 Yes | 2 No |
How is table type constraint applied to a table?
How to declare and use cursor variables?
How to create a local temporary stored procedure?
Why use stored procedures in sql server?
How to manipulate data from one table to another table ?
what happens on checkpoint? : Sql server database administration
What is analysis service repository?
What are the different types of joins and what does each do?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is the difference between distinct clause and group by clause?
What are the components of sql server service broker?
What are subquery and its properties?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)