Answer / nashiinformaticssolutions

• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.

Answer / glibwaresoftsolutions

• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.

Answer / hr@tgksolutions.com

• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.

What is a join?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

What is a sql statement?

0 Answers  

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

What is normalisation in sql?

0 Answers  

---

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---

how to create temparary sequence

2 Answers   TCS,

---