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 34 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
Gracias!

okolip

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

« previous next »
 

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

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?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Genetic engineering as an application for cures Genetic engineering as an application for cures
Vapocoolant spray application while passively stretching the paracervical muscles. Take care to prot Vapocoolant spray application while passively stretching the paracervical muscles. Take care to prot
Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages
Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages
How to solve application problems containing quadratics (Question 3) How to solve application problems containing quadratics (Question 3)
Functions application question Functions application question
Video: Allergic Rhinitis

For a complete list of videos, visit our video library