-
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
A . Information about each Oracle Net connection.
B . Information about each entry in theLinstener.orafile
C . Information about the changed done in the database
D . Information about the different listeners in your system
E . Information about all thenondatabasefiles required to operate the database
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
A . Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B . Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C . Use compression when performing tape backups
D . Configure multiple SBT channel
-
You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?()
A . The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B . The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C . The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D . Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
-
You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()
A . The data file backup is done with multiple channels
B . The data files is in the read-write mode after being backed up in the read only mode
C . The backup was taken after the data files was taken offline-normal or is in the read only mode
D . The data file backup complies with the back retention policy and the backup duplexing feature
-
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()
A . The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B . Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C . Backup optimization is permanently disabled
D . Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
-
You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use?()
A . The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B . The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C . The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D . Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
-
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()
A . Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B . Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C . Use compression when performing tape backups
D . Configure multiple SBT channel
-
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()
A . A base catalog exists
B . The recovery catalog is empty
C . The base recovery catalog must be dropped
D . A target database is registered in the recovery catalog
-
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
A . Database Datafiles
B . Database Control Files
C . Online redo logs
D . Archived redo logs
E . The database SPFILE
F . None of the above,all these files are backed u
-
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
A . Database Datafiles
B . Database Control Files
C . Online redo logs
D . Archived redo logs
E . The database SPFILE
F . None of the above, all these files are backed up.&e
-
You need to design a method to enable remote encryption on Server5. What should you do?()
A . Configure the editor’s user account properties to enable Store password using reversible encryption
B . Configure the editor’s user account properties to enable Use DES encryption for this account
C . Configure the Local Security Policy on Server to enable the System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing security policy
D . Configure the Server5 computer account properties to enable Trust computer for delegatio
-
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()
A . A base catalog exists
B . The recovery catalog is empty
C . The base recovery catalog must be dropped
D . A target database is registered in the recovery catalog
-
You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups()
A . The backups would be consistent.
B . The backups would be inconsistent.
C . The backups would be possible only if the database is running in ARCHIVELOG mode.
D . The backups would be possible only if the database is running in NOARCHIVELOG mode.
E . The backups need to be restored and the database has to be recovered in case of a media failure.
-
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
A . The backups would be consistent.
B . The backups would be inconsistent.
C . The backups would be possible only if the database is running in ARCHIVELOG mode.
D . The backups would be possible only if the database is running in NOARCHIVELOG mode.
E . The backups need to be restored and the database has to be recovered in case of a media failure
-
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()
A . The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B . Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C . Backup optimization is permanently disabled
D . Backup optimization is temporarily disabled because a redundancy-based retention policy is specified
-
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.() (Choose two.)
A . The data file backup is done with multiple channels
B . The data files is in the read-write mode after being backed up in the read only mode
C . The backup was taken after the data files was taken offline-normal or is in the read only mode
D . The data file backup complies with the back retention policy and the backup duplexing feature
-
Which script must you to query to display the code associated with RMAN stored scripts?()
A . RC_STORED_SCRIPT
B . RC_STORED_SCRIPT_LINE
C . RC_SCRIPTS
D . RC_STORED_LINE_SCRIPT
E . None of the other alternatives apply
-
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.()
A . The data file backup is done with multiple channels
B . The data files is in the read-write mode after being backed up in the read only mode
C . The backup was taken after the data files was taken offline-normal or is in the read only mode
D . The data file backup complies with the back retention policy and the backup duplexing fe ture
-
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
A . Information about each Oracle Net connection.
B . Information about each entry in theLinstener.orafile
C . Information about the changed done in the database
D . Information about the different listeners in your system
E . Information about all thenondatabasefiles required to operate the database
-
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file,current SPFILE file,data files,and archived redo log
-
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()
A . Issue the grant command from the SYS user (or equivalent) of the target database.
B . Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
C . Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
D . Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
E . Issue the grant command from RMAN when connected to the target database.
-
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?()
A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog
-
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?()
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/31f166c0cedddf6946f2b336e2153075.jpg' />
A. The command performs the recovery and closes the failures.
B. The command only displays the advice and the RMAN script required for repair.
C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).