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...
-
The wheel consists of a thin ring having a mass M 1 and four spokes made from slender rods, each having a mass M 2 . Determine the wheels moment of inertia about an axis perpendicular to the page and...
-
What is a method used to confirm accuracy of data entry? Explain in details.
-
Consider forecasting with the \(A R(1)\) model. a. Use the forecasting chain rule in equation (8.4) to show \[y_{T+k}-\widehat{y}_{T+k} \approx \varepsilon_{T+k}+\beta_{1}...
-
Data for Mortin Chip Company and its industry averages follow. a. Calculate the indicated ratios for Morton. b. Construct the extended Du Pont equation for both Morton and the industry. c. Outline...
-
A diet-conscious housewife wishes to ensure her family' daily intake of vitamins A, B and C does not fall below certain levels, say 24 units, 30 units and 18 units, respectively. For this she relies...
-
Loan payments of $1725 due today, $510 due in 75 days, and $655 due in 323 days are to be combined into a single payment to be made 115 days from now. What is that single payment if money is worth...
-
Spain is a small open economy and faces the real interest rate (r = 0.05) in the international bor- rowing market. For this question, assume that GNE = C. Ie, the country doesn't have government...
-
The following is a real-life example of an individual who did some learning from experience at work. Annabel Brown, an academic, was passed over for promotion in favour of afar less qualified male...
-
T his case looks at a researcher who was keen to investigate how to lead to bring about change in a democratic way. Kurt Lewin and his associates were keen to demonstrate the advantages of democratic...
-
Some federal government spending is said to be mandatory. What does this mean and how does it differ from discretionary spending?
-
In the following description of one companys culture, Schein (1990; 112) argues that it is possible for a group to hold conflicting values that manifest themselves in inconsistent behaviour while...
-
The following case study highlights some of the problems that may arise when implementing teamworking. StitchCo was a family-owned, single-brand company manufacturing garments for retail stores....
-
Final technical authority of a project lies with Select one: O a. Assistant Engineer O b. Executive Engineer O c. Superintending Engineer O d. Chief Engineer Oe. None of the above During the bidding...
-
The swap spread is the difference between the swap rate and the equivalent-maturity Treasury bond yield. Explain why a widening swap spread may be a signal of deteriorating economic conditions. Plot...
-
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...
-
What are a manager's resources?
-
What are the three levels of management?
-
What is the glass ceiling?
Study smarter with the SolutionInn App