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.

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

What is fmtonly in sql?

0 Answers  

---

Explain character-manipulation functions?

0 Answers  

---

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  

---

What is the use of desc in sql?

0 Answers  

---

what is sql? : Sql dba

0 Answers  

---

how to delete an existing column in a table? : Sql dba

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

How to fetch common records from two tables?

1 Answers  

---

what is a trigger in mysql? Define different types of trigger. : Sql dba

0 Answers  

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---

What are the different dml commands in sql?

0 Answers  

---