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
OlgaM077 [116]
3 years ago
11

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
Can i eat chicken and you shut
scoray [572]

Answer:

ofcccc whenn ?

3 0
3 years ago
Read 2 more answers
Pls help me pass my finals!!​
ale4655 [162]

Answer:

(a): power(2&-2)

The code is as follows:

<em>power = 2**-2</em>

<em>print(power)</em>

<em />

(b): Largest and smallest in a list

The code is as follows:

<em>num = [33,6,11,100,456,109,-4,366]</em>

<em>smallest= min(num)</em>

<em>largest= max(num)</em>

<em>print(smallest)</em>

<em>print(largest)</em>

<em />

(c): Loop in Python

(i) Loop are instructions that are repeated until a certain condition is met;

(ii) For loop, in python are used to iterate over a sequence or through a certain range;

The syntax is:

<em>for loop_element in range(iterating_range):</em>

The following is an illustration of for loop that iterates 5 times

<em>for i in range(5):</em>

Explanation:

(a): power(2&-2)

The ** is used to calculate power.

So, 2**-2 represents 2 raise to power -2

<em>power = 2**-2</em>

This prints the calculated power

<em>print(power)</em>

<em />

(b): Largest and smallest in a list

This initializes the list

<em>num = [33,6,11,100,456,109,-4,366]</em>

This calculates the smallest using min() function

<em>smallest= min(num)</em>

This calculates the largest using max() function

<em>largest= max(num)</em>

This prints the smallest and the largest

<em>print(smallest)</em>

<em>print(largest)</em>

<em />

(c): See answer section

3 0
3 years ago
Intellectual property rights protect people’s and organization’s ideas and other intellectual assets. However, in certain cases,
Katarina [22]

Answer:

negative effect

Explanation:

its right on edg

8 0
3 years ago
On the Audio Tools contextual tab, which tab will control how the audio file appears, if it appears, on the slide
MrMuchimi
B is the correct answer
5 0
3 years ago
Read 2 more answers
Please help...........​
Bond [772]

e because e am tired

7 0
3 years ago
Other questions:
  • Using the expected format, of putting key information where the reader can’t find it, is an example of?
    8·2 answers
  • Figuring out why your computer won't turn on falls under diagnosing.<br> A. True<br> B. False
    15·2 answers
  • What change does NOT need to be made to the above cover letter excerpt before sending it to an employer? a. Remove background co
    6·2 answers
  • In 2007, __________ Floridians died in alcohol-related collisions. A. 501B. 1,051C. 5,015D. 10,839
    8·1 answer
  • How do i add a header or footer to powerpoint presentation
    15·1 answer
  • What will Jason need to assemble a microcomputer and connect it to memory chips
    8·1 answer
  • We all had the unfortunate experience of seeing how computers can, at times, make life's journey about more difficult. This is e
    13·1 answer
  • What are the biggest problems facing the criminal justice system in the area of computer crime
    10·2 answers
  • Suppose the following sequence of bits arrives over a link:
    7·1 answer
  • What is the quickest way to change the format of a table?
    8·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!