Answer Posted / naveen

SELECT * FROM EMP WHERE ROWID IN(SELECT MIN(ROWID) FROM EMP)
UNION ALL
SELECT * FROM EMP WHERE ROWID IN(SELECT MAX(ROWID) FROM EMP);

List out the components of logical database structure of oracle database.

1011

---

How to load data from external tables to regular tables?

1041

---

What is partitioned table in Oracle?

1168

---

What is oracle analytical function?

1111

---

What is using clause and give example?

1017

---

Explain implicit cursor.

1001

---

What happens if you use a wrong connect identifier?

1037

---

material view and view disadvantages?

1049

---

How to define a variable of a specific record type?

1054

---

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

1738

---

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.

2064

---

Please explain drop constraint oracle?

1081

---

How to write date and time interval literals in oracle?

1015

---

What is a trigger and what are its types?

1199

---

How to select an oracle system id (sid)?

1047

---