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
In which table collections errors are stored.
How is data stored in dbms?
What are the constraints on severity level in raiseerror?
What are the main phases of database development?
How long can an error message be in raiseerror function?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is the maximum length of an extended property?
Explain the cube operator?
How to replace not in with not exist?
How to read and create .LDC data files which are used by linguatic dictionary.
Can an extended stored procedure be called from inside a user-defined function?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
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
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Why does this query return 0?