1z1-034 試験問題を無料オンラインアクセス

While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours.
Which view would you query to determine the name and status of the stopped job?

• A.V$SESSION_LONGOPS
• B.DBA_JOBS
• C.DBA_DATAPUMP_JOBS
• D.DBA_DATAPUMP_SESSIONS
• E.V$SESSION

View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?
ASM-disk-group-1 (exhibit):

ASM-disk-group-2 (exhibit):

• A.Because the other three disks have 60% free space, the disk rebalancing is delayed
• B.Because the mirrored extents cannot be rebalanced across the other three disks
• C.Because the disk group is created with NORMAL redundancy
• D.Because the disk repair time attribute is set to a nonzero value

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

• A.All redo log entries after the last checkpoint are applied from redo log files to data files
• B.Online and archived redo files are required to accomplish instance recovery
• C.Inactive and current redo log files are required to accomplish recovery
• D.All redo log entries recorded in the current log file until the checkpoint position are applied to data files

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?

• A.The uncommitted transaction will be committed at the next startup of the database instance
• B.The online redo log files and archived redo log files are required to accomplish the recovery
• C.The uncommitted transaction is rolled back automatically at the next opening of the database
• D.The DBA has to perform the recovery on the database to recover the uncommitted transaction

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.
From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

• A.The STATISTICS_LEVEL parameter is set to BASIC.
• B.The SQL_TRACE parameter is set to FALSE.
• C.The TIMED_STATISTICS parameter is set to FALS
• D.The EVEN parameter was not set.
• E.Enterprise Manager is not used.