Answer / Arvind Pandey

Performance tuning a database involves optimizing its hardware and software configurations to improve its speed and efficiency. This can include indexing tables, normalizing data, optimizing queries, using stored procedures, caching frequently accessed data, configuring hardware resources such as memory, CPU, and disk I/O, and monitoring database performance metrics.

dear all,Greetings of the day.. i have a small query plz rply if u knw.. i have done MBA Hr and B.sc microbiology. i am very much interested in it industry,so i am planing to go with oracle HRMS module,can it be work out??

1 Answers  

---

State at least four kinds of indexing?

1 Answers   Amazon, iNautix,

---

What do you understand by ‘database’?

1 Answers  

---

Describe and contrast sql and qbe.

1 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

1 Answers   Wipro,

---

10 How to Handle Data Migration Between Different Databases?

1 Answers  

---

How to connect Silverlight application to database?

1 Answers  

---

Define the relationship between ‘view’ and ‘data independence’.

1 Answers  

---

How to stop superserver service on linux using only firebird tools?

1 Answers  

---

where a Database Procedure is stored ?

1 Answers  

---

What is normalization in dbms?

1 Answers  

---

What do you understand by data independence? What are its two types?

1 Answers  

---