Answer / suraj

select deptno,trunc(avg(sal))as avg from emp group by deptno;

Answer / naresh

select avg(sal) from emp group by deptno;

What is file manager?

0 Answers  

---

When connection to database is failed, Which exception will be thrown?

0 Answers   MCN Solutions,

---

What are different relationships existing in database?

0 Answers  

---

What is Log Switch ?

2 Answers  

---

I want to export the data date to date from oracle database then what can i do?

0 Answers  

---

---

What is database management system(dbms) and why it is used?

0 Answers  

---

is it sufficient to normalize a database up to 3NF?

4 Answers  

---

Explain 5nf?

0 Answers  

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

---

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

1 Answers   Choice Solutions,

---

What is an entity-relationship model?

0 Answers  

---

What is index hunting and how does it help in improving query performance?

0 Answers  

---