« previous next »

Author Question: In an SQL query, which built-in function is used to compute the number of rows in a table? A) AVG ... (Read 47 times)

jrubin

  • Hero Member
  • *****
  • Posts: 552
on: Jul 7, 2018
In an SQL query, which built-in function is used to compute the number of rows in a table?
 
  A) AVG
  B) COUNT
  C) MAX
  D) SUM

Question 2

Having to enter facts about two entities when we want to enter facts about only one is an example of ________.
 
  A) insertion anomaly
  B) update anomaly
  C) deletion anomaly
  D) normalization anomaly


iceage

  • Guest
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

A


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

Chromosome number is halved Chromosome number is halved
Hydration is essential to body function, especially engaged in strenuous activities Hydration is essential to body function, especially engaged in strenuous activities
Periodic Table Periodic Table
DOT placarding requirements: Table 1 materials must be placarded in any quantity, and Table 2 ... DOT placarding requirements: Table 1 materials must be placarded in any quantity, and Table 2 ...
Hepatic Acinus Model of Liver Function Hepatic Acinus Model of Liver Function
Calculus help: Find a cubic function f (x) = ax3 +bx2 +cx+d that has a local maximum value of 3 ... Calculus help: Find a cubic function f (x) = ax3 +bx2 +cx+d that has a local maximum value of 3 ...
Video: Green alga life cycle Animation

For a complete list of videos, visit our video library