Answer Posted / u.radha

SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME FROM COUNTRY,CITY
WHERE COUNTRY.COUNTRY_NAME = CITY.COUNTRY_NAME ;

How remove data files before opening a database?

566

---

How can we delete duplicate rows in a table?

568

---

What are data pump export and import modes?

613

---

How different is ms access and oracle?

547

---

What are the different oracle database objects?

588

---

---

What is a dead lock in oracle?

598

---

Explain the use of record length option in exp command.

560

---

What is oracle and what are its different editions?

581

---

What does sharding mean?

539

---

How to define an external table with a text file?

579

---

How to count groups returned with the group by clause in oracle?

578

---

Can we connect to ORACLE db using Windows Authentication?

722

---

Please explain oracle data types with examples?

590

---

How to change user password in oracle?

605

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661

---