Answer Posted / animesh

SQL IS A STRUCTURED QUERY LANGUAGE THROUGH WHICH WE CAN
COMMUNICATE WITH THE ORACLE SERVER AND SQL STATEMENTS ARE
DIVIDED INTO FIVE STATEMENTS i:e. Data defintion language
(DDL) which is used in creating the tables,views. In DDL
create,
Alter,
Drop,
Rename,
Trucate comes.
where as Data Manipulation Language(DML)command is used to
manipulate the data.In DML
Insert,
Update,
Delete,
Merge.
the third one is Data retrieval i:e. the select command
the fourth one is Transcation control i:e.
commit,Rollback,savepoint.
the fifth one is data control language(DCL) i:e.
grant,revoke

Explain enable novalidate constraint.

593

---

How are extents allocated to a segment?

573

---

What is oracle and what are its different editions?

570

---

How to invoke the original export import utilities?

503

---

How to see free space of each tablespace?

585

---

---

How can we view last record added to a table?

593

---

How to view all columns in an existing table?

545

---

How to export data to a csv file?

617

---

How to load data through external tables?

579

---

How to write a query with a right outer join in oracle?

609

---

What is a data dictionary and how can it be created?

606

---

What is a tns file?

498

---

How do I manually create a database in oracle?

536

---

What are transaction isolation levels supported by oracle?

572

---

How to convert a date to char in oracle? Give one example.

581

---