Answer Posted / arun

schema is a combination of fact & dimension table.(in simple way)

How to enter a new row into a table interactively?

961

---

How to bring a tablespace offline?

998

---

What are operators in oracle?

1009

---

What is tns service name?

1072

---

How to create a new view in oracle?

1013

---

Can we commit inside a function in oracle?

917

---

How to drop an existing table in oracle?

1013

---

What is parameterized cursor in oracle?

1065

---

Is insert autocommit in oracle?

1016

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1010

---

what is the scripts in data base?

2077

---

How to delete all rows a table in oracle?

1008

---

What types of joins are used in writing subqueries?

937

---

What is the difference between formal parameters and actual parameters?

1002

---

How to create additional tablespaces for an new database?

969

---