Define candidate key, alternate key, composite key?
- 30 Answers
- 141480 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / rajneesh
primary key: should be unique and Not Null
Unique Key: accept 1 null value and unique
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
Explain the rollup operator?
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 normalization? Explain different levels of normalization?
How can I detect whether a given connection is blocked?
How to use timestamp datatypes
Why does this query return 0?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain about xml databases?
What are the three basic rules which are to be followed for the relational model of the database?
Which four data types cannot be used as a return type from a user-defined function?
Explain about normal forms?
What are the constraints on severity level in raiseerror?
How to generate OIDS
Can an extended stored procedure be called from inside a user-defined function?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
