网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?()

  • A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
  • B、They are created only in the Fast Recovery Area.
  • C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
  • D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

参考答案

更多 “ You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?()A、They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.B、They are created only in the Fast Recovery Area.C、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.D、They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.” 相关考题
考题 Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?() A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant

考题 You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_RECOVERY_FILE = ‘/u01/oradata’Which statement is true about the archived redo log files?()A. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.B. They are created only in the Fast Recovery Area.C. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.D. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

考题 Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance

考题 Which view will you use to view information regarding the jobs that are currently running in a database?()A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG

考题 Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure

考题 In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this? ()A、%t_%s.dbfB、arch_%t.arcC、arch_%d.arcD、arch_%t_%d.arcE、arch_%d_%s_.dbfF、arch_%t_%s_%r.arc

考题 The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()A、You should perform a log switchB、You should make a backup of the databaseC、You should switch the database to the NONARCHIVELOG modeD、You should shut down the database instance and perform a complete database recovery

考题 Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()A、You can perform open database backups.B、You can perform closed database backups.C、You cannot perform schema-level logical backups.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener?()A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant

考题 单选题You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to, in order to determine the appropriate indexes?()A Memory AdvisorsB Segment AdvisorsC SQL Tuning and Access AdvisorsD Automated Workload Repository (AWR)E Automatic Database Diagnostic Monitor (ADDM)

考题 单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()A  Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B  Oracle will automatically take the datafile out of hot backup mode and then open the database.C  Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D  The database will open with the file in hot backup mode. You can restart the backup at any time.E  The datafile in hot backup mode will be corrupted and you will have to recover it.

考题 多选题You are managing an Oracle Database 11g database. The database is open, and you plan to  performRecovery Manager (RMAN) backups.  Which three statements are true about these backups()AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure.

考题 单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener?()A  Oracle Net ManagerB  Listener Control utilityC  Database Configuration AssistantD  Oracle Net Configuration Assistant

考题 单选题Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()A Oracle Net ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant

考题 单选题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:   LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional,you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch?()A  The online redo log file Is not allowed to be overwritten.B  The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.C  The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.D  The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

考题 单选题You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?()A They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.B They are created only in the Fast Recovery Area.C They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.D They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.

考题 多选题Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago, you just archived arch_4.arch to tape, then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today, you see arch_3.arc in the archive directory.  Which two could you happened?()ARedo logs were restored from tape for recovery.BThe file names are only used when they are copied to tape.CThe database was opened with the RESETLOGS option and log numbers restarted.DLog names run in circular fashion; arch_3.arc is re-created by the ARCn process.EA file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.

考题 单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose?()A Place each database in a separate instance running on SQL2.B Place each database in a separate instance running on SQL3.C Place both databases in a single instance running on SQL2.D Place both databases in a single instance running on SQL3.

考题 单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()A Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesB Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

考题 多选题You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure

考题 单选题Which view will you use to view information regarding the jobs that are currently running in a database?()A DBA_SCHEDULER_RUNNING_JOBSB DBA_SCHEDULER_JOB_RUN_DETAILSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG

考题 多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance

考题 多选题Half of your network uses RIPv2 and the other half runs OSPF. The networks do not communicate with each other. Which two of these factors describe the impact of activating EIGRP over each separate part?()AEIGRP will not be accepted when configured on the actual RIPv2 routers.BOSPF will no longer be used in the routing table, because you only have EIGRP internal routes running.COSPF will no longer be used in the routing table, because you only have EIGRP external routes running.DRIPv2 will populate its RIP database but not its routing table, because you only have EIGRP external routes running.ERIPv2 will populate its RIP database but not its routing table, because you only have EIGRP internal routes running.FOSPF database will have RIPv2 routes.

考题 多选题You work as a database administrator for Supportcenter.cn. You want to administer your database servers, which are running on different host machines, using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()AApplication Server ControlBOracle Management ServiceCOracle Enterprise Manager RepositoryDOracle Enterprise Manager Database Control

考题 单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;   Which action should you perform immediately after using this command?()A  You should perform a log switchB  You should make a backup of the databaseC  You should switch the database to the NONARCHIVELOG modeD  You should shut down the database instance and perform a complete database recovery

考题 单选题What will be the result of the following configuration?()   Log_archive_dest_1=location=c:/oracle/arch/mydb Log_archive_dest_2=location=z:/oracle/arch/mydbA  An error will occur during database startup because the second parameter is not valid.B  An error will occur during database startup since you are trying to create archived redo logs in two different locations.C  Archived redo logs will be created in two different locations by the ARCH process.D  Archived redo logs will be created in two different locations by the LGWR process.E  Neither parameter setting is valid, so the database will not start up.