Which statement is true regarding transactions? (Choose all that apply.)
A.
A transaction can consist only of a set of DML and DDL statements.
B.
A part or an entire transaction can be undone by using ROLLBACK command.
C.
A transaction consists of a set of DML or DCL statements.
D.
A part or an entire transaction can be made permanent with a COMMIT.
E.
A transaction can consist of only a set of queries or DML or DDL statements.
Why D is wrong? Commit make a transaction permanent.
B , C are correct
hi bina,
But a part of transaction alone cannot get committed.( savepoint wont work with commit;)
Thanks manjusha…
“COMMIT” Marks the end of a successful implicit or explicit transaction.
If a part of transacation gets commited then that transaction ends as savepoints cannot be used with commit .(when a commit is used then the all savepoints gets deleted).
C is wrong.
http://docs.oracle.com/cd/E11882_01/server.112/e25789/transact.htm#CNCPT037
A database transaction consists of one or more statements. Specifically, a transaction consists of one of the following:
One or more data manipulation language (DML) statements that together constitute an atomic change to the database
One data definition language (DDL) statement
A transaction has a beginning and an end.
Then..the answer is B, E?
The asnwer is B e D.
E is wrong bcoz the sentence says only..
a transaction can consist of DML,DCL,DDL along with transaction control statements(commit,rollback,savepoint).DDL and DCL are themselves transactions.
A transaction consist of DML statements that represents a change to the data, one DCL or one DDL statement. A transaction finishes when a commit or rollback is issued, when a DDL or DCL statement is executed (implicit commit), when the system crashes (automatic rollback).
Below you will uncover the link to some web sites that we consider you must visit.
we like to honor lots of other net internet sites around the web, even when they arent linked to us, by linking to them. Below are some webpages worth checking out
Here is a great Weblog You might Locate Fascinating that we Encourage You
Here are a number of the websites we recommend for our visitors
although websites we backlink to beneath are considerably not related to ours, we really feel they are basically worth a go through, so have a look
usually posts some pretty fascinating stuff like this. If youre new to this site
we came across a cool web page that you could possibly love. Take a appear if you want
please take a look at the internet sites we comply with, like this 1, because it represents our picks in the web
very few sites that transpire to become comprehensive below, from our point of view are undoubtedly very well really worth checking out
the time to read or check out the content or web-sites we’ve linked to beneath the
Every after in a though we choose blogs that we study. Listed beneath would be the most recent web sites that we pick
very few web-sites that transpire to be detailed below, from our point of view are undoubtedly well worth checking out
below you will discover the link to some internet sites that we consider it is best to visit
Sites of interest we’ve a link to
please visit the web sites we adhere to, including this one, as it represents our picks through the web
very handful of web-sites that take place to be comprehensive below, from our point of view are undoubtedly well really worth checking out
usually posts some pretty interesting stuff like this. If you are new to this site
very handful of sites that come about to become in depth below, from our point of view are undoubtedly well worth checking out
Sites of interest we have a link to
please visit the web-sites we comply with, including this one, as it represents our picks through the web
one of our guests recently recommended the following website