D there is no getview procedure of function in the

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: s in the DBMS_METADATA package. Incorrect Answers C: GET_TYPE is not a part of the DBMS_METADATA package. D: There is no GET_VIEW procedure of function in the DBMS_METADATA package. E: GET_TABLE is not a part of the DBMS_METADATA package. Actualtests.com - The Power of Knowing 1Z0-030 OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 136-138 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 44-46 Chapter 2: Oracle9i Architecture Changes QUESTION 66: Which statement describes the distinction between Fine-Grained Audit (FGA) and Fine-Grained Access Control (FGAC)? A. FGA is an extension of FGAC. B. FGAC prohibits access by row; FGA enables access by row. C. Both use Application Context, but only FGAC can use the Secure Application role. D. FGA tracks when sensitive rows have been accessed; FGAC prevents access to sensitive rows. Answer: D Explanation: Prior to Oracle9i, value-based auditing was possible with before and after triggers for the INSERT, UPDATE, and DELETE operations. Oracle9i extended the concept of the finegrained access to the auditing functions to enable you to audit SELECT operations. FGA can audit attempts to access information even if the information itself was not accessed. Incorrect Answers A: FGA is not an extension of FGAC. B: FGAC and FGA do not prohibits or enables access by row. FGA specifically audit just the successful operations or the unsuccessful operations. C: FGA can use the Secure Application role also. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 21-22 Chapter 1: Security Enhancements Oracle 9i New Features, Robert Freeman, p. 132-139 Chapter 5: Miscellaneous Oracle9i Features and Enhancements QUESTION 67: You start a multithreaded heterogeneous service agent with this initialization parameter: MAX_DISPATCHERS = 10 What is the result? A. A maximum of ten dispatcher threads can be active in the agent. B. A maximum of ten sessions can be connected to the agent simultaneously. C. A maximum of ten concurrent sessions can be connected to each dispatcher. D. A maximum of ten external dispatcher processes can register with the listener thread. Actualtests.com - The Power of Knowing 1Z0-030 Answer: A Explanation: The result of this setting is: a maximum of ten dispatcher threads can be active in the agent. Incorrect Answers B: A maximum of ten dispatcher threads can be active in the agent, not maximum of ten sessions can be connected to the agent simultaneously. C: This initialization parameter does not limit a maximum of concurrent sessions connected to each dispatcher. D: Setting of MAX_DISPATCHERS parameters will not limit a maximum of external dispatcher processes can register with the listener thread. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 144-152 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 59-60 Chapter 2: Oracle9i Architecture Changes QUESTION 68: Which three par...
View Full Document

Ask a homework question - tutors are online