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.

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.

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.

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

What is a null value?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---

What are the subsets of sql?

0 Answers  

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

What do you think about pl/sql?

0 Answers  

---

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

How do I order by ascending in sql?

0 Answers  

---

What is the size of partition table?

0 Answers  

---

What is query syntax?

0 Answers  

---

How do you rank data in sql?

0 Answers  

---