2016 June Oracle Official News: 1Z0-052 Oracle Database 11g: Administration I Exam Questions New Updated Today! Free Download 1Z0-052 PDF and VCE Dumps 261Q&As in Braindump2go.com! 100% Exam Pass Guaranteed!
NEW QUESTION 51 – NEW QUESTION 60:
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users.
What could be the reason for this?
A. To limit the User Global Area (UGA) memory allocated to a session from the SGA
B. To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C. To limit the amount of memory to be used for the request pool in System Global Area (SGA)
D. To control the amount of memory allocated in SGA for the local variables for each shared server process
You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:
1. SGA is allocated.
2. Control file is read.
3. Redo log files are read.
4. Instance recovery is started.
5. Background processes are started.
6. Data files are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?
A. 7, 1, 5, 2, 3, 6, 4
B. 1, 5, 7, 2, 3, 6; step 4 is not required
C. 7, 1, 5, 2, 3, 6 step 4 is not required
D. 1, 2, 3, 5, 6, 4; step 7 is not required
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After
observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?
A. The minimum memory size for the database buffer cache is set to 100 MB.
B. The maximum memory size that can be obtained by the database buffer cache during ASMM is
set to 100 MB.
C. The minimum memory size allocated for a server process in the database buffer cache in dedicated
mode is set to 100 MB.
D. The maximum memory size from the database buffer cache that can be released for dynamic
distribution during ASMM is set to 100 MB.
Examine the values for the following initialization parameters:
Which two will be the implications of these values in your database? (Choose two.)
A. The SGA advisor will be disabled
B. The MTTR advisor will be disabled
C. Automatic checkpoint tuning will be disabled
D. Checkpoint information will not be written to the alert log file
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.
Which statement is true about the output of the command?
A. The backup piece is expired as the new backup is available
B. The backup piece is expired because the operating-system file was not found
C. The backup piece is expired because the retention period for the backup has expired
D. The backup piece is expired because the backup set to which it belongs is not complete
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?
A. The extents in the undo tablespace retain data until the next full database backup
B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
C. The extents containing committed data in the undo tablespace are not overwritten until the instance
is shut down
D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area
before being overwritten
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.
What will be the implications on the archiving and the location of archive redo log files?
A. Archiving will be disabled because the destination for the redo log files is missing
B. The database instance will shut down and the error details will be logged in the alert log file
C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash
Recovery Area implicitly
D. Archiving will be enabled and the location for the archive redo log file will be created in the default
Which is the correct description of a pinned buffer in the database buffer cache?
A. The buffer is currently being accessed
B. The buffer is empty and has not been used
C. The contents of the buffer have changed and must be flushed to the disk by the DBWn process
D. The buffer is a candidate for immediate aging out and its contents are synchronized with the block
contents on the disk
In which situation would you use static database registration for a listener?
A. When multiple databases are to be registered with the listener
B. When DBAs need to connect remotely to start up the database instance
C. When users need to connect the database instance using the host naming method
D. When the database instance that is to be registered with the listener is configured in shared server mode
While observing the index statistics, you find that an index is highly fragmented, thereby resulting
in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?
A. Validate the index structure using the ANALYZE …. INDEX command
B. Rebuild the index using the ALTER INDEX ….. REBUILD ONLINE command
C. Change the block space utilization parameters using the ALTER INDEX command
D. Deallocate the unused space in the index using the ALTER INDEX … DEALLOCATE UNUSED command
2016 Valid Oracle 1Z0-052 Exam Study Materials:
1.| Latest Oracle 1Z0-052 Exam PDF and VCE Dumps 261q from Braindump2go: http://www.braindump2go.com/1z0-052.html [100% Exam Pass Guaranteed!]
2.| New Oracle 1Z0-052 Exam Questions and Answers – Google Drive: https://drive.google.com/folderview?id=0B75b5xYLjSSNT1YxVElVOWxKbmM&usp=sharing
MORE Practice is the Most Important IF You want to PASS Oracle 1Z0-052 Exam 100%!
————— Pass All IT Exams at the first Try!