Answer / Shrikant Gupta

There are four main types of SQL joins: INNER JOIN (combines rows from two tables where there is a match between columns), OUTER JOIN (includes all rows from at least one table, even if there's no match between columns), LEFT JOIN (includes all rows from the left table and matches rows from the right table), and RIGHT JOIN (includes all rows from the right table and matches rows from the left table).

Describe the difference between data and database administration.

1 Answers  

---

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

1 Answers   DELL,

---

What is the use of ANALYSE ( Ver 7) option in EXP command ?

1 Answers  

---

If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  

---

Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.

1 Answers  

---

Why normalisation is required?

1 Answers  

---

Where does the LGWR process writes information?

1 Answers  

---

Which database is best for large data?

1 Answers  

---

If you need to refresh a website page every time a record is updated in database, how would you do it?

1 Answers   MindCracker,

---

Define denormalization.

1 Answers  

---

How to retrive a single data from a database

1 Answers   MCN Solutions,

---

What is database write application of database?

1 Answers  

---