Can group functions be mixed with non-group selection fields?

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

What are the components of Logical database structure of ORACLE database?

4 Answers  

---

How to use subqueries in the from clause in oracle?

0 Answers  

---

Difference between varchar and varchar2 data types?

0 Answers  

---

---

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,

---

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

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

0 Answers  

---

DBMS vs. RDBMS

2 Answers   TCS,

---

How to get execution statistics reports on query statements?

0 Answers  

---

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

---