Answer Posted / vikranth

sql is a structured query language which acts as an
interface to the RDBMS.It is used in the application
development side to select the data from the database.

DDL is Data definition language statements which are used
to develop a structure to the table. where as DML(data
manipulation language statements) are used to perform the
updations to the data.

How to execute the package in oracle?

1081

---

What is the quickest way to fetch the data from a table?

1058

---

How to create a new view in oracle?

1078

---

What is a system tablespace and when it is created?

970

---

How remove data files before opening a database?

1072

---

What is the difference between translate and replace in oracle?

1164

---

List the types of joins used in writing subqueries?

996

---

11. Display the client number and name and the client number and name of the person who referred that client.

2339

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2310

---

How to get a list of all background sessions in the database?

993

---

Why do we use bulk collect in oracle?

1058

---

What is an Oracle index?

1655

---

How to get a list of all user accounts in the database?

1087

---

What happens if the update subquery returns multiple rows?

1116

---

How to define a sub function?

1129

---