Answer / Prem Shankar Yadav

SQL Integrity refers to the rules that enforce the accuracy and consistency of data in a database. It includes Entity Integrity, Domain Integrity, and Referential Integrity.

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

How to sort the rows in sql.

1 Answers  

---

What are predefined functions in sql?

1 Answers  

---

What is difference between joins and union?

1 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

1 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

Explain the the delete statements in sql?

1 Answers  

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1 Answers  

---

What is the difference between clustered and non-clustered index in sql?

1 Answers  

---