Author Question: In Oracle, which of the following statements would result in contacts, emails, and zip codes for ... (Read 66 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?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

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