A.All datafiles of a database
B.All datafiles, archive logs, and control files
C.All datafiles and control files
D.All the used blocks in a datafile
您可能感兴趣的试卷
你可能感兴趣的试题
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
最新试题
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?()
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?()
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?()
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()
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.()
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()
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?()
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?()