When does a transaction complete?

When does a transaction complete? (Choose all that apply.)

A.
when a DELETE statement is executed

B.
when a ROLLBACK command is executed

C.
when a PL/SQL anonymous block is executed

D.
when a data definition language ( DDL) statement is executed

E.
when a TRUNCATE statement is executed after the pending transaction

Show Hint

← Previous question

Next question →

Leave a Reply 29

Sayed

Yes, B,D,E

Alvin2201

Why B: a ROLLBACK causes a transaction to END as it was never happened; not to COMPLETE.

John

It completes, but it doesn’t commit.

Agustin

These weblogs can be categorised as tutorials or ‘how-to’ kind of blogs. * Consider blog site templates, layouts, backgrounds, textures and skins from sites. To be a Fantastic blogger you’ll need to fully grasp that what you produce is always a reflection of your individual experiences.

http://mrb.murebest.com/index.php/component/k2/itemlist/user/168338

Alexander

You are becoming an AUTHORITY upon the subject and individuals begin flocking to your web page. Something that you are passionate about will crank out content ideas a lot easier to create considering that you are much less likely to lose interest. To begin with, it will really feel almost as though you’re running a blog to you, so you need to take time to communicate with others in your area of interest sector, so that people can get to know your internet site exists, where to find it and how to communicate with you.

http://basement-jump.co.uk/component/k2/itemlist/user/190215

Kennith Hovden

I adore this website – its so usefull and helpfull.|

http://www.l62ckqEmFp.com/l62ckqEmFp

Shela Ticknor

Excellent post. Keep posting such kind of information on your page.Im really impressed by it.Hello there, You’ve done a great job. I’ll certainly digg it andpersonally recommend to my friends. I am confidentthey will be benefited from this site.

http://www.98EtPViIQP.com/98EtPViIQP

Daniella Signorino

whoah this weblog is magnificent i like reading your posts. Stay up the good paintings! You already know, a lot of individuals are hunting round for this info, you could help them greatly.

http://www.98EtPViIQP.com/98EtPViIQP

Jesse Bankard

Thanks for the share. As my mom used to say “Enjoy life. There’s plenty of time to be dead” 🙂

https://fatanergana.wordpress.com/

moving house sydney

Thank you for writing about this. Feeling enlightened!

https://www.youtube.com/watch?v=VY0wGLAm_4M

Christie Romprey

I believe that is one of the most important information for me. And i am happy reading your article. But wanna remark on few normal things, The website style is great, the articles is truly nice : D. Just right job, cheers|

http://www.lFFRVNtVxT.com/lFFRVNtVxT

meetic opiniones

Blog se trasladó a cabo en cromo

http://www.opinionesdating.com/meetic-opiniones/

Google

Just beneath, are quite a few totally not associated web pages to ours, having said that, they’re surely worth going over.

Youtube Miracle Pianist Official Page

check beneath, are some entirely unrelated internet sites to ours, however, they may be most trustworthy sources that we use

glass coasters

the time to read or go to the material or websites we’ve linked to beneath the

budget

Here are several of the web pages we advocate for our visitors

Computer Repair NJ

very couple of internet websites that happen to become comprehensive beneath, from our point of view are undoubtedly effectively worth checking out

プラセンタ

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

customer service jobs from home

The details mentioned inside the article are a number of the very best readily available

Solar Panels

one of our visitors a short while ago advised the following website

1000 Thread count sheets

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

Nanette Rilling

Thank you for sharing your great website.|

http://www.eVg3BTNlyH.com/eVg3BTNlyH

Shanon Amsdell

Thank you for any other informative website. Where else may just I get that type of information written in such an ideal way? I have a venture that I’m just now running on, and I have been at the glance out for such info.

http://www.JUrRU0Bzxu.com/JUrRU0Bzxu