Author Question: In SQL Query Analyzer, which of the following statements would result in contacts, emails, and zip ... (Read 24 times)

renzo156

  • Hero Member
  • *****
  • Posts: 526
In SQL Query Analyzer, 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 Not Like net And 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 Like net Or zipcode = 03264

Question 2

________ is the process of gathering and organizing information from users, managers, customers, business processes, and documents to understand how a proposed information system should function.
 
  A) Data modeling
  B) Requirements collection
  C) Beta testing
  D) End-user development
  E) External acquisition



Moriaki

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

A

Answer to Question 2

B



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

Interferon was scarce and expensive until 1980, when the interferon gene was inserted into bacteria using recombinant DNA technology, allowing for mass cultivation and purification from bacterial cultures.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

For a complete list of videos, visit our video library