Answer Posted / sanjay

Oracle

What are the oracle built-in data types?

756

---

How much memory your 10g xe server is using?

821

---

What is a sub query? What are its various types?

794

---

What is meant by recursive hints in oracle?

831

---

What is the sid in oracle?

709

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1711

---

what is IDE,DMV in sql server?

2492

---

Explain the use of parfile option in exp command.

746

---

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.

1807

---

How to assign query results to variables?

800

---

How to handle a single quote in oracle sql?

789

---

How to convert a date to char in oracle? Give one example.

824

---

When do I need to use a semicolon vs a slash in oracle sql?

810

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2731

---

How to check the oracle tns settings?

791

---