Answer / chaudhry

Schema objects are the logical structures that directly
refer to the database's data. Schema objects include tables,
views,
sequences, synonyms, indexes, clusters, database triggers,
procedures, functions packages and database links.

Answer / nishi

Schema objects are logical data storage structures. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the database.

What is TNS File

7 Answers   Thermotech,

---

what are the diffeenes between oracle 9i,oracle 10g

2 Answers  

---

does Oracle has only one table space?

1 Answers   Oracle,

---

Differentiate between pre-select and pre-query?

0 Answers  

---

Oracle

0 Answers   ABC, Genpact, HUI, Oracle,

---

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

Are truncate and delete commands same? If so why?

0 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

Why does for update in oracle 8 cause an ora-01002 error?

0 Answers  

---

Explain the use of file option in exp command.

0 Answers  

---

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

0 Answers  

---