Author Question: In Oracle, which of the following statements would result in contacts, emails, and zip codes for ... (Read 71 times)

debasdf

  • Hero Member
  • *****
  • Posts: 570
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

Question 2

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



cassie_ragen

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

A

Answer to Question 2

A



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

For a complete list of videos, visit our video library