V_CONTROLFILE_RECORD_SECTION
V_CONTROLFILE
V$PARAMETER
init.ora file
第1题:
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()
第2题:
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? ()
第3题:
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?()
第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?()
第5题:
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?()
第6题:
The loss of the control file forced you to re-create the control file. After re-creating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five-digit number starting with 0. What could be the possible reason?()
第7题:
V_CONTROLFILE_RECORD_SECTION
V_CONTROLFILE
V$PARAMETER
init.ora file
第8题:
the trace file
the alert log file
an RMAN session log file
the server parameter file
the formatted name of a control file autobackup
第9题:
Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
第10题:
to enable the ASM instance to identify the alert log file
to enable the ASM instance to identify the server parameter file
to enable the ASM instance to define the locations for Oracle Managed Files (OMF)
to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
第11题:
Modify the value for the UTL_FILE_DIR parameter in the parameter file
Grant read and write privilege on the operating system path to the database users
Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
Create a directory object referring to the operating system path, and grant read and write privilege on the directory object to the database users
第12题:
These are the data files that are corrupted.
There is no SYSAUX tablespace in your database
There is a read-only tablespace in your database.
These are the data files that cannot be recovered.
第13题:
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry: ASM_DISKSTRING = /devices/* What could be the reason for this setting?()
第14题:
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?()
第15题:
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?()
第16题:
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery?()
第17题:
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?()
第18题:
USER_DUMP_DEST
CORE_DUMP_DEST
TRACE_DUMP_DEST
BACKUP_DUMP_DEST
BACKGROUND_DUMP_DEST
第19题:
Shut down the instance, copy the control file to the third location and open the database.
Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
Copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile, restart the instance and open the database.
Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in theinit.orafile and open the database.
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.
第20题:
V$LOG
V$LOGFILE
DBA_LOG_GROUPS
V$LOG_HISTORY
第21题:
backup pieces
control file autobackups
copies of all the parameter files
trace file generated using BACKUP CONTROLFILE TO TRACE
第22题:
These are the data files that are corrupted.
There is no SYSAUX tablespace in your database
There is a readonly tablespace in your database.
These are the data files that cannot be recovered.
第23题:
the alert log file
the server parameter file
the formatted name of a control file autobackup
an RMAN session log file
the trace file
第24题:
the V$LOG view
the V$DBFILE view
the V$LOGFILE view
the V$INSTANCE_RECOVERY view
Oracle Enterprise Manager Database Control