Answer Posted / sudipta santra

select market_id, mkt_name, max(sale_dt)
from market
group by market_id, mkt_name;


Note: This is the only correct answer

What are the ways tablespaces can be managed and how do they differ?

2270

---

What are the uses of Database Trigger ?

1623

---

What is an oracle table?

930

---

Why do we use coalesce function in oracle?

1050

---

Why do you create or replace procedures rather that drop and recreate.

945

---

How to change program global area (pga) in oracle?

1031

---

What is a snapshot log?

949

---

What is a read write transaction in oracle?

1030

---

Explain temporal data types in oracle

1039

---

List out the difference between commit, rollback, and savepoint?

985

---

How to select an oracle system id (sid)?

1017

---

How to store only time; not date and time?

957

---

How many types of database triggers exist?

1063

---

What is oracle host variable?

980

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5330

---