1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
galben [10]
3 years ago
8

Write SQL statements for the following: 1. 2. 3. Change the column Z of a table XYZ to now acceptdefault value 9999 Delete a tab

le from the database Delete column Z from the table XYZ
Computers and Technology
1 answer:
Ad libitum [116K]3 years ago
8 0

Answer:

1.In the first query the column Z of table xyz wil change and set to its  default value so we use alter command .

Syntax :ALTER TABLE TABLENAME  ALTER COLUMN NAME  SET DEFAULT VALUE

So SQL query is :

ALTER TABLE  XYZ  ALTER Z SET DEFAULT  9999  ;

This query will Change the column Z of a table XYZ to acceptdefault value 9999 .

2.In the second query we delete a table from database so we use DROP    command .

Syntax :DROP TABLE TABLENAME;

So SQL query is :DROP TABLE XYZ;

This query will delete the table from database.

3.In the last query we have to change the column Z from table again we      use alter command .

Syntax:ALTER TABLE TABLENAME  DROP  COLUMN  COLUMNNAME  ;

So SQL query is :

ALTER TABLE XYZ DROP COLUMN Z;

This query will delete column Z from the table XYZ.

You might be interested in
Power brakes:
IgorLugansk [536]
The answer is B becausePower brakes are a system of hydraulics used to slow down or stop most motor vehicles. It uses a combination of mechanical components to multiply the force applied to the brake pedal by the driver into enough force to actuate thebrakes and stop a vehicle that can weigh several tons.
5 0
3 years ago
Read 2 more answers
Microsoft word's spell checker?
vekshin1
The answer to the given picture is - Microsoft word's spell checker only recognizes very common words. Microsoft word has it's own dictionary which will be compared to the texts on your document. If they see an unfamiliar word they will underline it with red. Anyways you can add your own words and names to the custom dictionary.
8 0
3 years ago
How are water resources and air adversely affected by environmental degardation?​
Nonamiya [84]

Answer:

Environmental degradation is one of the ten threats officially cautioned by the High-level Panel on Threats, Challenges and Change of the United Nations. The United Nations International Strategy for Disaster Reduction defines environmental degradation as "the reduction of the capacity of the environment to meet social and ecological objectives, and needs".[4] Environmental degradation comes in many types. When natural habitats are destroyed or natural resources are depleted, the environment is degraded. Efforts to counteract this problem include environmental protection and environmental resources management.

There are many examples of environmental degradation throughout the world. A recent example is the 2019 Amazon rainforest wildfires. The Amazon makes up 60% of all rainforests. It is the earth's lungs and with it getting destroyed is posing a huge threat to the environment and the whole world. The effects of the deforestation will pose major impacts on the world around us. The constant cutting down of trees is getting rid of our oxygen supply as well as the absorption of co2. With the continuation of deforestation we will have less available oxygen in the world which could have detrimental effects on human health. An alternate issue that results from this is the overconsumption and waste of the paper products that come from those trees. The waste it typically produces does not get recycled, therefore, immense amount of waste is created. An additional harmful result from this is the degradation of the soil. The constant deforestation causes the soil to become less nutrient which will make it harder to be used again.

Explanation:

Environmental degradation is one of the ten threats officially cautioned by the High-level Panel on Threats, Challenges and Change of the United Nations. The United Nations International Strategy for Disaster Reduction defines environmental degradation as "the reduction of the capacity of the environment to meet social and ecological objectives, and needs".[4] Environmental degradation comes in many types. When natural habitats are destroyed or natural resources are depleted, the environment is degraded. Efforts to counteract this problem include environmental protection and environmental resources management.

There are many examples of environmental degradation throughout the world. A recent example is the 2019 Amazon rainforest wildfires. The Amazon makes up 60% of all rainforests. It is the earth's lungs and with it getting destroyed is posing a huge threat to the environment and the whole world. The effects of the deforestation will pose major impacts on the world around us. The constant cutting down of trees is getting rid of our oxygen supply as well as the absorption of co2. With the continuation of deforestation we will have less available oxygen in the world which could have detrimental effects on human health. An alternate issue that results from this is the overconsumption and waste of the paper products that come from those trees. The waste it typically produces does not get recycled, therefore, immense amount of waste is created. An additional harmful result from this is the degradation of the soil. The constant deforestation causes the soil to become less nutrient which will make it harder to be used again.

4 0
3 years ago
Which network could NOT carry commercial traffic?
sattari [20]

ARPANET would not carry it

4 0
3 years ago
Which is the best response to receiving a threating text from a classmate
Yuri [45]

Answer:

send a threatening text in reply, then block the phone number block the phone number, then contact his phone service provider immediately delete the text, then report the incident to authorities ignore the message, then get a new cell phone number.

Explanation:

5 0
3 years ago
Read 2 more answers
Other questions:
  • Encryption relies on the use of _________to ensure that information is readable only by the intended recipient.
    5·1 answer
  • 4. An outline is most like which of the following? (1 point)
    14·1 answer
  • Browsing the web is one of the most common activities performed by individuals who use computers.
    12·1 answer
  • Renee is creating a multimedia presentation for a website that requires user interaction. Which multimedia type is Renee using?
    5·2 answers
  • Which of the following function headings arevalid? If they are invalid, explain why.
    12·1 answer
  • What device provides ports to allow a laptop to easily connect to a full-sized monitor, keyboard, ac power adapter, and other pe
    11·1 answer
  • Adrian wants to run a digital movie clip that his friend shared with him through email. His system has 2 GB of RAM and 20 GB of
    15·1 answer
  • Write a CashRegister class that can be used with the RetailItem class that you wrote in Chapter 6's Programming Challenge 4. The
    15·1 answer
  • Write a program that accepts a positive integer N as command-line argument, and outputs True if N is the square of some integer,
    13·1 answer
  • Explain how to add cell A1 and cell B3 in excel
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!