Answer / akbar

Use EXPLAIN to list out the access paths of several
different codes you come up with and choose the path that
got executed within the least time.

Can you Average the Characters ?

3 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

what is the responsibility of the construction superintendent

0 Answers   Almco,

---

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

What is EXPLAIN?

1 Answers  

---

What is the purpose of rollback and commit?

0 Answers  

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

---