多选题In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not size

题目
多选题
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
A

the V$LOG view

B

the V$DBFILE view

C

the V$LOGFILE view

D

the V$INSTANCE_RECOVERY view

E

Oracle Enterprise Manager Database Control

相似考题

1.Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUsC. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaD. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

2.You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  A、 Restore and recover the datafile.B、 Restore and recover the tablespace.C、 Restore and recover the database.D、 Restore and recover the control file.E、 Restore and recover the parameter file.

3.In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）A、the alert log fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files

4.You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

更多“In the parameter file of your production database， the FAST_”相关问题

  • 第1题：

    You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

    • A、 0
    • B、 1
    • C、 NONE
    • D、 DEFAULT

    正确答案:A

  • 第2题：

    You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

    • A、Mount the database
    • B、Open the database in NORMAL mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:A

  • 第3题：

    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

    • A、to enable operating system authentication for a remote client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第4题：

    In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）

    • A、 The backup would be retained on the media for 31 days.
    • B、 The backup would be maintained in the recovery catalog for 31 days.
    • C、 The backup metadata would be retained in the control file for 31 days.
    • D、 The backup metadata would be maintained in the recovery catalog for 31 days.
    • E、 Automatic backups of the control file will be retained in the flash recovery area for 31 days.

    正确答案:C

  • 第5题：

    单选题
    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
    A

    to enable operating system authentication for a remote client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


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

  • 第6题：

    单选题
    In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）
    A

     The backup would be retained on the media for 31 days.

    B

     The backup would be maintained in the recovery catalog for 31 days.

    C

     The backup metadata would be retained in the control file for 31 days.

    D

     The backup metadata would be maintained in the recovery catalog for 31 days.

    E

     Automatic backups of the control file will be retained in the flash recovery area for 31 days.


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

  • 第7题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
    A

     Restore and recover the datafile.

    B

     Restore and recover the tablespace.

    C

     Restore and recover the database.

    D

     Restore and recover the control file.

    E

     Restore and recover the parameter file.


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

  • 第8题：

    单选题
    You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
    A

     0

    B

     1

    C

     NONE

    D

     DEFAULT


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

  • 第9题：

    单选题
    You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
    A

    Shut down the instance， copy the control file to the third location and open the database.

    B

    Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    C

    Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.

    D

    Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    E

    Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.


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

  • 第10题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


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

  • 第11题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

  • 第12题：

    You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

    • A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
    • C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    正确答案:A

  • 第13题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第14题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第15题：

    You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）

    • A、Shut down the instance， copy the control file to the third location and open the database.
    • B、Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
    • C、Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.
    • D、Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
    • E、Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

    正确答案:D

  • 第16题：

    单选题
    You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

     mount the new disk group in the ASM instance

    B

     restart the ASM instance and the production database instance

    C

     register the new disk groups in the production database instance

    D

     restart the ASM instance without restarting the production database instance

    E

     include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


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

  • 第17题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


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

  • 第18题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
    A

    Restore and recover the datafile. 

    B

    Restore and recover the tablespace. 

    C

    Restore and recover the database. 

    D

    Restore and recover the control file. 

    E

    Restore and recover the parameter file.


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

  • 第19题：

    单选题
    In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application.  You want to restrict the database users to access files in a specific location on the host machine.  What could do to achieve this？（）
    A

    Modify the value for the UTL_FILE_DIR parameter in the parameter file

    B

    Grant read and write privilege on the operating system path to the database users

    C

    Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file

    D

    Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file

    E

    Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users


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

  • 第20题：

    多选题
    Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）
    A

    Setting the FAST_START_MTTR_TARGET to set the mean time to recover

    B

    Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

    C

    Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

    D

    Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area


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

  • 第21题：

    多选题
    In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）
    A

    the alert log file

    B

    the core dump files

    C

    the change tracking file

    D

    the user session trace files

    E

    the database audit trail files

    F

    the background process trace files


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

  • 第22题：

    多选题
    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？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


    正确答案： G,F
    解析： 暂无解析

相关内容