The best way to utilize a stored procedure in a relational database.

Posted on by Leakey
  1. Describe the best way to utilize a stored procedure in a relational database. Explain your rationale.
  2. Nonidentifying relationships are common within databases. Explain how nonidentifying relationships differ from identifying relationships. Provide three real-world examples of nonidentifying relationships that could occur within a database.
  3. What are the pros and cons of pessimistic concurrency in relation to optimistic concurrency? What are the pros and cons of explicit transactions in relation to implicit transactions, and vice versa? Support your rationale.
  4. Why are the COMMIT and ROLLBACK statements necessary? Explain their relationship to one of the transaction properties. Explain all four possible concurrency problems and provide examples of each.
  5. Many problems arise from poor database design. Discuss two potential consequences that can result from a poorly designed database. Explain how these issues can be prevented and corrected if they do occur. Provide real-world examples to illustrate your main ideas.
  6. What are the pros and cons of using stored procedures (SPROCS) or functions? Provide an example of each to illustrate your ideas.
  7. What is the importance of the master system database? Discuss the pros and cons of full database backup. Discuss all components of the database engine in relation to data availability, and their benefits and disadvantages in relation to server redundancy, database redundancy, and file redundancy. Provide examples to justify your ideas.
  8. Entities within databases take on many forms. Provide three examples of entities you may encounter and summarize the attributes of each. Explain why entities are important and provide examples to illustrate your ideas.

This question has been answered.

Get Answer