This topic contains a solution. Click here to go to the answer

Author Question: Count function does which of the following? A) Returns the number of values in the column for the ... (Read 28 times)

jlmhmf

  • Hero Member
  • *****
  • Posts: 552
Count function does which of the following?
 
  A) Returns the number of values in the column for the selected rows
  B) Returns the highest value in the column for the selected rows
  C) Returns the total of the values in the column for the selected rows
  D) Returns the average of the values in the column for the selected rows

Question 2

In Oracle, the statement used to retrieve all the jobs with jobid greater than 5 and less than 8,
  displaying only jobids and associated dates, would be which of the following?
 
  A) Select jobid, date From Job Where jobid 5 and 8
  B) Select jobid, date From Job Where jobid >5 And <8
  C) Select jobid, date From Job Where jobid >=5 and <=8
  D) Select jobid, date From Job Where jobid between 5 and 8



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

jxjsniuniu

  • Sr. Member
  • ****
  • Posts: 343
Answer to Question 1

A

Answer to Question 2

B




jlmhmf

  • Member
  • Posts: 552
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


patma1981

  • Member
  • Posts: 292
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

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?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

For a complete list of videos, visit our video library