subject

Q.6. INSERT, DELETE and UPDATE Write the following database modifications in SQL. a) Using two INSERT statements, store in the database the fact that PC model 1100 is made by manufacturer C, has speed 3.2, RAM 1024, hard disk 180, and sells for $2499. b) Delete all PC ’s with less than 100 gigabytes of hard disk. c) Delete all laptops made by a manufacturer that doesn’t make printers. d) Manufacturer A buys manufacturer B. Change all products made by B so they are now made by A. e) For each PC, double the amount of RAM and add 60 gigabytes to the amount of hard disk. (Remember that several attributes can be changed by one UPDATE statement.)

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 14:40
You begin your first day of responsibilities by examining the recent is security breach at gearup to get ideas for safeguards you will take. at gearup, criminals accessed the company's improperly-secured wireless system and stole customers' credit card information as well as employee social security numbers. what kind of computer crime did gearup face?
Answers: 3
question
Computers and Technology, 22.06.2019 16:30
What type of file does a cookie place on web site visitors' computers so that web site managers can customize their sites to their visitors' preferences?
Answers: 1
question
Computers and Technology, 23.06.2019 16:00
What is the biggest difference between section breaks and regular page breaks? section breaks are more difficult to add than page breaks. section breaks make it easier for you to view the document as an outline. section breaks allow you to have areas of the document with different formatting. section breaks are smaller than regular page breaks.
Answers: 2
question
Computers and Technology, 23.06.2019 17:00
The more powerful, 60 volt cables and the main power shut off on an hev are both colored orange
Answers: 1
You know the right answer?
Q.6. INSERT, DELETE and UPDATE Write the following database modifications in SQL. a) Using two INSER...
Questions
question
Mathematics, 15.03.2020 23:46
question
Mathematics, 15.03.2020 23:46
question
Mathematics, 15.03.2020 23:48