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 80 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
Excellent

kilada

  • Member
  • Posts: 311
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
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 use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

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
Application of an ostomy bag or pouch: B, An ostomy nurse applying an ostomy bag to a stoma; Application of an ostomy bag or pouch: B, An ostomy nurse applying an ostomy bag to a stoma;
Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages
Liposomal amphotericin B: Drug molecules are embedded in the lipid bilayer. Liposomal amphotericin B: Drug molecules are embedded in the lipid bilayer.
Application and Integration Application and Integration
Application And Integration Application And Integration
Video: The Vestibular System

For a complete list of videos, visit our video library