Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the SQL shown in the figure and choose the correct statement(s) below BEGIN INSERT INTO invoices VALUES (115, 34, 'ZXA-080, '30-AUG-06', 14092.59, 0, 0,

image text in transcribed

Consider the SQL shown in the figure and choose the correct statement(s) below BEGIN INSERT INTO invoices VALUES (115, 34, 'ZXA-080, '30-AUG-06', 14092.59, 0, 0, 3, '30-SEP-06', NULL); INSERT INTO invoice_line_items VALUES (115, 1,160, 4447.23, 'HW upgrade'); INSERT INTO invoice_line_items VALUES (115, 2, 167, 9645.36, 'OS upgrade); COMMIT EXCEPTION WHEN OTHERS THEN ROLLBACK; END There is one transaction in the SQL shown. There are three transactions in the SQL shown. ? If the first INSERT statement fails then the transaction lets the other two statements succeed in order not to hamper table updates. ? If any one or more of the INSERT statements fail, then none of the others will permanently alter the data in the table either

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

More Books

Students also viewed these Databases questions

Question

=+5. How might managers address any abuse of sick leave?

Answered: 1 week ago

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago