单选题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？（）ALOG_ARCHIVE_DEST was not set in the parameter file.BLOG_ARCHIVE_START was not set in the parameter file.Calter database archivelog； was not executed in MOUNT mode.DLOG_ARCHIVE_MAX processes were not set in the parameter file.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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 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.
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.
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.
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 AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
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.
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
Which initialization parameter must you set to enable automatic archiving？ （）A、LOG_ARCHIVE_DESTB、LOG_ARCHIVE_STARTC、LOG_ARCHIVE_FORMATD、LOG_ARCHIVE_MAX_PROCESSES
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.
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 / 90C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.
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.
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.
单选题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.
多选题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（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up
单选题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.
单选题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?（）Aparallel image copy backupBbackup with MAXPIECESIZE configured for the channelCparallel backup with MAXPIECESIZE configured for the channelDintrafile parallel backup
单选题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 AdvisorB Undo AdvisorC ADDMD Memory Advisor
单选题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（）AEnable debug logging.BEnable automatic testing for simple queries.CEnable automatic testing for recursrve queries.DConfigure event logging to log errors and warnings.
单选题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？（）Acontrol fileBtnsnames.oraCdata dictionaryDinitialization parameter file
多选题You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）Abackup piecesBcontrol file autobackupsCcopies of all the parameter filesDtrace file generated using BACKUP CONTROLFILE TO TRACE
单选题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?（）AEnable supplemental logging for the database.BSpecify undo retention guarantee for the databaseCCreate Flashback Data Archive in the tablespace where the tables are stored.DCreate Flashback Data Archive and enable Flashback Data Archive for specific tables
单选题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?（）AASM_POWER_LIMITBASM_DISKSTRINGCASM_DISKGROUPSDINSTANCE_TYPE
单选题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（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
单选题Which initialization parameter must you set to enable automatic archiving？ （）ALOG_ARCHIVE_DESTBLOG_ARCHIVE_STARTCLOG_ARCHIVE_FORMATDLOG_ARCHIVE_MAX_PROCESSES
单选题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（）AEnable debug logging.BEnable automatic testing for simple queries.CEnable automatic testing for recursive queries.DConfigure event logging to log errors and warnings.
单选题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