Answer / Ravinder Kumar Jawalia

A database transaction refers to a logical unit of work that is executed within a database system. It is an atomic operation, meaning it either completes entirely or not at all. Transactions help ensure data consistency by allowing multiple operations to be grouped together and executed as a single operation. This way, if any error occurs during the execution of the transaction, the entire transaction can be rolled back to maintain the integrity of the database.

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

---

List different type of expressions with the example.

1 Answers  

---

how to decrement dates by 1 in mysql? : Sql dba

1 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

What is data modelling in sql?

1 Answers  

---

Why use truncate instead of delete?

1 Answers  

---

what is the difference between truncate and delete statement? : Transact sql

1 Answers  

---

How do temporal tables work?

1 Answers  

---

Where do we use pl sql?

1 Answers  

---

Explain foreign key in sql?

1 Answers  

---

Mention what is the use of function "module procedure" in pl/sql?

1 Answers  

---

What are local and global Indexes and where they are useful.

1 Answers  

---