A.Restore the backup copy of the tempfile from the backup media.
B.Re-create the tempfile with the create tempfile command.
C.Copy an existing tempfile from another database.
D.Re-create the tempfile with the create tablespace command.
E.Re-create the tempfile with the alter tablespace command.
您可能感兴趣的试卷
你可能感兴趣的试题
A.7
B.1
C.10
D.11
E.21
A.None. The database will switch over to the stand-by archive-log destination directory.
B.A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
C.The database will shut down, and will not restart until you correct the out-of-space situation.
D.The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
E.Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
A.shutdown abort
B.shutdown kill
C.Shutdown nowait
D.shutdown immediate
E.shutdown halt
A.V$BACKUP
B.V$BACKUP_STATUS
C.V$BACKUP_DATAFILE
D.V$DATAFILE_BACKUP
E.V$TABLESPCE_BACKUP
A.LOG_ARCHIVE_1
B.LOG_DESTINATION_1
C.LOG_ARCHIVED_DESTINATION_1
D.LOG_ARCHIVE_DEST_1
E.LOG_ARCHIVE_SOURCE_1
A.alter tablespace DAVE_TBS backup mode
B.alter tablespace DAVE_TBS start backup
C.alter tablespace DAVE_TBS begin backup
D.alter tablespace DAVE_TBS backup begin
E.alter tablespace DAVE_TBS backup
A.alter database backup controlfile
B.alter database backup controlfile to trace
C.alter database controlfile backup
D.alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E.alter database begin controlfile backup
A.RMAN backup-set pieces spanning backup sets
B.RMAN backup-set pieces within a given backup sets
C.RMAN backups
D.RMAN channels
E.None of the above
A.Implement job classes
B.Implement Scheduler windows
C.Implement the mapping rule for the consumer groups
D.Set the SWITCH_TIME resource plan directive for both the resource plans
A.The Oracle database will perform block checking for the index blocks only
B.The Oracle database will not perform block checking for any of the data blocks
C.The Oracle database will perform block checking for the default permanent tablespace only
D.The Oracle database will perform block checking for the data blocks in all user tablespaces
E.The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
最新试题
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?（）
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）
Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）
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?（）
Which two commands never trigger an implicit rebalancing within the disk group?（）
Which three functions are performed by the SQL Tuning Advisor? （）
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?（）
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
Examine the parameter setting in your database:Which statement is correct about the database?（）