单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You sus

题目内容(请给出正确答案)

单选题

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

Configure Java Pool to cache the java objects.

Configure Streams Pool to enable parallel processing.

Increase Shared Pool size to cache more PL/SQL objects.

Increase Database Buffer Cache size to increase cache hits.

Configure Large Pool to be used by RMAN and shared server.

Increase the total System Global Area （SGA） size to increase memory hits.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）ARMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.BRMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMFCRMAN would relocate all the database files to an ASM disk group.DRMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

点击查看答案
第2题

单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）A The backup status will be marked expired in RMAN recovery catalog.B The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery cataloglD The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.E The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

点击查看答案
第3题

单选题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）A Opening the database in RESTRICTED modeB Opening the database with the RESETLOGS optionC Setting a new DBID for the newly restored databaseD Restoring the server parameter file (SPFILE) to the new host

点击查看答案
第4题

多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile

点击查看答案
第5题

单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）A configure the database to run in ARCHIVELOG modeB configure the Flash Recovery Area to enable automatic database backupC schedule the database backup using DBMS_JOB package after creating the databaseD schedule the database backup using Recovery Manager （RMAN）commands after creating the databaseE schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

点击查看答案
第6题

单选题Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A You need to perform the restore and recover operations manually, because the backup was made manually. B First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.

点击查看答案
第7题

单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）Atarget databaseBauxiliary databaseCthird-party databaseDrecovery catalog database

点击查看答案

单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You sus

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容