What is package versioning? Please give an example.

1 Answers  

---

What are concurrency issues?

0 Answers  

---

Which catalog tables contain authorization information?

1 Answers  

---

What is cursor in dbms?

0 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

Is schema the same as database?

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

Highlight all the advantages that are attached to a package.

0 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---