单选题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 a

题目
单选题
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.

相似考题

1.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

2. 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

3. 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.

4.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

更多“单选题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 a”相关问题

  • 第1题：

    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 mode
    • B、configure the Flash Recovery Area to enable automatic database backup
    • C、schedule the database backup using DBMS_JOB package after creating the database
    • D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
    • E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

    正确答案:E

  • 第2题：

    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.

    正确答案:B,C

  • 第3题：

    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=64G
    • B、Set D3_FLASH_CACHE_SIZE=64G, 64G
    • C、Set D3_FLASK_CACKE_SI2E=128G
    • D、db_flash_cache_SI2E is automatically configured by the instance at startup

    正确答案:B

  • 第4题：

    In which situation would you use static database registration for a listener（）

    • A、when multiple databases are to be registered with the listener
    • B、when DBAs need to connect remotely to start up the database instance
    • C、when users need to connect the database instance using the host naming method
    • D、when the database instance that is to be registered with the listener is configured in shared server mode

    正确答案:B

  • 第5题：

    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.

    正确答案:A

  • 第6题：

    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

    正确答案:A

  • 第7题：

    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 files
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:C

  • 第8题：

    单选题
    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 files

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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_SIZE

    B

    The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA

    C

    The database instance starts, but Automatic Memory Management is disabled

    D

    The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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；


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:B

  • 第14题：

    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.

    正确答案:E

  • 第15题：

    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；

    正确答案:D

  • 第16题：

    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

    正确答案:C

  • 第17题：

    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 performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第18题：

    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.

    正确答案:E

  • 第19题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    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 performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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=64G

    B

    Set D3_FLASH_CACHE_SIZE=64G, 64G

    C

    Set D3_FLASK_CACKE_SI2E=128G

    D

    db_flash_cache_SI2E is automatically configured by the instance at startup


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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 mode

    B

    configure the Flash Recovery Area to enable automatic database backup

    C

    schedule the database backup using DBMS_JOB package after creating the database

    D

    schedule the database backup using Recovery Manager （RMAN）commands after creating the database

    E

    schedule the database backup using Database Configuration Assistant （DBCA）while creating the database


    正确答案： B
    解析： 暂无解析

相关内容