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

jlmhmf · **on:** Jul 7, 2018

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