This preview shows page 1. Sign up to view the full content.
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?
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
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
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
D.Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the
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
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
C.User session data is stored in Shared pool and Stack space and Cursor state are stored
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.
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.
- Fall '09