Answer / mahesh

ans 1 -

select *
from (
select rownum num , empno, ename
from emp
)
where num between 2 and 5

------------------

we can also use row_number function

what are the differences you find when working with oracle 91 and sql server 2005?

1 Answers   Choice Solutions,

---

Define join and enlist its types.

0 Answers  

---

How data are stored in database?

0 Answers  

---

Can files be stored in a database?

0 Answers  

---

what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

0 Answers   NIIT, TCS,

---

---

Define identity and uniqueidentifier property of column?

0 Answers  

---

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

0 Answers   Wipro,

---

Explain the Normalized Relations?

0 Answers  

---

What is the importance of database in an organization?

0 Answers  

---

What is data model example?

0 Answers  

---

I have a table which has lot of inserts, is it a good database design to create indexes on that table?

0 Answers  

---

What are the four components of a database system?

0 Answers  

---