Q2- Write SQL commands for the following: 1. 2. List all details from the cars table...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q2- Write SQL commands for the following: 1. 2. List all details from the cars table for cars made before the year 2020.(3 points) Time left 0:49:01 Update table cars, Change type for car 90092 to SUV. (3 points) 3. Find the car brand title and owner name and owner address for owners that has the letter 'F' in their name. (4 points) 4. Retrieve records of cars that has owners address in Tullkerm and his name starts with 'A'. (3 points) 5. Write pl/sql code to calculate the insurance amount for each car and print it Insurance amount = 5% of the car value if the car value >100000 and 3% if the care value <100000.(4 points) 6. write pl/sql code to set maintenance status of maintenance table to "done" if the date is earlier than 01-feb-23 and "working" if the date is after 01-Apr-23 other values should be "finished".(4 points) 7. Using JDBC write a Java Application that inserts the values the value to Cars table with Q2- Write SQL commands for the following: 1. 2. List all details from the cars table for cars made before the year 2020.(3 points) Time left 0:49:01 Update table cars, Change type for car 90092 to SUV. (3 points) 3. Find the car brand title and owner name and owner address for owners that has the letter 'F' in their name. (4 points) 4. Retrieve records of cars that has owners address in Tullkerm and his name starts with 'A'. (3 points) 5. Write pl/sql code to calculate the insurance amount for each car and print it Insurance amount = 5% of the car value if the car value >100000 and 3% if the care value <100000.(4 points) 6. write pl/sql code to set maintenance status of maintenance table to "done" if the date is earlier than 01-feb-23 and "working" if the date is after 01-Apr-23 other values should be "finished".(4 points) 7. Using JDBC write a Java Application that inserts the values the value to Cars table with
Expert Answer:
Answer rating: 100% (QA)
The image contains a set of questions that require writing SQL and PLSQL commands Here are the SQL statements and PLSQL blocks that correspond to the ... View the full 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 programming questions
-
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...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Common structural steel can be represented on drawings using a letter, immediately followed by a number, then another number (for example, S14x30). The two numbers for a steel member W16x60 designate...
-
1. What is the class width? What are the approximate lower and upper class limits of the first class? 2. What is a reasonable explanation for the gap between the group of people with heights between...
-
Dr. Linda Stern and her colleagues recruited 132 obese adults at the Philadelphia Veterans Affairs Medical Center in Pennsylvania. Half the participants were randomly assigned to a low-carbohydrate...
-
After the positrons were annihilated, the energy density of the universe was dominated by the photons and the neutrinos. Show that the energy density in that era was given by \(u_{\text {total...
-
The stockholders' equity accounts of Castle Corporation on January 1, 2015, were as follows. Preferred Stock (8%, $50 par, cumulative, 10,000 shares authorized) ....$ 400,000 Common Stock ($1 stated...
-
Explain how the relative prices of rugs and robots in autarky compare with the relative prices when Canada and India start to trade? In your answer explain which country will export/import which...
-
Assume the same information for Turcotte as in Problem 11-36. Working brake pads yield a profit of $25. If defective brake pads are identified before they are shipped, they can be fixed and sold as...
-
Suppose $t0 and $t1 are holding 0 and 1, respectively. When the program enters this segment, right before the program executes the instruction at p4L2, what will be the value in $t0? beq $t0, $t1,...
-
A new business analyst needs to be hired to work at the corporate headquarters of a retail firm. Jared and Amanda are managers in charge of the hiring decision. The candidates have been narrowed down...
-
Advocates of open-book management point to the advantages of getting employees to think like owners and to be motivated to make better decisions about how they do their work once they see how their...
-
Scora, Inc., is preparing its master budget for the quarter ending March 31. It sells a single product for $50 per unit. Budgeted sales for the next three months follow. Prepare a sales budget for...
-
Melodic Musical Sales, Inc. is located at 5500 Fourth Avenue, City, ST 98765. The corporation uses the calendar year and accrual basis for both book and tax purposes. It is engaged in the sale of...
-
A jury found defendant, Brent Kerrigan Lawson, guilty of petty theft for stealing a $20 hoodie from a Walmart store . . . On this appeal, defendant claims his conviction for petty theft must be...
-
Consider a linear, time-invariant system with impulse response 0.2 sin 5t h(t) = %3D Find the system output if the input is x(t) = cost + sin 6t. %3D
-
Match each of the key terms with the definition that best fits it. _______________ A record of the sequence of data entries and the date of those entries. Here are the key terms from the chapter. The...
-
Cedar Corporation has an S corporation election in effect. During the 2012 calendar tax year, the corporation had ordinary taxable income of $200,000, and on January 15, 2012, the corporation paid...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
John Williams (age 42) is a single taxpayer, and he lives at 1324 Forest Dr., Reno, NV 89501. His Social Security number is 555-94-9358. John's earnings and withholdings as the manager of a local...
-
The following are the financial statements for Nailsea plc for the years ended 30 June 2020 and 2021 There were no disposals of non-current assets in either year. Dividends were paid in 2020 and 2021...
-
The statements of financial position of Axis plc as at 31 December 2020 and 2021 and the income statement for the year ended 31 December 2021 were as follows: 1 During the year, plant (a non-current...
-
Consider the following: 1 A motor car manufacturer offers a three-year warranty on all cars that it produces. The warranty undertakes to make good any defects arising from the manufacturing process....
Study smarter with the SolutionInn App