If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

what are enums used for in mysql? : Sql dba

0 Answers  

---

What is clustered and nonclustered index in sql?

0 Answers  

---

How to run sql commands in sql*plus?

0 Answers  

---

What is having clause in sql?

0 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

Do you understand the meaning of exception handling?

3 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---