Which statement is true regarding transactions?

Which statement is true regarding transactions? (Choose all that apply.)

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.



Leave a Reply 30

Your email address will not be published. Required fields are marked *


bina

bina

Why D is wrong? Commit make a transaction permanent.

Sunil

Sunil

B , C are correct

MANJUSHA

MANJUSHA

hi bina,

But a part of transaction alone cannot get committed.( savepoint wont work with commit;)

Ritam Tiwari

Ritam Tiwari

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).

hwfurlan

hwfurlan

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.

hamozin

hamozin

Then..the answer is B, E?

Alexandre

Alexandre

The asnwer is B e D.

Sri

Sri

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.

ejossue

ejossue

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).

Google

Google

Below you will uncover the link to some web sites that we consider you must visit.

black magic

black magic

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

create app

create app

Here is a great Weblog You might Locate Fascinating that we Encourage You

istikhara online

istikhara online

Here are a number of the websites we recommend for our visitors

satta matka

satta matka

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

Mentoring

Mentoring

usually posts some pretty fascinating stuff like this. If youre new to this site

Convert your video files here

Convert your video files here

we came across a cool web page that you could possibly love. Take a appear if you want

new

new

please take a look at the internet sites we comply with, like this 1, because it represents our picks in the web

MiraclePianist

MiraclePianist

very few sites that transpire to become comprehensive below, from our point of view are undoubtedly very well really worth checking out

Play Games Free Online

Play Games Free Online

the time to read or check out the content or web-sites we’ve linked to beneath the

how to make an app for free

how to make an app for free

Every after in a though we choose blogs that we study. Listed beneath would be the most recent web sites that we pick

garage door buy

garage door buy

very few web-sites that transpire to be detailed below, from our point of view are undoubtedly well worth checking out

Hawaiian Lava Veneers

Hawaiian Lava Veneers

below you will discover the link to some internet sites that we consider it is best to visit

Adoption Laws

Adoption Laws

Sites of interest we’ve a link to

online istikhara

online istikhara

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

worldwide chat rooms

worldwide chat rooms

usually posts some pretty interesting stuff like this. If you are new to this site

Brain

Brain

very handful of sites that come about to become in depth below, from our point of view are undoubtedly well worth checking out

viagra

viagra

Sites of interest we have a link to

IT Support

IT Support

please visit the web-sites we comply with, including this one, as it represents our picks through the web

Diy Home Energy System Review

Diy Home Energy System Review

one of our guests recently recommended the following website