1Z0-042

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: database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? A.3 hours B.6 months C.until last year D.until last commit E.until the point when the undotablespacewas refreshed F.until the database is shut down and the memory erased Answer: A QUESTION 15: Actualtests.com - The Power of Knowing 1Z0-042 In your Certkiller .com production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this? A.Modify the value for the UTL_FILE_DIR parameter in the parameter file B.Grant read and write privilege on the operating system path to the database users C.Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file D.Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file E.Create a directory object referring to the operating system path, and grant read and write privilege on the directory object to the database users Answer: A QUESTION 16: Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid? A.Program Global Area (PGA) is stored in Shared pool. B.User session data and Cursor state are stored inLargepool and Stack space is stored Shared pool. C.User session data is stored in Shared pool and Stack space and Cursor state are stored inLargepool. D.User session data and Cursor state are stored inLargepool and Stack space is stored outside the System Global (SGA). E.User session data and Cursor state are stored outside the System Global Area (SGA) and Stack space is stored inside the SGA. Answer: D QUESTION 17: You work as a database administrator for Certkiller .com. On a Monday morning, you find the database instance aborted. After insp...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online