What are SQL stored procedures and how are they used?

What will be an ideal response?


An SQL stored procedure is a stored program that is attached to a database instead of just a table or view. Stored procedures can receive input parameters and return results. They can be executed by any process that has permission with the database to use stored procedures. They can issue SELECT, INSERT, UPDATE and DELETE commands. They are typically used by (1 ) database administrators to do common administrative tasks, and (2 ) database applications.

Business

You might also like to view...

The Financial Accounting Standards Board created the objectives of financial reporting

a. True b. False Indicate whether the statement is true or false

Business

What is generally indicated in a divorce or bankruptcy when books and records of the debtor/marital partner have been destroyed or are hard to locate, it generally means:

a. Fraud has caused the bankruptcy or divorce b. The bankruptcy or divorce is used to perpetrate the fraud c. The bankruptcy or divorce is used to conceal the fraud d. None of the above

Business

Which of the following would not be considered a subsequent event to financial statements?

a. A major customer declares bankruptcy subsequent to the balance sheet date, but prior to issuing the statements. This event was not considered on the balance sheet date. b. A major purchase of a subsidiary to the balance sheet date, but prior to issuing the statements. c. Substantial debt incurred subsequent to the balance sheet date, but prior to issuing the statements. d. Substantial stock issued subsequent to the balance sheet date, but prior to issuing the statements. e. Hiring of employees for a new store, subsequent to the balance sheet date, but prior to issuing the statements.

Business

Consumers' names and additional information likely become part of ________ whenever they enter a sweepstakes, apply for a credit card, visit a Web site, or send a tweet

A) other consumers' contact lists B) telemarketers' lists C) their computer's cookie history D) a company's database E) the FTC's surveys regarding online privacy

Business