itgle.com

单选题You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set

题目
单选题
You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）
A

LOG_ARCHIVE_DEST was not set in the parameter file.

B

LOG_ARCHIVE_START was not set in the parameter file.

C

alter database archivelog； was not executed in MOUNT mode.

D

LOG_ARCHIVE_MAX processes were not set in the parameter file.

相似考题

1.You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

2.You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.

3.You have a domain controller that runs Windows Server 2008 and is configured as a DNS server. You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.

4.You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database.C. Create a Flashback Data Archive in the tablespace where the tables are stored.D. Create a Flashback Data Archive in any suitable tablespace.E. Enable Flashback Data Archiving for the tables that require tracking

更多“You configured automatic archive logging for the database. O”相关问题

  • 第1题：

    You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

    • A、 The database must be in the ARCHIVELOG mode.
    • B、 The automatic memory tuning must be enabled.
    • C、 The change tracking feature must be enabled.
    • D、 The automatic memory tuning must be disabled.

    正确答案:D

  • 第2题：

    Which two statements are true about the Automatic Workload Repository （AWR）（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR contains systemwide tracing and logging information.
    • C、The snapshots collected by the AWR are accessible through data dictionary views.
    • D、The snapshots collected by the AWR are used by self-tuning components in the database.

    正确答案:C,D

  • 第3题：

    Which initialization parameter must you set to enable automatic archiving？ （）

    • A、LOG_ARCHIVE_DEST
    • B、LOG_ARCHIVE_START
    • C、LOG_ARCHIVE_FORMAT
    • D、LOG_ARCHIVE_MAX_PROCESSES

    正确答案:B

  • 第4题：

    You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS server.  You need to record all inbound DNS queries to the server.  What should you configure in the DNS Manager console（）

    • A、Enable debug logging.
    • B、Enable automatic testing for simple queries.  The safer ， easier way to help you pass any IT exams.  9 / 90
    • C、Enable automatic testing for recursive queries.
    • D、Configure event logging to log errors and warnings.

    正确答案:A

  • 第5题：

    You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）

    • A、LOG_ARCHIVE_DEST was not set in the parameter file.
    • B、LOG_ARCHIVE_START was not set in the parameter file.
    • C、alter database archivelog； was not executed in MOUNT mode.
    • D、LOG_ARCHIVE_MAX processes were not set in the parameter file.

    正确答案:B

  • 第6题：

    单选题
    You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）
    A

     The database must be in the ARCHIVELOG mode.

    B

     The automatic memory tuning must be enabled.

    C

     The change tracking feature must be enabled.

    D

     The automatic memory tuning must be disabled.


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

  • 第7题：

    单选题
    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）
    A

     Enable Flashback Data Archive for the tables.

    B

     Specify undo retention guarantee for the database.

    C

     Enable supplemental logging for the database.

    D

     Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.

    E

     Create Flashback Data Archive on the tablespace on which the tables are stored.


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

  • 第8题：

    单选题
    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）
    A

     SQL Tuning Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


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

  • 第9题：

    单选题
    The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）
    A

    control file

    B

    tnsnames.ora

    C

    data dictionary

    D

    initialization parameter file


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

  • 第10题：

    单选题
    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）
    A

    Enable supplemental logging for the database.

    B

    Specify undo retention guarantee for the database

    C

    Create Flashback Data Archive in the tablespace where the tables are stored.

    D

    Create Flashback Data Archive and enable Flashback Data Archive for specific tables


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

  • 第11题：

    单选题
    You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.  What will be the implications on the archiving and the location of archive redo log files（）
    A

    Archiving will be disabled because the destination for the redo log files is missing.

    B

    The database instance will shut down and the error details will be logged in the alert log file.

    C

    Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.

    D

    Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.


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

  • 第12题：

    单选题
    You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS  server.     You need to record all inbound DNS queries to the server.     What should you configure in the DNS Manager console（）
    A

    Enable debug logging.

    B

    Enable automatic testing for simple queries.

    C

    Enable automatic testing for recursive queries.

    D

    Configure event logging to log errors and warnings.


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

  • 第13题：

    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

    • A、 SQL Tuning Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第14题：

    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

    • A、 Enable supplemental logging for the database.
    • B、 Specify undo retention guarantee for the database
    • C、 Create Flashback Data Archive in the tablespace where the tables are stored.
    • D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables

    正确答案:D

  • 第15题：

    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

    • A、 Enable Flashback Data Archive for the tables.
    • B、 Specify undo retention guarantee for the database.
    • C、 Enable supplemental logging for the database.
    • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
    • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

    正确答案:A

  • 第16题：

    You are a security administrator for your company. The network consists of a single Active Directory domain. All servers run Windows 2003 Server. All client computers run Windows XP Professional.    All computers are configured to use Automatic Updates to install updates without user intervention. Updates are scheduled to occur during o peak hours. During a security audit，you notice some client computers are not receiving updates on a regular basis. You verify that Automatic Updates is running on All client computers， and you verify that users cannot modify the Automatic Updates settings.    You need to ensure that computers on your network receive all updates.  What should you do？（）

    • A、 Enable the No auto-restart for scheduled Automatic Updates installations setting.
    • B、 Disable the Specify intranet Microsoft update service location setting.
    • C、 Enable the Remove access to use all Windows Update features setting.
    • D、 Enable the Reschedule Automatic Updates scheduled installations setting.

    正确答案:D

  • 第17题：

    单选题
    You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log？（）
    A

    LOG_ARCHIVE_DEST was not set in the parameter file.

    B

    LOG_ARCHIVE_START was not set in the parameter file.

    C

    alter database archivelog； was not executed in MOUNT mode.

    D

    LOG_ARCHIVE_MAX processes were not set in the parameter file.


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

  • 第18题：

    多选题
    You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
    A

    Flashback log files

    B

    Backups that have become obsolete

    C

    User managed backups of the data files and control files

    D

    Archived redo log files that have multiple copies in a different archive location and not backed up


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

  • 第19题：

    单选题
    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）
    A

    parallel image copy backup

    B

    backup with MAXPIECESIZE configured for the channel

    C

    parallel backup with MAXPIECESIZE configured for the channel

    D

    intrafile parallel backup


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

  • 第20题：

    单选题
    You have a domain controller that runs Windows Server 2008 and is configured as a DNS server You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）
    A

    Enable debug logging.

    B

    Enable automatic testing for simple queries.

    C

    Enable automatic testing for recursrve queries.

    D

    Configure event logging to log errors and warnings.


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

  • 第21题：

    多选题
    You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）
    A

    backup pieces

    B

    control file autobackups

    C

    copies of all the parameter files

    D

    trace file generated using BACKUP CONTROLFILE TO TRACE


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

  • 第22题：

    单选题
    You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
    A

    ASM_POWER_LIMIT

    B

    ASM_DISKSTRING

    C

    ASM_DISKGROUPS

    D

    INSTANCE_TYPE


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

  • 第23题：

    单选题
    Which initialization parameter must you set to enable automatic archiving？ （）
    A

    LOG_ARCHIVE_DEST

    B

    LOG_ARCHIVE_START

    C

    LOG_ARCHIVE_FORMAT

    D

    LOG_ARCHIVE_MAX_PROCESSES


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

  • 第24题：

    单选题
    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）
    A

     Enable supplemental logging for the database.

    B

     Specify undo retention guarantee for the database

    C

     Create Flashback Data Archive in the tablespace where the tables are stored.

    D

     Create Flashback Data Archive and enable Flashback Data Archive for specific tables


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

相关内容