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

how to use 'mysql' to run sql statements? : Sql dba

0 Answers  

---

What is input buffer in sql*plus?

0 Answers  

---

Mention what pl/sql package consists of?

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

How many types of triggers exist in pl/sql?

0 Answers  

---

What is difference between procedure and trigger?

0 Answers  

---

What is dbo in sql?

0 Answers  

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What is time based sql injection?

0 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---