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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the best free database software?

537


Where is the data stored in a database?

586


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????

1628


Why are recursive relationships are bad? How do you resolve them?

703


Define dml compiler.

702






dear sir please provide what question will be asked in bank it officer interview

1795


Describe the difference between data and database administration.

547


What are the applications of database?

557


Define database system.

647


What is the normal procedure followed by a java client to access the db?

511


What are the different type of relationships in the dbms?

575


What are rdbms concepts?

589


What is database normalization with example?

571


Can files be stored in a database?

589


What do you mean by e-r model & object-oriented model?

602