primary key: should be unique and Not Null Unique Key: accept 1 null value

Define candidate key, alternate key, composite key?

Question Posted / rajneesh

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

Please Help Members By Posting Answers For Below Questions

How to use timestamp datatypes

2032

What is data modeling with example?

989

What is dbms and its application?

1001

Write short notes on manual refreshes.

2729

What are the main phases of database development?

978

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

999

What are the constraints on severity level in raiseerror?

982

How can you fix a poorly performing query?

1178

How long can an error message be in raiseerror function?

999

Explain what a database is?

1041

How is data stored in dbms?

954

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?

2426

Explain about network model?

1000

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4006

fact table and dimension table containg one to many relationship or many to one relastionship

2492