单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A V_CONTROLFILE_RECORD_SECTION B V_CONTROLFILE C V$PARAMETER D init.ora file

题目

单选题

If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）

V_CONTROLFILE_RECORD_SECTION

V_CONTROLFILE

V$PARAMETER

init.ora file

更多“单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A V_CONTROLFILE_RECORD_SECTION B V_CONTROLFILE C V$PARAMETER D init.ora file”相关问题

第1题

You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（） A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

点击查看答案
第2题

The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0. What could be the possible reason？（）A、These are the data files that are corrupted.B、There is no SYSAUX tablespace in your databaseC、There is a readonly tablespace in your database.D、These are the data files that cannot be recovered.

点击查看答案
第3题

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 viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control

点击查看答案
第4题

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.

点击查看答案
第5题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）A、You find that one of the redo log members in each redo log group is lost.B、You find that a data file that belongs to the USERS tablespace is damaged.C、You find that a data file that belongs to the SYSTEM tablespace is damaged.D、You find that the current redo log group is damaged and is not available for recovery.E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

点击查看答案
第6题

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.

点击查看答案
第7题

If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A、V_CONTROLFILE_RECORD_SECTION B、V_CONTROLFILE C、V$PARAMETER D、init.ora file

点击查看答案

单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A V_CONTROLFILE_RECORD_SECTION B V_CONTROLFILE C V$PARAMETER D init.ora file

题目

更多“单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A V_CONTROLFILE_RECORD_SECTION B V_CONTROLFILE C V$PARAMETER D init.ora file”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容