Which of the following is not a valid SQL command? (Points : 2) UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500';

Computers and Technology

1 answer:

Volgvan3 years ago

6 0

Answer:

UPDATE acctmanager WHERE amid = 'J500';

Explanation:

The statement written above is not valid SQL statement because there is no SET after UPDATE. Update is always used with SET.If you are updating something then you need to specify the value with which that value should be replaced.

UPDATE acctmanager SET amname = UPPER(amname);

This statement does not contains WHERE clause but it will run all the values of amname column will get updated in the table acctmanager.

You might be interested in

When it comes to collecting and organizing prospect and account information, salespeople have a large variety of computer syste

OleMash [197]

Answer:

sales force automation systems

Explanation:

Based on the information provided within the question it can be said that in this scenario these are known as sales force automation systems (SFA). This type of system or software is used in order to automate various business tasks, including managing contacts, order processing, sales, inventory, etc. Which is why it is mostly used by the salespeople.

4 0

3 years ago

Given two input integers for an arrowhead and arrow body, print a right-facing arrow.

Zanzabum

Answer:

I don't know the language this is but here is something that will work for all lang

int num0 = 0;

int num1 = 0;

basically just print the ints in the right dimension

Explanation:

Sorry if I am wrong

I don't know much about this someone else's answer might be better than mine

3 0

3 years ago

A pointing device uses light to determine hand motion.

kirill [66]

The answer to this is Optical mouse.

The reason the answer is optical mouse is because the optical mouse is a computer mouse which uses a light source, typically a light-emitting diode, and a light detector, such as an array of photodiodes, to detect movement relative to a surface.

Hope this helped :)
have a great day

3 0

3 years ago

Define quality control

tangare [24]

Quality control is a system of maintaining standards in manufactured products by testing a sample of the output against the specification.

8 0

3 years ago

When a structure must be passed to a function, we can use pointers to constant data to get the performance of a call by ________

andriy [413]

Answer:

Reference value.

Explanation:

8 0

3 years ago