Can A column defined as PRIMARY KEY can have NULL values ?

Question Posted / guest

2 Answers
4943 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can A column defined as PRIMARY KEY can have NULL values ?..

Answer / guest

FALSE

Is This Answer Correct ?

8 Yes

1 No

Can A column defined as PRIMARY KEY can have NULL values ?..

Answer / parul chaudhary

No,a coloum defined as PRIMARY KEY can't have NULL values,
because when we assign a coloum as a PRIMARY KEY that mean
its a unique coloum by which whole the table have to be
accessed.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More Database Management Interview Questions

What's the difference between file and database?

1 Answers

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

0 Answers

What is a candidate key in dbms?

0 Answers

How to Handle Missing Data in a Database?

1 Answers

Describe concurrency control.

0 Answers

Describe the types of keys?

0 Answers

Enlist the various transaction phases.

0 Answers

What is 2-tier architecture?