Answer / nithya

Decode
1.It’s a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null

Case
1.It's an Expression
2.can handle range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null

Answer / dev

Decode is widely used

Explain the role of indexing in databases?

0 Answers  

---

What is dbms explain in brief?

0 Answers  

---

Explain about xml databases?

0 Answers  

---

Explain about the storage and physical database design?

0 Answers  

---

Explain about normal forms?

0 Answers  

---

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

Write short notes on manual refreshes.

0 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  

---

what is difference between primary key and unique key ?

2 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

Write the fastest query to find out how many rows exist in a table?

0 Answers  

---