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

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

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?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

For a complete list of videos, visit our video library