Free Oracle 1Z1-052 Exam Dumps Questions & Answers

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
After 30 minutes, you executed the following command:

What could be the reason for the elimination of the other rows in the output?
Exhibit:

• A.An Automatic Workload Repository snapshot has been taken recently.
• B.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
• C.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
• D.The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

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 segments are automatically shrunk when the contents are removed from them.
• B.The allocation of extents within the tablespace is managed through the dictionary tables.
• C.The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• D.The database automatically determines the extent-sizing policy for the tablespace.
• E.The space utilization description of the data blocks in segments is managed through free lists.

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.Checkpoint information will not be written to the alert log file
• C.The MTTR advisor will be disabled
• D.Automatic checkpoint tuning will be disabled

Examine the following output:

Which two statements about the above index are true? (Choose two.)

• A.The index cannot be rebuilt, and has to be re-created.
• B.The index is automatically rebuilt when used the next time.
• C.It is not used while the index is being rebuilt.
• D.It is ignored by the query optimizer.

In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.
What would you do to automate this configuration for the memory components with change in mode of working?

• A.Set the MEMORY_MAX_TARGET initialization parameter to zero.
• B.Set the PRE_PAGE_SGA initialization parameter to TRUE.
• C.Set the SGA_TARGET initialization parameter to a nonzero value.
• D.Set the SGA_TARGET initialization parameter to zero.