A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
您可能感兴趣的试卷
你可能感兴趣的试题
A. The tape I/O performed is asynchronous
B. The tape buffer is allocated from the System Global Area (SGA)
C. The tape buffer is allocated from the Program Global Area (PGA)
D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?（）
A. It cancels all pending disk drops within the disk group.
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
Which option illustrates the correct sequence that you must use?（）
A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8
A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database
A. Configure backup optimization
B. Configure the channel to increase MAXOPENFILES
C. Configure the channel to increase the capacity with the RATE parameter
D. Configure the channel to adjust the tape buffer size with the BLKSIZE option
The user SYS creates a job by using the following command:
Which two statements are true about the job that was created by the preceding command?（）
A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D.
A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover
Examine the CREATE DISKGROUP command used to create a disk group:
In which situation would you use this method of disk group creation?（）
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
You executed the following commands in a database session:
What could have caused the recycle bin to clean up?（）
A. There is demand for space from the new table从
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space
View the exhibit and examine the TRANS table's storage information.
After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?（）
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
最新试题
Which three tasks can be performed using a duplicate database?（）
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?（）
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.（）
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）
Which three statements are true about windows?（）
Which two statements are true about the Automatic Diagnostic Repository (ADR)?（）
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?（）
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）