Answer Posted / a.swarna devi

select * from user_tables;

What is hot backup and logical backup?

1010

---

What is the max number of columns in an oracle table?

946

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

966

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2260

---

What are the extensions used by oracle reports?

1004

---

What are the execution control statements in oracle?

1041

---

How to resolve the ORA-39133 error in Oracle?

1049

---

How to open and close an explicit cursor in oracle?

1012

---

What is a nested table and how is it different from a normal table?

998

---

What is SQL access advisor in Oracle?

1150

---

What are a cluster and non-cluster index?

968

---

How to get last row id?

947

---

Differentiate between post-database commit and post-form commit?

988

---

Explain about integrity constraint?

1089

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2268

---