PassLeader now are offering 100% pass ensure 1Z0-052 dumps! All 1Z0-052 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-052 VCE dumps and PDF dumps: http://www.passleader.com/1z0-052.html (261 Q&As)
BTW: Download PassLeader 1Z0-052 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaXlIQVBWWmRoa1U
QUESTION 141
Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)
A. Undo tablespace
B. USERS tablespace
C. SYSAUX tablespace
D. SYSTEM tablespace
E. Temporary tablespace
Answer: CD
QUESTION 142
View the Exhibit and examine the setting for a table. Which statement is true about the PCTFREE setting for the table?
A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
C. It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
D. It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
Answer: B
QUESTION 143
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
Answer: A
QUESTION 144
View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)
A. LOG_BUFFER
B. SORT_AREA_SIZE
C. JAVA_POOL_SIZE
D. STREAMS_POOL_SIZE
E. DB_16K_CACHE_SIZE
F. DB_KEEP_CACHE_SIZE
Answer: AEF
QUESTION 145
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)
A. Disable automatic checkpoint tuning
B. Check the size of the redo log file size and increase the size if it is small
C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group
Answer: BC
QUESTION 146
Identify the memory component from which memory may be allocated for:
Session memory for the shared server
Buffers for I/O slaves
Oracle Database Recovery Manager (RMAN) backup and restore operations
A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)
Answer: A
QUESTION 147
You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two.)
A. The database automatically determines the extent-sizing policy for the tablespace.
B. The segments are automatically shrunk when the contents are removed from them.
C. The allocation of extents within the tablespace is managed through the dictionary tables.
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E. The space utilization description of the data blocks in segments is managed through free lists.
Answer: AD
QUESTION 148
In which of the scenario will the DBA perform recovery? (Choose all that apply.)
A. The alert log file is corrupted
B. A tablespace is accidentally dropped
C. One of the redo log members is corrupted
D. A database user terminates the session abnormally
E. The hard disk on which the data files is stored is corrupted
Answer: BE
QUESTION 149
You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed. What is the location of the alert_orcl.log file?
A. ORACLE_HOME/dbs
B. ORACEL_HOME/rdbms
C. /u01/app/oracle/admin/orcl/adump
D. /u01/app/oracle/flash_recovery_area
E. ORACLE_BASE/diag/rdbms/orcl/alert
F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace
Answer: F
QUESTION 150
You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?
A. 4, 1, 3, 2, 5
B. 1, 3, 4, 5, 2
C. 1, 3, 2, 5; 4 not required
D. 4, 1, 5, 2; 3 not required
E. 1, 3, 4, 5; 2 not required
Answer: C
QUESTION 151
See the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that apply.)
A. A bitmap is used to record free extents
B. Free extents information is managed within the tablespace
C. Free extents information is managed in the SYSAUX tablespace
D. The data dictionary tables are updated when extents are allocated or deallocated
Answer: AB
QUESTION 152
Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
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
Answer: BC
QUESTION 153
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Answer: C
QUESTION 154
You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value. Which action would help to use the previous set of statistics on the objects?
A. Restore statistics from statistics history.
B. Reduce the optimizer statistics retention period by 2 days.
C. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
D. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.
Answer: A
QUESTION 155
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
A. An SPFILE is a binary file
B. An SPFILE cannot reside on a client
C. An SPFILE cannot contain static parameters
D. An SPFILE can store changes persistently across instance restarts
E. An SPFILE can be read by the database server, but it is not written to by the server
F. An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database
Answer: ABD
QUESTION 156
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file?
A. Take the USERS tablespace offline and re-create the lost data file
B. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance
C. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance
D. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online
Answer: C
QUESTION 157
Examine the command:
SQL>DBMS_STATS.SET_TABLE_PREFS(‘SH’,’CUSTOMERS’,’PUBLISH’,’false’);
Which statement describes the effect of the above command?
A. Automatic statistics collection is stopped for the CUSTOMERS table
B. Statistics for the CUSTOMERS table are locked and cannot be overwritten
C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer
D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics
Answer: D
QUESTION 158
The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege. What would you achieve by the above process?
A. The database user OPS$SKD will be able to administer the database.
B. The authentication detail for the database user OPS$SKD is recorded in the password file.
C. The local operating system user SKD will be able to access the database instance without specifying the username and password.
D. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
Answer: C
QUESTION 159
Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)
A. The retention period to support flashback
B. The expected length of the longest-running query
C. The number of undo tablespaces in the database
D. The size of the Flash Recovery Area for the database instance
Answer: AB
QUESTION 160
The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?
A. Inactive and current redo log files are required to accomplish recovery
B. Online and archived redo files are required to accomplish instance recovery
C. All redo log entries after the last checkpoint are applied from redo log files to data files
D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
Answer: C
PassLeader now are offering 100% pass ensure 1Z0-052 dumps! All 1Z0-052 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-052 VCE dumps and PDF dumps: http://www.passleader.com/1z0-052.html (261 Q&As)
BTW: Download PassLeader 1Z0-052 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaXlIQVBWWmRoa1U