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

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

The lipid bilayer is made of phospholipids. They are arranged in a double layer because one of their ends is attracted to water while the other is repelled by water.

For a complete list of videos, visit our video library