To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）A、It results in an error because these parameter settings are invalid.B、One 64G flash cache file will be used.C、Two 64G flash cache files will be used.D、Two 32G flash cache files will be used.
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）
- A、It results in an error because these parameter settings are invalid.
- B、One 64G flash cache file will be used.
- C、Two 64G flash cache files will be used.
- D、Two 32G flash cache files will be used.
相关考题：
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC. The database instance starts, but Automatic Memory Management is disabledD. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true？（）A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、 The database instance starts，but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
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.
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
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）A、 The backup will not be performed at all.B、 three timesC、 four timesD、 six times
Identify two situations in which you can use Data Recovery Advisor for recovery.（） A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.
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？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）A、Set DB_FLASH_CACHE_SIZE=64GB、Set D3_FLASH_CACHE_SIZE=64G, 64GC、Set D3_FLASK_CACKE_SI2E=128GD、db_flash_cache_SI2E is automatically configured by the instance at startup
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
In which situation would you use static database registration for a listener（）A、when multiple databases are to be registered with the listenerB、when DBAs need to connect remotely to start up the database instanceC、when users need to connect the database instance using the host naming methodD、when the database instance that is to be registered with the listener is configured in shared server mode
Which three actions are required to configure the Flashback Database? （）A、set Flash Recovery AreaB、enable Flashback loggingC、create FLASHBACK tablespaceD、start the database in the ARCHIVELOG modeE、start the database in the NOARCHIVELOG mode
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（）A、Multiplex all database files.B、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)A、The user has dropped an important table that needs to be recovered.B、The database files are corrupted when the database is open.C、You are not able to start up the database instance because the required database files are missing.D、The archived log files are missing for which backup is not available.
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）A、When the instance is started B、When the database is mounted C、When the database is opened D、When the database is closed
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller 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？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
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（）A、Multiplex all database filesB、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter.
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（） A、For the AdventureWorks database, enable Server Auditing B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C、You should configure the data collector and make it capture the deadlock graphsD、You should configure a SQL Profiler trace, and make it capture the deadlock graphs
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）AEnable the flash recovery area and specify it as the archived redo log destination.BDisable the flash recovery area and start the database instance in ARCHIVELOG mode.CEnable the flash recovery area but do not specify it as the archived redo log destination.DDisable the flash recovery area and start the database instance in NOARCHIVELOG mode
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination. D Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
单选题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
单选题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？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
单选题To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）AIt results in an error because these parameter settings are invalid.BOne 64G flash cache file will be used.CTwo 64G flash cache files will be used.DTwo 32G flash cache files will be used.
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；