This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What is embedded SQL, and what considerations are necessary when using it in an application? What ... (Read 70 times)

formula1

  • Hero Member
  • *****
  • Posts: 666
on: Jul 7, 2018
What is embedded SQL, and what considerations are necessary when using it in an application?
 
  What will be an ideal response?

Question 2

Which does the ODBC standard not define a means of doing?
 
  A) Start transactions
  B) Rollback transactions
  C) Read a Microsoft Word document
  D) Issue SQL commands


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

connor417

  • Sr. Member
  • ****
  • Posts: 329
Reply #1 on: Jul 7, 2018
Answer to Question 1

Embedded SQL are SQL statements used, or embedded, in program code, triggers or stored procedures. Applications are typically written in program code, using a programming language. There are two problems that arise. First, the results of SQL statements must be assigned to programming language variables. DBMS products typically provide the means of doing this. Second, SQL is table or set-oriented and SQL results use tables or sets of rows, whereas application programming languages are variable or row-oriented. This is resolved by treating SQL results as pseudofiles. A cursor is then used to move through the pseudofile one.

Answer to Question 2

C


formula1

  • Member
  • Posts: 666
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

dyrone

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

Chronic necrotizing aspergillosis has a slowly progressive process that, unlike invasive aspergillosis, does not spread to other organ systems or the blood vessels. It most often affects middle-aged and elderly individuals, spreading to surrounding tissue in the lungs. The disease often does not respond to conventionally successful treatments, and requires individualized therapies in order to keep it from becoming life-threatening.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Traction is the application of a pulling force to maintain bone alignment during fracture healing. D Traction is the application of a pulling force to maintain bone alignment during fracture healing. D
Example of an online employment application and posting of a résumé. Example of an online employment application and posting of a résumé.
Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages
Application of a Hot Soak Application of a Hot Soak
Application Special Triangles Application Special Triangles
Advanced functions application Advanced functions application
Video: Hormonal regulation of pregnancy - weeks 2 through 38

For a complete list of videos, visit our video library