20. Which of the following statements are true of the HAVING clause? A) The HAVING clause...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
20. Which of the following statements are true of the HAVING clause? A) The HAVING clause can be used in any statement instead of the WHERE clause. B) The HAVING clause can restrict rows based on the values of aggregate functions. C) The HAVING clause must be accompanied by the GROUP BY clause. D) B and C E) A and B 21. The DROP TABLE tablename; command is used to remove a table from the database. A) TRUE B) FALSE 22. Which of the following symbols is used by ANSI SQL as a wildcard represent zero, one, or many characters? (underscore) B) # C) * D) % E) & (pound) (asterisk) (per cent) (ampersand) 23. If FirstName='John' and LastName='Smith', what will be the result of the following statement? Instr(Concat(Firstname, LastName),'S') A) John Smith' B) 'JohnSmith' C) 5 D) 'S' E) Nothing, this is an invalid SQL clause 24. The following SQL statement is an example of what? SELECT E.LastName AS Engineer, M.LastName AS Manager FROM Employee As E JOIN Employee As M ON E.MgrSSN= M.SSN A) Natural Join B) Self Join C) Subquery D) Outer Join 20. Which of the following statements are true of the HAVING clause? A) The HAVING clause can be used in any statement instead of the WHERE clause. B) The HAVING clause can restrict rows based on the values of aggregate functions. C) The HAVING clause must be accompanied by the GROUP BY clause. D) B and C E) A and B 21. The DROP TABLE tablename; command is used to remove a table from the database. A) TRUE B) FALSE 22. Which of the following symbols is used by ANSI SQL as a wildcard represent zero, one, or many characters? (underscore) B) # C) * D) % E) & (pound) (asterisk) (per cent) (ampersand) 23. If FirstName='John' and LastName='Smith', what will be the result of the following statement? Instr(Concat(Firstname, LastName),'S') A) John Smith' B) 'JohnSmith' C) 5 D) 'S' E) Nothing, this is an invalid SQL clause 24. The following SQL statement is an example of what? SELECT E.LastName AS Engineer, M.LastName AS Manager FROM Employee As E JOIN Employee As M ON E.MgrSSN= M.SSN A) Natural Join B) Self Join C) Subquery D) Outer Join
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below 20 Which of the following statements ar... View the full answer
Related Book For
Introduction to Probability
ISBN: 978-0716771098
1st edition
Authors: Mark Daniel Ward, Ellen Gundlach
Posted Date:
Students also viewed these programming questions
-
Which of the following statements are true about the efficient market hypothesis? a. It implies perfect forecasting ability. b. It implies that prices reflect all available information. c. It implies...
-
Which of the following statements are true of long-term investments? a. They can include investments in trading securities. b. They are always easily sold and therefore qualify as being marketable....
-
Which of the following statements are true regarding dividends? _____ 1. Cash and stock dividends reduce retained earnings. _____ 2. Dividends payable is recorded at the time a cash dividend is...
-
Rosa's employer has instituted a flexible benefits program. Rosa will use the plan to pay for her daughter's dental expenses and other medical expenses that are not covered by health insurance. Rosa...
-
Match each the following statements with the appropriate type of auditors report (each auditors report may be used once, more than once, or not at all): A. Adverse. D. Disclaimer. Q. Qualified. S....
-
Brandon Computer Timeshare Company entered into the following transactions during May 2010. 1. Purchased computer terminals for $20,000 from Digital Equipment on account. 2. Paid $4,000 cash for May...
-
Nationwide Insurance developed a program to recruit new insurance agents by offering planning, training, and start-up financing to build self-sustaining agencies. These new agents would be...
-
At May 31, 2014, the accounts of Mantle Company show the following. 1. May 1 inventoriesfinished goods $12,600, work in process $14,700, and raw materials $8,200. 2. May 31 inventoriesfinished goods...
-
(1) Write a MATLAB script to find area using the Simpson's 3/8 rule. The code should perform all checks on the number of data points required for application of the rule assuming equally spaced data....
-
Assignment Problem Twenty-One - 4 (Regular GST Return) Lotor Inc. (Lotor) is a Canadian controlled private corporation (CCPC) that was incorporated in Alberta in 2012. Lotor operates exclusively...
-
Give an example of a public good that the government provides. Explain why the provision of this good is not left to the free market.
-
Draw the voltage-current characteristics curves of tunnel diode and hence describe its operation
-
I. Josh was driving 70 miles per hour on a windy road late at night in Syracuse, New York. The speed limit on the road was 30 miles per hour. It had rained throughout the day and the road was quite...
-
buyer purchased a home with a closing date of June 16. The taxes were paid for the year on Jan 1. If the taxes for the year are $3,000 and the prorations are based on a 360 day year, for how much...
-
A small firm builds two types of products. Type A requires 20 minutes on threading machine, 10 minutes on slotting machine and 7.5 minutes of craftsman time. Type B requires 10 minutes on threading...
-
State three methods of turning on an SCR
-
If the WACC of a company is 11.80%, the risk free is 5%, market risk premium is 10% with a beta for the stock of 1 and the overall cost of debt for the company is 7%. How much is the proportion of...
-
A summary of changes in Pen Corporation's Investment in Sam account from January 1, 2011, to December 31, 2013, follows (in thousands): ADDITIONAL INFORMATION 1. Pen acquired its 80 percent interest...
-
Chris tries to throw a ball of paper in the wastebasket behind his back (without looking). He estimates that his chance of success each time, regardless of the outcome of the other attempts, is 1/3....
-
A group of scientists is testing the learning ability of monkeys. They want to see if monkeys have any language preferences. They acquire a monkey that has lived its entire life in Moscow, and they...
-
At a restaurant that sells appetizers: 8% of the appetizers cost $1 each, 20% of the appetizers cost $2 each, 32% of the appetizers cost $3 each, 40% of the appetizers cost $4 each. An appetizer...
-
Which of the following is not an inherent part of Statement on Auditing Standards, No. 99/113? 1. Greater scrutiny of the chief executive and chief financial officers personal financial condition 2....
-
Which of the following statements best describes corporate governance with respect to fraud? 1. Auditors are primarily responsible for the detection of fraud, the Board of Directors for the...
-
Which of the following is not a reason that the prevention and detection of fraud resulting from management override and collusion presents a significant challenge for the antifraud community? 1....
Study smarter with the SolutionInn App