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 |
One table how may column and Primary key
What is a db view?
Define constraints and give an example of their use?
What is normalization?
What are sql dirty pages?
Is the log file is a part of file group?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is the difference between char and varchar2 datatype in sql?
What is resultset concur_updatable?
Give a example to search fr a string in all stored procedure in sql server.
how do we insert 100 records at a time in a table without using for loop in database
Can I delete event logs?
Oracle (3253)
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)