Explain what stored procedures are and how they are used
What will be an ideal response?
Stored procedures are modules of code which are stored on the database server. They are usually written in a language specific to the DBMS, such as PL/SQL for Oracle. Stored procedures have many advantages, particularly performance improvements over client-based procedures since the code executes on the server and there is less network traffic. Also, there is increased security since client applications are accessing the stored procedures and not accessing tables directly. In addition, a library of stored procedures can be developed and used across multiple applications.
Since stored procedures are written in a proprietary language, it would be more difficult to port them across platforms. Also, it may take longer to develop the procedures due to the learning curve of programmers.
You might also like to view...
When a new partner is admitted by making an investment in the partnership, the old partners' capital accounts are always credited
a. True b. False Indicate whether the statement is true or false
Despite the fact that Starbucks is widely admired for forward-thinking management policies, Global Exchange allowed the company to further demonstrate its commitment to social responsibility by selling Fair Trade coffee
Indicate whether the statement is true or false
Various laws and contracts govern the rights and obligations of a shareholder. Which of the following is/are not true?
a. The corporation laws of the jurisdiction in which incorporation takes place govern the rights and obligations of a shareholder. b. The articles of incorporation or the corporate charter sets out the agreement between the firm and the jurisdiction in which the business incorporates. c. The board of directors adopts bylaws, which are the rules and regulations governing the internal affairs of the corporation. d. The jurisdiction grants to the firm the privileges of operating as a corporation for certain stated purposes and of obtaining its capital through the issue of shares of stock. e. none of the above
The ______ side seeks to convince the judges and/or members of the audience that change is not needed, working to defeat the resolution and maintain the status quo.
a. pessimistic b. affirmative c. negative d. anti