单选题You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()AUSER_DUMP_DESTBCORE_DUMP_DESTCALERT_LOG_DESTDALERT_DUMP_DESTETRACE_DUMP_DESTFBACKGROUND_DUMP_DEST
单选题
You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()
A
USER_DUMP_DEST
B
CORE_DUMP_DEST
C
ALERT_LOG_DEST
D
ALERT_DUMP_DEST
E
TRACE_DUMP_DEST
F
BACKGROUND_DUMP_DEST
参考解析
解析:
暂无解析
相关考题:
You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old In which situation would you receive such an error?()A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()A、 the alert log fileB、 the server parameter fileC、 the formatted name of a control file autobackupD、 an RMAN session log fileE、 the trace file
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup
You work as a database administrator for Certkiller .com. 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 openedB、All redo files are openedC、The password file is openedD、The parameter file is openedE、All online data files are opened
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file, just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()A、USER_DUMP_DESTB、CORE_DUMP_DESTC、ALERT_LOG_DESTD、ALERT_DUMP_DESTE、TRACE_DUMP_DESTF、BACKGROUND_DUMP_DEST
You work as a database administrator for Supportcenter.cn. 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.
You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA). You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()A、Control fileB、Password fileC、Parameter fileD、Online redo log fileE、Listener controller fileF、Server parameter file
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()A、USER_DUMP_DESTB、CORE_DUMP_DESTC、ALERT_LOG_DESTD、ALERT_DUMP_DESTE、TRACE_DUMP_DESTF、BACKGROUND_DUMP_DEST
You work as a database administrator for Certkiller .com. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.
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.
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 work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()AHot backupBOnline backupCconsistent backupDincremental backupEinconsistent backup
单选题You work as a database administrator for Supportcenter.cn. 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?()AShut down the instance, copy the control file to the third location and open the database.BAbort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.CCopy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.DShut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.EShut 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.
单选题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 work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()AUSER_DUMP_DESTBCORE_DUMP_DESTCALERT_LOG_DESTDALERT_DUMP_DESTETRACE_DUMP_DESTFBACKGROUND_DUMP_DEST
单选题You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA). You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()AControl fileBPassword fileCParameter fileDOnline redo log fileEListener controller fileFServer parameter file
单选题You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()AUSER_DUMP_DESTBCORE_DUMP_DESTCALERT_LOG_DESTDALERT_DUMP_DESTETRACE_DUMP_DESTFBACKGROUND_DUMP_DEST
单选题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?()AShut down the instance, copy the control file to the third location and open the database.BAbort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.CCopy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.DShut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.EShut 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.
单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old In which situation would you receive such an error?()AYou performed rollback after commit.BIf a log switch occurs in your database.CThearchiverfails to generate an archived log file.DInstance recovery fails to find one of the redo log files.EA long-running query is unable to get read-consistent image.FIf you perform manual undo management operations in auto mode.
单选题You work as a database administrator for Certkiller .com. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()AThe trace fileBThe fixed viewsCThe data dictionary viewsDThe operating system log fieldsEThe dynamic performance views.
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file, just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files?()A Oracle Enterprise ManagerB The V$LOG viewC The V$LOGFILE viewD The V$FLASHBACK_DATABASE_LOGS view
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A Query the V$FLASHBACK_DATABASE_LOG view.B Query the V$FLASHBACK_DATABASE_STAT view.C Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D Query the V$RECOVERY_FILE_DEST view.
单选题You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()AUSER_DUMP_DESTBCORE_DUMP_DESTCALERT_LOG_DESTDALERT_DUMP_DESTETRACE_DUMP_DESTFBACKGROUND_DUMP_DEST