Answer / reddibasha

Transaction is a Set of DML operations with Commit /
Rollback. In SQL, transaction starts with DML command
(Except SELECT) and ends with Commit / Rollback(Implicit /
Explicit).

Answer / pavan_1981

set of related dml operations to perform a task are called
a transaction.

Answer / dawood

It starts with a first executable statement and ends when
commit or rollback statement occurs.

Answer / aravind

Transaction is a logical unit of work that comprises of one
or more sql statements.

Answer / ashok

All the DML operations between two COMMIT points can be called as a Transaction and Oracle server handles this as a single unit

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

Which are the different character-manipulation functions in sql?

0 Answers  

What is difference between procedure and trigger?

0 Answers  

What sql database should I use?

0 Answers  

What is the difference between instead of trigger and after trigger?

0 Answers  

What steps server process has to take to execute an update statement?

0 Answers  

Is it possible to pass parameters to triggers?

0 Answers  

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

Explain what is dbms?

0 Answers