Online Access Free 1z0-062 Practice Test

A senior DBA asked you to execute the following command to improve performance:
SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

• A.All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
• B.The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
• C.The keep pool is not configured.
• D.Automatic Shared Memory Management is not enabled.
• E.Automatic Workarea Management is not configured.

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

• A.The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
• B.No more data files can be added to the tablespace.
• C.Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D.The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• E.The MRKT tablespace may be dropped if it has no contents.

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A.Setting the target tablespace offline
• B.Setting the target tablespace to read-only
• C.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• E.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:

What happens when the FAILGRP1 failure group is corrupted?

• A.Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started.
• B.ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group.
• C.Mirroring of allocation units occurs within the FAILGRP2 failure group.
• D.Transactions that are using the diskgroup fail.

Which action takes place when a file checkpoint occurs?

• A.The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
• B.The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.
• C.All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
• D.The checkpoint position is advanced in the checkpoint queue.