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 20 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
Great answer, keep it coming :)

LegendaryAnswers

  • Member
  • Posts: 341
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages
Prepare knee for cold application. Undrape the leg. Check tissues visually and through palpation, ... Prepare knee for cold application. Undrape the leg. Check tissues visually and through palpation, ...
How to solve application problems containing quadratics (Question 3) How to solve application problems containing quadratics (Question 3)
Application Special Triangles Application Special Triangles
Application and Integration Application and Integration
Application And Integration Application And Integration
Video: Supine Position

For a complete list of videos, visit our video library