Answer / Km Divya Budiyal

Database join is a SQL operation that combines rows from two or more tables based on a related column between them. It allows for retrieving and analyzing data from multiple tables as if they were a single table. There are various types of joins, such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

1 Answers  

---

What are the different types of languages that are available in the dbms?

1 Answers  

---

what is the difference between two and three-tier architectures?

1 Answers  

---

Describe a subquery.

1 Answers  

---

What are the ACID Properties in a Database and Why are They Important?

1 Answers  

---

How the status of the Rollback segment can be viewed ?

1 Answers  

---

What is n tier architecture in dbms?

1 Answers  

---

What are Stored Procedures and When would we Use Them?

1 Answers  

---

List few disadvantages of file processing system.

1 Answers  

---

What are the drawback of rdbms?

1 Answers  

---

Describe the purposes and advantages stored procedure?

1 Answers  

---

What are the two major subsystems of system r?

1 Answers  

---