V_CONTROLFILE_RECORD_SECTION
V_CONTROLFILE
V$PARAMETER
init.ora file
第1题:
In your Certkiller .com production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this?()
第2题:
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()
第3题:
In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location?()
第4题:
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?()
第5题:
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? ()
第6题:
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? ()
第7题:
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?()
第8题:
You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()
第9题:
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?()
第10题:
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?()