多选题Which four actions are possible during an Online Data file Move operation?（）ACreating and dropping tables in the data file being movedBPerforming file shrink of the data file being movedCQuerying tables in the data file being movedDPerforming Block Media Recovery for a data block in the data file being movedEFlashing back the databaseFExecuting DML statements on objects stored in the data file being moved
多选题
Which four actions are possible during an Online Data file Move operation?（）
A
Creating and dropping tables in the data file being moved
B
Performing file shrink of the data file being moved
C
Querying tables in the data file being moved
D
Performing Block Media Recovery for a data block in the data file being moved
E
Flashing back the database
F
Executing DML statements on objects stored in the data file being moved
参考解析
解析：
暂无解析
相关考题：
Examine the following RMAN script:Which statement describes the purpose of the script?() A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
Which two activities are NOT supported by the Data Recovery Advisor?() A. Diagnose and repair a data file corruption offline.B. Diagnose and repair a data file corruption online.C. Diagnose and repair failures on a standby database.D. Recover from failures in the Real Application Cluster (RAC) environment.
Examine the following RMAN script:RMAN run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?() A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
Which four actions are possible during an Online Data file Move operation?() A. Creating and dropping tables in the data file being movedB. Performing file shrink of the data file being movedC. Querying tables in the data file being movedD. Performing Block Media Recovery for a data block in the data file being movedE. Flashing back the databaseF. Executing DML statements on objects stored in the data file being moved
Which four actions are possible during an Online Data file Move operation?（）A、Creating and dropping tables in the data file being movedB、Performing file shrink of the data file being movedC、Querying tables in the data file being movedD、Performing Block Media Recovery for a data block in the data file being movedE、Flashing back the databaseF、Executing DML statements on objects stored in the data file being moved
During an AIX installation, which of the following actions will occur once the Complete Overwrite option is selected?（）A、All new disks in the system will be formattedB、Only the contents of the root volume group destination disks will be destroyedC、All file systems, including /(root), /tmp, /usr, and /var, but no usr data in the root volume group, will be destroyedD、The contents of all disks on the system, even if they are not shown as the destination root volume group disks, will be destroyed
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.
Which two file types must be included in a closed database backup taken with operating system commands？（）A、data filesB、control fileC、password fileD、online redo log filesE、initialization parameter file
Which two statements are true about checkpointing（）A、The checkpoint frequency decreases with the smaller redo log file size.B、It ensures that all committed data is written to the data files during normal shutdown.C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？ （）A、 data fileB、 password fileC、 archivelog fileD、 temporary fileE、 online redo log fileF、 the current control fileG、 the tnsnames.ora fileH、 current server parameter file
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager （RMAN）（）A、data filesB、control filesC、parameter fileD、online redo log filesE、server parameter file
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）A、Data filesB、Control filesC、Parameter fileD、Online redo log filesE、Server parameter file
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file
单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database， recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
单选题You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）A Create a manual incremental online database backup.B Back up all the archived redo logs generated since the 8 a.m. backup.C Create a brand-new backup after all the changes have been applied.D There is no way to make the changes recoverable based on the 8 a.m. backup.E Perform an online backup of the tablespace（s） that contained changed data.
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
多选题Which two activities are NOT supported by the Data Recovery Advisor?（）ADiagnose and repair a data file corruption offline.BDiagnose and repair a data file corruption online.CDiagnose and repair failures on a standby database.DRecover from failures in the Real Application Cluster (RAC) environment.
多选题You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online， read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online， read/write data files when the database is in the NOMOUNT state.
单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）ARestore the data file for the SYSTEM tablespace then open the database. BRestore all redo logs form last night's backup, then restart the database. CPerform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. DMount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
多选题Which two activities are NOT supported by the Data Recovery Advisor DRA（）ARecover from failures in the RAC environment.BDiagnose and repair a data file corruption online.CDiagnose and repair a data file corruption offline.DDiagnose and repair failures on a standby database
单选题Examine the following RMAN script： RMAN run { debug on； allocate channel c1 type disk； backup datafile 5； } Which statement describes the purpose of the script？（）A The data file is checked for physical corruption and backed up if found clean.B The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
单选题The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）Auntil SCNBuntil timeCuntil cancelDusing backup control file
多选题Which two statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
多选题Which two statements are true regarding the usage of the SQL*Loader utility（）AYou can load data into multiple tables during the same load session.BYou can load data from multiple files to a table during the same load session.CYou cannot perform selective data loading based on the values available in the records.DYou can use an export file generated by the EXPDP utility as an input data file to load the data.EYou can load data only if the input file is available on the disk and tape but not in a named pipes.
多选题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
单选题Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）ARebuild the index using the online option. BTake the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. DTake the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
多选题You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened