多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
多选题
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
A
You must shut down the database instance to perform the backups.
B
You must configure the Flash Recovery Area （FRA） for the database.
C
You can perform complete database backups without closing the database.
D
All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
参考解析
解析：
暂无解析
相关考题：
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?() A. The source database backup must be copied over the net for test database.B. The source database must be run in ARCHIVELOG mode if the database is open.C. The source database must be shut down cleanly if the database is in mounted state.D. A net service name should be set up and a listener configured with the target as well as the source database.
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
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 plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are： 1：Oracle Universal Installer （OUI） 2：Database Configuration Assistant （DBCA） 3：Database Upgrade Assistant （DBUA） 4：Oracle Net Configuration Assistant Which tools would you use for this installation（）A、2B、3C、1 and 2D、3 and 4E、1，2，and 4
In a new installation of Oracle Database 11g， you perform these activities： 1：Organize software and data on different subdirectories to avoid poor performance. 2：Use consistent naming conventions for database files. 3：Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed（）A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architectureE、Automatic Storage Management
单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）ASYSTEM BOUTLN CINTERNAL DSYS
单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）AMultiplex all database files.BConfigure the Flash Recovery Area.CConfigure the database instance for ARCHIVELOG mode.DConfigure the FAST_START_MTTR_TARGET initialization parameter
多选题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（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe 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. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）Aparallel image copy backupBbackup with MAXPIECESIZE configured for the channelCparallel backup with MAXPIECESIZE configured for the channelDintrafile parallel backup
单选题You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently？（）A parallel image copy backupB backup with MAXPIECESIZE configured for the channelC parallel backup with MAXPIECESIZE configured for the channeD intrafile parallel backup
单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands： RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK； What are the implications of this command？（）A It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
单选题You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup， you issued the following RMAN command： RMANBACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）A The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1B The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0C The SBT channel must be configured， with the parallelism setting for the SBT device set to 3D The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）AWhen the instance is started BWhen the database is mounted CWhen the database is opened DWhen the database is closed
多选题You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）AThe source database backup must be copied over the net for test database.BThe source database must be run in ARCHIVELOG mode if the database is open.CThe source database must be shut down cleanly if the database is in mounted state.DA net service name should be set up and a listener configured with the target as well as the source database.
单选题You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）AMultiplex all database filesBConfigure the Flash Recovery Area.CConfigure the database instance for ARCHIVELOG mode.DConfigure the FAST_START_MTTR_TARGET initialization parameter.
多选题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（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
单选题ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）Aparallel image copy backup Bbackup with MAXPIECESIZE configured for the channel Cparallel backup with MAXPIECESIZE configured for the channel Dintrafile parallel backup
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）AV$DATABASE BDBA_TABLES CSYSAUD$ DEMP
多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective？（）ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.
单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL@utlu111i.sql Which statement about the execution of this script is true？（）A It must be executed from the Oracle Database 11g environment.B It must be executed only after the SYSAUX tablespace has been created.C It must be executed from the environment of the database that is being upgraded.D It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are： 1：Oracle Universal Installer （OUI） 2：Database Configuration Assistant （DBCA） 3：Database Upgrade Assistant （DBUA） 4：Oracle Net Configuration Assistant Which tools would you use for this installation（）A2B3C1 and 2D3 and 4E1，2，and 4