subject

Because business is growing and the movie stock is increasing at more movie rentals, the manager wants to do more inventory evaluations. one item of interest is any movie with a total stock value of $75 or more. the manager wants to focus on the revenue these movies are generating to make sure the stock level is warranted. to make these stock queries more efficient, the application team decides to add a column named stk_flag to the mm_movie table that stores an asterisk (*) if the stock value is $75 or more. otherwise, the value should be null. add the column and create an anonymous block containing a cursor for loop to perform this task. the company plans to run this program monthly to update the stk_flag column before the inventory evaluation

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. a company wants to use online methods to target more customers. it decides to conduct a market research by collecting the data of a few customers with their consent. they want to track data of the sites that their customers frequently visit. which software can the company? a. spyware b. bots c. adware d. trojan horse e. rootkits
Answers: 1
question
Computers and Technology, 23.06.2019 15:30
The song about casey jones a railroad engineer who gives his life on the job would most likely gall under the folk song category of? a-work song b-nonsense song c-religious song d-ballad
Answers: 1
question
Computers and Technology, 23.06.2019 16:30
If i wanted to include a built-in calendar in a document, what option could i select? draw table insert table insert chart quick tables
Answers: 1
question
Computers and Technology, 24.06.2019 05:30
How do i get rid of my member ship for
Answers: 2
You know the right answer?
Because business is growing and the movie stock is increasing at more movie rentals, the manager wan...
Questions
question
Spanish, 09.07.2019 14:40
question
Mathematics, 09.07.2019 14:40
question
Mathematics, 09.07.2019 14:40
Questions on the website: 13722363