When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?
A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase
B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you
change the value of PGA_AGGREGATE_TARGET.
C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM
will change if you switch between Manual and Automatic PGA Memory Management.
D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas
if you switch from Manual to Automatic PGA Memory Management.
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?
Which of the following describes how a distributed resumable transaction behaves?
A. The resumable setting on the initiating session determines the resumable conditions for the entire
B. The resumable setting for the initiating instance determines the resumable conditions for the entire
C. The resumable setting on the initiating session controls only that part of the transaction that occurs
within the local instance; remote resumable settings determine the behavior of the distributed parts of
D. None of the above.
Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?
A. Username, instance number, session ID
B. Instance number, username, session ID
C. Instance number, session ID, username
D. Username, session ID, instance number
E. None of the above
Which of the following are included in a transportable tablespace set? (Choose all that apply.)
A. The datafiles that make up a self-contained group of tablespaces required for copy
B. The system tablespace
C. An export of the tablespace metadata
D. The spfile
E. All of the above
The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)
select d.platform_name “Source”, t.platform_name
“Compatible Targets”, endian_format
from v$transportable_platform t, v$database d
where t.endian_format = (select endian_format
from v$transportable_platform t,
where d.platform_name =
A. The list of target platforms having the same endian format as the source database
B. The list of target platforms requiring endian conversion
C. The list of target platforms that will not require endian conversion
D. The list of all target platforms that can receive transportable tablespaces from the source database
E. None of the above
When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?
A. Export the tablespaces using data pump.
B. Determine if the transportable set is self-contained.
C. Convert the datafiles using RMAN.
D. Copy the datafiles from source to destination.
Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended
destination is listed.
B. Verify that there are no restrictions or limitations that the source or destination database may encounter.
C. Verify that the source and destination have the same Oracle version, critical updates, patch-set version,
and patch- set exceptions.
D. Determine if you will perform the conversion on the source or destination platform.
E. None of the above.
Which of the following supplied functions is used to identify external tables, directories, and BFILES?
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?
A. The database must be in read-write mode.
B. The database must have no external files.
C. The database must open in read-only mode.
D. The database must be mounted but not opened.
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.