Answer Posted / anil kumar abbireddy

any no. of

What is a system tablespace and when it is created?

972

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2108

---

How do I limit the number of oracle database connections generated by weblogic server?

1070

---

How to pass parameters to procedures in oracle?

1042

---

How to create an oracle database?

1041

---

What is oracle thin client?

1023

---

What are the various oracle database objects?

1144

---

Please explain oracle left join with an example?

1045

---

How do I manually create a database in oracle?

1019

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2093

---

How a database is related to tablespaces?

1031

---

What is parameterized cursor in oracle?

1150

---

What are the advantages of oracle?

1028

---

What are the different types of database objects?

1062

---

How does Oracle guarantee data integrity of data changes?

2388

---