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 happens to the indexes if a table is recovered?

959

---

Is oracle a language?

914

---

What is the difference between pre-select and pre-query?

1160

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

985

---

How to delete multiple rows from a table in oracle?

1028

---

How to put more than 1000 values into an oracle in clause?

994

---

What do you understand by a database object?

1006

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1871

---

What is data block in Oracle?

1070

---

What is partitioned table in Oracle?

1136

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2103

---

How to omit columns with default values in insert statement in oracle?

1018

---

State all possible different index configurations a table can possibly have?

960

---

What is the usage of analyze command in oracle?

1053

---

Why do we need integrity constraints in a database?

993

---