Answer / orawhiz

Each Index has an Index segment that stores all of its data

Answer / nishi

Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment.

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

0 Answers  

---

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

2 Answers   Wipro,

---

What are privileges and grants?

0 Answers  

---

What is an oracle transaction?

0 Answers  

---

how to genarate random numbers in oracle for particular row?

3 Answers  

---

What to do if the binary spfile is wrong for the default instance?

0 Answers  

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

0 Answers   CTS,

---

What to do if dba lost the system password?

0 Answers  

---

What are the different types of partitions in oracle?

0 Answers  

---

How to call a stored function with parameters?

0 Answers  

---