86 99 chapter 3 new oracle9i availability and

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: , Robert Freeman, p. 86-99 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 33: What does Block Media Recovery (BMR) do? A. Does only a recovery of the specified blocks B. Replaces bad blocks by substituting good blocks C. Uses the DBMS_REPAIR package to fix block corruptions D. Does a restore and a recovery of the specified blocks Answer: D Explanation: Block Media Recovery restores and recovers the specified blocks. You can use the new BLOCKRECOVER statement to perform BMR. Incorrect Answers A: It does not only recover the specific blocks but also restores blocks. B: It does not replace bad blocks by substituting good blocks. C: Block Media Recovery does not use the DBMS_REPAIR package to fix block corruptions. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 186 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 84-86 Chapter 3: New Oracle9i Availability and Recoverability Features QUESTION 34: Oracle9i offers security improvements in the middle tier. One of these improvements is the Secure Application role. What are three key benefits of this improvement? (Choose three). A. The role is enabled through a package. B. The password is hidden within the application itself. C. It uses the SYS_CONTEXT mechanism to authenticate user access. Actualtests.com - The Power of Knowing 1Z0-030 D. It removes the requirement to embed a password in the application itself. Answer: A, C, D Explanation: Oracle9i allows you to enable the role through a package. It uses the SYS_CONTEXT mechanism to authenticate user access. The Secure Application role removes the requirement to embed a password in the application itself. When your application starts up, you should enable the roles for application by using the SET ROLE statement. Prior to Oracle9i, your application would have to try to hide this password by encrypting it. The application itself became the weakest link in the chain. If someone discovered the password, any application could enable the role and gain access to the information. Any user that has access to the application code could in fact discover the embedded password. In Oracle9i, the SET ROLE does not use a password to enable a role; instead, it invokes the associated procedure that authenticates the role. This procedure can also use SYS_CONTEXT to access session information and set up fine-grained access control. Incorrect Answers B: The application has not to store the password itself. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 10-24 Chapter 1: Security Enhancements Oracle 9i New Features, Robert Freeman, p. 132-135 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 35: User defined events in Oracle Enterprise Manager return status, and possibly values, to the Oracle Enterprise Manager Event Monitor. What are user defined events? A. Database based scripts (PL/SQL, Java) run by the Agent B. Database Event Triggers, which issue Ale...
View Full Document

Ask a homework question - tutors are online