Data Manipulation Language (DML) and Transactions Management: For any operation, if it doesn't work, then: 1....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data Manipulation Language (DML) and Transactions Management: For any operation, if it doesn't work, then: 1. write the command, 2. the error, and (not mandatory) 3. mention the reasons. 1. Insert the following rows to the bank table. (4 marks) Bank_id Street 1 12 13 11 122 Name Bank1 Bank1 Bank3 Bank4 Bank4 33 44 55 St1 St2 St3 St1 City City1 City2 City1 City2 2. Insert the following rows to the Account table. (4.5 marks) id Name Balance Creation_date Bank_id 1 11 1-2-1990 Account1 10 Account2 20 11 2-6-1998 Account3 10 3-5-1988 3 Account4 20 2-11-1992 2 Account5 -10 3 Account6 20 1-1-1970 PostCode 13 11 22 33 44 55 MobileNumber 0791234567 0787654321 0781234567 3. Save the changes to the database. (0.5 mark) 4. Double the balance of the accounts whose mobileNumber is not null. (1 mark) 5. Change the balance of Account1 to be the same as Account2. (1 mark) 6. Create a save point call it A. (0.5 mark) 7. Disable the primary key constraint of the account table, the a_pk constraint. (1 mark) 8. Change the name of street 'St1' to 'street1'. (1 mark) 9. Change the PostCode of City 1 to be 666. (1 mark) 10. Rollback to the created save point in question 6 (Please list the command even if it doesn't work). If you can't do that, then explain why. (1.5 marks) 11. Delete the rows of the bank table using the truncate statement (Please list the command even if it doesn't work). If you can't do that, then explain why. (1.5 marks) Data Manipulation Language (DML) and Transactions Management: For any operation, if it doesn't work, then: 1. write the command, 2. the error, and (not mandatory) 3. mention the reasons. 1. Insert the following rows to the bank table. (4 marks) Bank_id Street 1 12 13 11 122 Name Bank1 Bank1 Bank3 Bank4 Bank4 33 44 55 St1 St2 St3 St1 City City1 City2 City1 City2 2. Insert the following rows to the Account table. (4.5 marks) id Name Balance Creation_date Bank_id 1 11 1-2-1990 Account1 10 Account2 20 11 2-6-1998 Account3 10 3-5-1988 3 Account4 20 2-11-1992 2 Account5 -10 3 Account6 20 1-1-1970 PostCode 13 11 22 33 44 55 MobileNumber 0791234567 0787654321 0781234567 3. Save the changes to the database. (0.5 mark) 4. Double the balance of the accounts whose mobileNumber is not null. (1 mark) 5. Change the balance of Account1 to be the same as Account2. (1 mark) 6. Create a save point call it A. (0.5 mark) 7. Disable the primary key constraint of the account table, the a_pk constraint. (1 mark) 8. Change the name of street 'St1' to 'street1'. (1 mark) 9. Change the PostCode of City 1 to be 666. (1 mark) 10. Rollback to the created save point in question 6 (Please list the command even if it doesn't work). If you can't do that, then explain why. (1.5 marks) 11. Delete the rows of the bank table using the truncate statement (Please list the command even if it doesn't work). If you can't do that, then explain why. (1.5 marks)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
I have made payments $118 and another payment of $29.00 dollars on this account but when I went to view test is requesting more money for unlocks. Could some ne please speak to this issue.
-
Recently we at Nike have noticed that our competitors have been improving their digital marketing strategies within the past year, while our digital marketing strategies are doing stable, we need to...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Aussie Infonautics, Inc., produces handheld Windows CE¢-compatible organizers. Aussie Infonautics markets three different handheld models. PalmPro is a soupedup version for the executive on the...
-
Why would you expect an abnormally high growth to fade toward average growth for the economy in the long run?
-
Use the graph in the next column to answer the following questions. a. If the Fed does not take any policy action, what will be the level of real GDP and the price level in 2021? b. If the Fed wants...
-
Which of the following are integers? 1. -214 2. \(38 / 11\) 3. \(\sqrt{90}\) 4. \(\sqrt{121}\) 5. \(420 / 35\)
-
The following transactions of Oscar Landing occurred during 2016: Aug. 30 Landing is party to a patent infringement lawsuit of $220,000. Landing's attorney is certain it is remote that Landing will...
-
Levin Company is considering a project that has the following cash flow data. What is the project's IRR? Note that a project's projected IRR can be negative, in which case it will be rejected....
-
The G. Saussy Manufacturing company is putting out four new electronic components. Each of Saussy's four plants has the capacity to add one more product to its current line of electronic parts. The...
-
Kevin is involved in a conflict with his colleague at work. Instead of arguing, he prefers remaining silent. He avoids confrontational talk with his colleague. He feels that he would rather lose face...
-
Today you tell your broker to purchase a put option to sell an August guinea pig futures contract (300 guinea pigs) at $3.22 per pig. Your local basis for guinea pigs in August is $0.11 per pig. The...
-
Why is it important to maintain employee commitment and satisfaction to achieve established goals?
-
Ivanhoe Inc. had sales of $2,300,000 for the first quarter of 2022 (it sold 230,000 units). In making the sales, the company incurred the following costs and expenses. Variable Fixed Cost of goods...
-
In the Table below, the values found as a result of the sieving process of the A and B aggregates, which are made up of different groups, are given. Show whether the individual aggregates comply with...
-
Winnie Enterprises Ltd have an outstanding R1 000 par value bond, with 15 years to the maturity date. The bond pays a coupon at a rate of 6% per annum. Required: (i) (ii) (!!!) Calculate the value of...
-
Project S requires an initial outlay at t = 0 of $19,000, and its expected cash flows would be $4,000 per year for 5 years. Mutually exclusive Project L requires an initial outlay at t = 0 of...
-
Baxter, Inc., owns 90 percent of Wisconsin, Inc., and 20 percent of Cleveland Company. Wisconsin, in turn, holds 60 percent of Clevelands outstanding stock. No excess amortization resulted from these...
-
David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...
-
Mike sells his home to Jane on April 2, 2012. Jane pays the property taxes covering the full calendar year in October, which amount to $2,500. How much may Mike and Jane each deduct for property...
-
Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...
-
Explain the circumstances under which a person should choose a regular checking account, activity checking account, or interest-bearing checking account.
-
Explain at least three ways to reduce ATM fees charged to your account. Also describe the trade-offs involved in each action. Write About It Create a list with your explanations.
-
Bank X offers a checking account with a minimum balance of \($300\), but does not charge fees nor give interest. Bank Ys minimum balance is \($50\), but it charges a fee of \($25\) if you have more...
Study smarter with the SolutionInn App