What is Primary Key?

Answers were Sorted based on User's Feedback



What is Primary Key?..

Answer / ashis kumar jena

A primary key is one which uniquely identifies a row
of a table.
This key does not allow null values and also
does not allow duplicate values.
Each table should have a primary key, and each table can
have only one primary key.

Is This Answer Correct ?    16 Yes 2 No

What is Primary Key?..

Answer / perumal

1. Primary Key Doesn't allow the NULL values and also
does not allow duplicate values.

2. Primary Key has the Unique Columns.

3. Primary Key Uniquely Identify the each row of the tables.

Is This Answer Correct ?    14 Yes 3 No

What is Primary Key?..

Answer / hannan oca

primary key =notnull+unique value in column

a table consist of only one primary key.

Example

a primary key is like a father in house, like only one but
there may be a lot of childs just like columns.

Is This Answer Correct ?    3 Yes 1 No

What is Primary Key?..

Answer / satheeh

Primary key is nothing but restriction or condition or constraint given to a specific column to avoid the null and duplicate values.
primary key=not null+unique
that means primary key performs both operations at a time.
primary key plays vital role when relationship between two or more tables

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

Does sql require a server?

0 Answers  


What are reports usually used for?

0 Answers  


Are stored procedures faster than queries?

0 Answers  


select 10 from dual; y its showing all the rows with 10?

1 Answers  


What is difference between pl and sql?

0 Answers  






What are the different types of constraints?

0 Answers  


What are the modes of parameters that can be passed to a procedure ?

3 Answers  


How to fix oracle error ora-00942: table or view does not exist

0 Answers  


why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,


I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,


How do I edit a trigger in sql developer?

0 Answers  


How do I order by ascending in sql?

0 Answers  


Categories