Define candidate key, alternate key, composite key?
Answer Posted / kamal
candidte key has following character
1 it is a combition of attributes that used to identify a database record without any extraneous data.
2 it has ability to became primary key.
3 it uniquely identifies the row in a table .there can be more than one canditate key in table ,in which one should be a primary key.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain what a database is?
How long can an error message be in raiseerror function?
Explain about relational database management systems?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How to combine two function together?
What is a database development?
What is an application role and explain a scenario when you would use one?
How to use online Backups?
How to read and create .LDC data files which are used by linguatic dictionary.
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
In which database can extended stored procedures be added?
What are the constraints on severity level in raiseerror?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How to customize error conditions.