A.With alter database enable block change tracking
B.With alter system enable block change tracking
C.With an init.ora parameter change
D.With an spfile parameter change
您可能感兴趣的试卷
你可能感兴趣的试题
A.Restore and recover the datafile.
B.Restore and recover the tablespace.
C.Restore and recover the database.
D.Restore and recover the control file.
E.Restore and recover the parameter file.
A.The system change number, which is a point in time relative to transactions within a given database.
B.A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.
C.The security change number, which represents the security code that is needed to access any database structure.
D.A conversion factor that converts internal database time to external clock time.
E.UTC time in the database, providing a standardized way of tracking time in Oracle.
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
最新试题
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
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?()
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()
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 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?()
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?()
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?()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
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?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()