Which of the following would be the correct syntax for a WHERE clause to return all the NULL values in the CustomerPhone column?
A) WHERE CustomerPhone=NULL
B) WHERE CustomerPhone < NULL
C) WHERE CustomerPhone IS NULL
D) WHERE CustomerPhone IS NOT NULL
C
You might also like to view...
Because of the frequency with which world competition and information technology alter marketplace conditions, a company's ________ may have to be done closer to every 1 or 2 years than every 5.
A. management planning B. strategic planning C. tactical planning D. operational planning E. implementation planning
Fastlane Company has 50,000 shares of common stock and 20,000 shares of preferred stock outstanding. There was no change in the number of common or preferred shares outstanding during the year. Preferred stockholders received dividends this year totaling $120,000. Common stockholders received dividends totaling $200,000. If the dividend payout ratio for the year was 80%, then the net income was:
A) $400,000 B) $370,000 C) $160,000 D) $250,000
On a balance sheet for a merchandiser, Merchandise Inventory is listed as a(n) ________
A) current asset B) current liability C) expense D) revenue
Norma has been given the responsibility of determining the advertising appropriation for her firm's newest marketing campaign. At first she thinks that determining the advertising objectives and breaking them into tasks is the best way. However, Norma notices that past sales have been relatively constant, she multiplies the firm's past sales by a standard percentage based on what her firm usually spends on advertising. Norma is using the ________________ approach. The problem of this approach is that it assumes _________________________.
A. objective-and-task; the effort required is minimal B. objective-and-task; advertising creates sales C. percent-of-sales; advertising creates sales D. objective-and-task; sales create advertising E. percent-of-sales; sales create advertising