In Oracle, the statement used to display employee names together with job dates and times, for all ...

In Oracle, the statement used to display employee names together with job dates and times, for
  all jobs starting at 8 A.M., would be which of the following?
 
  A) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job
  On employee.ssn = job.ssn Where job.timeend = '8:00 AM'
  B) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job
  Where job.timestart = '8:00 AM'
  C) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job
  On employee.ssn = job.ssn Where job.timestart = '8:00 AM'
  D) Select employee.name, job.date, job.timestart, job.timeend From employee, job On
  employee.ssn = job.ssn Where job.timestart = '8:00 AM'

Q. 2

In Microsoft Access, the statement used to display employee names together with all of their job
  dates and times would be which of the following?
 
  A) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job
  On employee = job
  B) Select employee.name, job.date, job.timestart, job.timeend From employee.ssn Inner Join
  On job.ssn
  C) Select employee.name, job.date, job.timestart, job.timeend From employee Inner Join job
  On employee.ssn = job.ssn
  D) Select employee.name, job.date, job.timestart, job.timeend From employee, job Where
  employee.ssn = job.jobid

Q. 3

In Oracle, the statement used to calculate the number of clients from each NH zip code, labeled
  Zip Clients, would be which of the following?
 
  A) Select zipcode, Count(email) As 'Zip Clients' From client Group by zipcode Where state is
  'NH'
  B) Select zipcode, Count(email) As 'Zip Clients' From client Group by zipcode
  C) Select zipcode, Count(email) As 'Zip Clients' From client Group by zipcode Where state =
  'NH'
  D) Select zipcode, Count(email) From client Group by zipcode Where state = 'NH'

Q. 4

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

Q. 5

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

Q. 6

In Oracle, which of the following statements would result in contacts, emails, and zip codes for
  the clients whose emails end in net, and who live in 03264 zip code?
 
  A) Select contact, email, zipcode From client Where email Like net And zipcode = 03264
  B) Select contact, email, zipcode From client Where email Like net Or zipcode = 03264
  C) Select contact, email, zipcode From client Where email Like net Or zipcode = 03264
  D) Select contact, email, zipcode From client Where email Not Like net And zipcode =
  03264

Q. 7

In Oracle, which of the following statements would result in contacts, emails, and zip codes for
  the clients whose emails either end in net, or who live in 03264 zip code?
 
  A) Select contact, email, zipcode From client Where Email Like net Or zipcode = 03264
  B) Select contact, email, zipcode From client Where Email Like net Or zipcode = 03264
  C) Select contact, email, zipcode From client Where Email Like net And zipcode = 03264
  D) Select contact, email, zipcode From client Where email Not Like net And zipcode =
  03264

Q. 8

Complex Where clauses typically involve several conditions and use which of the following
  logical operators?
 
  A) =, <, >, <=, >=, = B) +, -, , /
  C) And, Or D) Like, Unlike