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 is sequence?

633

---

How do you store pictures in a database?

574

---

What is Undo Management Advisor in Oracle?

618

---

What is index-organized table in Oracle?

581

---

How to use attributes of the implicit cursor in oracle?

573

---

---

How to define a data field as not null?

640

---

What is a nvl function?

572

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1480

---

How will you write a query to get a 5th rank student from a table student_report?

1393

---

please explain.. DB architecture ...

1568

---

What is a procedure in oracle?

624

---

How to insert a new row into a table in oracle?

601

---

How to create a server parameter file?

582

---

Can select statements be used on views in oracle?

600

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1215

---