COMPUTERS AND TECHNOLOGY HIGH SCHOOL

"Your supervisor has asked you to modify the AMOUNT column in the ORDERS table. He wants the column to be configured to accept a default value of 250. The table contains data that you need to keep. Which statement should you issue to accomplish this task?"

Answers

Answer 1
Answer:

Answer:

ALTER TABLE orders

MODIFY (amount DEFAULT 250)

Explanation:

  • ALTER TABLE statement is used to modify "amount" column in the existing "orders" table  
  • MODIFY (amount DEFAULT 250) is used to set the default value 250 of the "amount" column.

Therefore if the supervisor wants the amount column to be configured to accept a default value of 250, then "ALTER TABLE orders MODIFY (amount DEFAULT 250) " statement should be issued.

Related Questions

Which part of the software hierarchy is working behind the scenes allowing programs to perform tasks?Current machine instruction Currently dispatched threads Dispatchable threads Waiting handlers
Given the declarations struct BrandInfo { string company; string model; }; struct DiskType { BrandInfo brand; float capacity; }; DiskType myDisk; what is the type of myDisk.brand?
You have a chart that shows 100 data points and you've circled the highest value. Which of the following are you using?
What type of malware is heavily dependent on a user in order to spread?
Which of the following enables users on different e-mail systems to exchange messages?

One problem with using e-mail is that ______. a. It can be perceived as being too casual b. It is never appropriate for business communication. c. It takes too long to write and send e-mails. d. None of the above

Answers

I personally feel that e-mail can be used for more business settings and as a more formal approach to things as opposed to a text, but option C seems to be more of an opinion.  I would go with C or D.

Two people, Alice and Bob are using the key sharing algorithm. They have chosen a clock size of 17 and a base of 5. Alice's private number is 4, while Bob's is 6. The first step in creating the shared key is for each party to generate a PPN based on their private number, the base and the clock size. Alice has already sent her PPN to Bob. She receives Bob's PPN, which is 2. Alice uses Bob's PPN (2), her private number (4), and the clock size (17) to calculate the shared key. What is it

Answers

Answer:

fsfsf

Explanation:

What is the difference between primary storage secondary storage and offline storage

Answers

. => Primary Storage – is a computer memory that connects directly to the central processing unit of CPU. It is also known as RAM or random access memory. This storage do not permanently stores data because this is a volatile kind of storage.
=> Secondary storage – this may refer to storage that is non-volatile. Some examples of this storage are hard drive, CD/DVD, Flash drive, etc
=> offline storage – also known as tertiary storage. This is not a very known storage, this includes jukeboxes and tape libraries.

Given an "out" string length 4, such as "<<>>", and a word, return a new string where the word is in the middle of the out string, e.g. "<>". Note: use str.substring(i, j) to extract the String starting at index i and going up to but not including index j.makeOutWord("<<>>", "Yay") → "<>"
makeOutWord("<<>>", "WooHoo") → "<>"
makeOutWord("[[]]", "word") → "[[word]]"

Answers

Answer:

The following are the answer to this question.

Explanation:

In the given code, a "makeOutWord and word" is already used to hold some value. In this code, we define a string method "makeOutWord" that accepts two string variables "out and the word" in its parameter.

Inside the method, a return keyword is used that uses the string variable "out and the word" with the "substring" method, this method is used to returns a new string from an old string value, and it also uses the "word" string variable for the return value.  

please find the attached file for code:

Final answer:

The function makeOutWord combines the 'out' string and the given word by using the substring method to separate the 'out' string into two parts, then inserting the given word in between. An example solution in Java is provided.

Explanation:

The goal of this problem is to create a new string, incorporating the original 'out' string and the given word. This can be achieved by utilizing the substring method in Java which allows us to extract part of a string. Given an 'out' string with length 4, such as '<<>>', and a word, the task is to return a new string where the word is in the middle of the 'out' string.

An example solution in Java would be as follows:

public String makeOutWord(String out, String word) { return out.substring(0, 2) + word + out.substring(2, 4);}

With this function, we take the first two characters from the 'out' string, then append the word, then add the last two characters of the 'out' string. So, makeOutWord("<<>>", "Yay") would yield "<>".

Learn more about String Manipulation here:

brainly.com/question/35897567

#SPJ3

James would like to send a document he has saved on the hard drive to coworkers and Ireland Brazil and India. These coworkers have Internet access. He should

Answers

email the document to them ?

Answer:

he needs to fax them

Explanation:

Zoey has brought her computer in for servicing. When she dropped off her computer, she mentioned that her computer will sometimes spontaneously reboot and freezes occasionally.Which of the following is the MOST likely cause?(A) Bad network card(B) Overheated CPU(C) Failed UPS(D) Failing Drive

Answers

Answer:

Option B

Explanation:

There is a built in functionality in every OS ( including windows and IOS ) that reboots the system whenever the temperature of Processor reaches to a certain limit. This functionality is to save the hardware of computer so that nothing of it will burn by rebooting the PC which in this specific case will start the fans of computer to run with rather high speed to take out as much heat as possible.

Option A is rejected because Bad network card will result problem in using the network and will not reboot the system.

Option C will make the PC UPS to not to start the computer rather than rebooting it.

Option D will result in no windows start functionality rather than rebooting it.
Other Questions
The technical relationship between inputs and outputs, which is needed to understand the difference between the short run and the long run, is called technical efficiency. economic efficiency. a production function. a time and motion study. supply and demand.
Some client-server database systems just have two parts (the clients and the server), others have at least one middle component between the client and the server; these systems are referred to as n-tier database systems.A. TrueB. False
Design an information flyer about South Africa's driving regulations that will be given to the contestant of The Awesome Race 2016 who will be driving the 4by4 vehicles. include SIX facts on the flyer.
In the Mouse Properties window, you can_____. A. change the color of the pointer. B. specify new tasks for the mouse to perform. C. adjust the mouse's double-click speed. D. increase the mouse pad's size.