Answer / Ravi Kumar Shukla

In SQL, there are three levels of constraints: table constraints, column constraints, and assertion constraints. Table constraints are defined on the entire table (such as primary key, foreign key). Column constraints are applied to individual columns (such as not null, unique). Assertion constraints define a check condition for multiple tables.

What are the different types of joins and explain them briefly.

3 Answers  

---

Why do we go for stored procedures?

1 Answers  

---

what are the advantages a stored procedure? : Sql dba

1 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What is trigger in sql?

1 Answers  

---

what is data integrity? : Sql dba

1 Answers  

---

What are different types of queries in sql?

1 Answers  

---

Why coalesce is used in sql?

1 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

what are the authentication modes in sql server? : Sql dba

1 Answers  

---

What is the difference between delete, truncate and drop command?

1 Answers  

---