A system administrator needs to backup datavg which contains a database that pre-allocates files by padding them with nulls, similar to treating them as sparse files. In order to effectively backup and be able to restore the datavg files, which backup method should be used?()
A.savevg
B.tar
C.cpio
D.mksysb
第1题:
A.V$BACKUP_CORRUPTION
B.V$COPY_CORRUPTION
C.V$DATABASE_BLOCK_CORRUPTION
D.RC_BACKUP_CORRUPTION
第2题:
You enabled an audit policy by issuing the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? ()
A. SYS, SYSTEM
B. SCOTT
C. Only for successful executions
D. Only for failed executions
E. Both successful and failed executions
第3题:
You are a network administrator for The network contains a Windows Server 2003 computer named Testking1.You need to install an application on Testking1. The installation will cause several changes to the registry. You plan to use the Backup utility to create a backup that will enable you to restore the registry. TestKing requirements for network management state that all backups must be performed during an eight-hour period at night. Because of this time constraint, you need to ensure that the backup can be recovered as quickly as possible.You need to create a backup that meets the requirements.What should you do?()
A. Create a backup of the system partition.
B. Create a backup of the boot partition.
C. Create a backup of the System State.
D. Create an Automated System Recovery (ASR) backup.
E. Create a backup of the Systemroot\System32\Config folder.
第4题:
You performed an incremental level 0 backup of a database:RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’;To perform an incremental level 1 cumulative backup, you issued this command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true?()
A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
B. The change tracking file must always be backed up when you perform a full database backup.
C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
D. More than one database block may be read by an incremental backup for a change made to a single block.
E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
第5题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()
A. All users except SYS
B. All users except SCOTT
C. All users except sys and SCOTT
D. All users except sys, system, and SCOTT
第6题: