单选题A system administrator needs to upgrade the Oracle database from Version 7 to Version 8. Which of the following scheduling concerns should be considered?（）ASchedule enough down time to backup, upgrade and reboot. BBackup, upgrade, then schedule enough down time to reboot the system.CBackup, then schedule enough down time to upgrade and reboot the system. DThere are no scheduling concerns because no down time is required.
单选题
A system administrator needs to upgrade the Oracle database from Version 7 to Version 8. Which of the following scheduling concerns should be considered?（）
A
Schedule enough down time to backup, upgrade and reboot.
B
Backup, upgrade, then schedule enough down time to reboot the system.
C
Backup, then schedule enough down time to upgrade and reboot the system.
D
There are no scheduling concerns because no down time is required.
参考解析
解析：
暂无解析
相关考题：
Which two statements are true regarding the starting of the database instance using the following command?()SQLSTARTUP UPGRADE A. It enables all system triggers.B. It allows only SYSDBA connections.C. It ensures that all job queues remain active during the upgrade process.D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
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.
The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?() A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perform block checking for the default permanent tablespace onlyD. The Oracle database will perform block checking for the data blocks in all user tablespacesE. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.() A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade
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.savevgB.tarC.cpioD.mksysb
A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution？（）A、A JBODB、A RAID 50 arrayC、A NASD、A single SSD
A system administrator needs to upgrade the Oracle database from Version 7 to Version 8. Which of the following scheduling concerns should be considered?（）A、Schedule enough down time to backup, upgrade and reboot. B、Backup, upgrade, then schedule enough down time to reboot the system.C、Backup, then schedule enough down time to upgrade and reboot the system. D、There are no scheduling concerns because no down time is required.
A System p administrator in a manufacturing customer plans to migrate an AIX 5.2 system to a new LPAR on an existing System p using VIOS. Which of the following must be completed prior to this migration （）A、Upgrade system firmware to latest levelB、Upgrade to AIX 5.3C、Upgrade HMC to version 6.1D、Convert rootvg filesystems to JFS2
A System p administrator needs to upgrade a system from AIX 5.2 to AIX 5.3. Which of the following installation methods would minimize downtime（）A、Migration installationB、Partition MobilityC、alt_disk_installD、update_all smit fastpath and reboot during the next scheduled outage
A customer has a combination of fifteen Windows file servers with direct attached storage and three Power Systems with AIX database servers SAN attached to a DS4700. They would like to upgrade and plan for 40 TB capacity. The customer needs to move to a more scalable storage system to include all servers. Which of the following would be most appropriate to ask first？（）A、What are Disaster RecoveryplansB、What are plans for datamigrationC、What storage system space isavailableD、DoesiSCSI meet the needs
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A、 The Oracle database will not perform block checking for any of the data blocks.B、 The Oracle database will perform block checking for the default permanent tablespace only. C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（） A、 The Oracle database will perform block checking for the index blocks onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）A、Change in the Oracle Database versionB、Change in your network infrastructureC、Change in the hardware configuration of the database serverD、Migration of database storage from non-ASM to ASM storageE、Database and operating system upgrade
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
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
Which two statements are true regarding the starting of the database instance using the following command？（） SQLSTARTUP UPGRADE A、 It enables all system triggers.B、 It allows only SYSDBA connections.C、 It ensures that all job queues remain active during the upgrade process.D、 It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
单选题A System p administrator needs to upgrade a system from AIX 5.2 to AIX 5.3. Which of the following installation methods would minimize downtime（）AMigration installationBPartition MobilityCalt_disk_installDupdate_all smit fastpath and reboot during the next scheduled outage
多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware configuration of the database serverDMigration of database storage from non-ASM to ASM storageEDatabase and operating system upgrade
单选题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?（）AsavevgBtarCcpioDmksysb
多选题SQ L*Loader is a utility that can perform which two tasks？（）ALoad data from a disk， tape， or named pipes.BLoad data into an Oracle database using DML statements.CExtract， reorganize， and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.
多选题Which three tasks can be performed using a duplicate database?（）ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）A The Oracle database will perform block checking for the index blocks onlyB The Oracle database will not perform block checking for any of the data blocksC The Oracle database will perform block checking for the default permanent tablespace onlyD The Oracle database will perform block checking for the data blocks in all user tablespacesE The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
多选题What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）AEffectively implements role separationBEnables you to take advantage of Oracle Managed Files.CAutomatically registers the database with Oracle Restart.DHelps you to easily upgrade the database from a prior release.EEnables the Installation of Grid Infrastructure files on block or raw devices.
多选题Which three tasks can be performed using a duplicate database? （）(Choose three.)ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
单选题A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution？（）AA JBODBA RAID 50 arrayCA NASDA single SSD
单选题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.
单选题The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A The Oracle database will not perform block checking for any of the data blocks.B The Oracle database will perform block checking for the default permanent tablespace only. C The Oracle database will perform block checking for the data blocks in all user tablespaces.D The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
单选题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