Answer / Shuchi Gupta

The number of SQL databases you can have on one server depends on the server's capacity. For instance, a typical server could handle dozens to hundreds of databases, but this can vary greatly based on factors like the server's hardware, configuration, and database sizes.

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

what does the t-sql command ident_current does? : Transact sql

1 Answers  

---

Differentiate between syntax and runtime errors.

1 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1 Answers  

---

how to calculate expressions with sql statements? : Sql dba

1 Answers  

---

Why do we go for stored procedures?

1 Answers  

---

What is a unique key?

1 Answers  

---

how do you tune the slow running queries in oracle db , explain the methodology

1 Answers  

---

What are the various levels of constraints?

1 Answers  

---

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

8 Answers   Oracle,

---

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,

---

Differentiate pl/sql and sql?

1 Answers  

---