多选题Which three types of information does the control file contain？（）ACurrent log sequence.BRecover tuning parameters.CRedo log names and locations.DData file names and locations.EUndo segment names and locations.
多选题
Which three types of information does the control file contain？（）
A
Current log sequence.
B
Recover tuning parameters.
C
Redo log names and locations.
D
Data file names and locations.
E
Undo segment names and locations.
参考解析
解析：
暂无解析
相关考题：
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() (Choose three.) A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
Which two statements are true about Oracle Managed Files (OMF)?() A. OMF cannot be used in a database that already has data files created with user-specified directions.B. The file system directions that are specified by OMF parameters are created automatically.C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.D. OMF automatically creates unique file names for table spaces and control files.E. OMF may affect the location of the redo log files and archived log files.
Examine the contents of SQL loader control file:Which three statements are true regarding the SQL* Loader operation performed using the control file?() A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.C. The SQL* Loader operation fails because no record terminators are specified.D. Field names should be the first line in the both the SQL* Loader data files.E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
The Master or person in charge of a ship is required to log ______.A.the names of all persons on boardB.only the names of the crew members on boardC.only the names of passengers on boardD.information on emergency training drills
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A、 Database Identifier （DBID）B、 names and location of datafilesC、 names and location of control filesD、 names and location of online redo log files
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.C、The SQL* Loader operation fails because no record terminators are specified.D、Field names should be the first line in the both the SQL* Loader data files.E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.
Which two file types must be included in a closed database backup taken with operating system commands？（）A、data filesB、control fileC、password fileD、online redo log filesE、initialization parameter file
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？（）A、Redo logs were restored from tape for recovery. B、The file names are only used when they are copied to tape. C、The database was opened with the RESETLOGS option and log numbers restarted. D、Log names run in circular fashion; arch_3.arc is re-created by the ARCn process. E、A file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)A、Alert log fileB、Archived redo log filesC、Control file autobackupsD、Server Parameter file (SPFILE)E、Recovery Manager (RMAN) backup piece
Which three types of files can be automatically placed in the flash recovery area fast recovery area in 11g Release 2？（）A、 Alert log fileB、 Archived redo log filesC、 Control file autobackupsD、 Server Parameter file （SPFILE）E、 Recovery Manager （RMAN） backup piece
You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A、the alert log file and the trace filesB、 the redo log filesC、 the control fileD、 the change tracking file
Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）A、the port used by the listenerB、the protocol used by the listenerC、the server name where the listener runsD、the log file and trace file destination for the listenerE、the database services to be registered with the listener
Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）A、any control fileB、any archive log fileC、one of the redo log membersD、loss of the initialization parameter fileE、any data file belonging to the default permanent tablespac
Which three types of information does the control file contain？（）A、Current log sequence.B、Recover tuning parameters.C、Redo log names and locations.D、Data file names and locations.E、Undo segment names and locations.
多选题Which three types of information does the control file contain？（）ACurrent log sequence.BRecover tuning parameters.CRedo log names and locations.DData file names and locations.EUndo segment names and locations.
多选题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 are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A Database Identifier （DBID）B names and location of datafilesC names and location of control filesD names and location of online redo log files
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
单选题Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）Aany control fileBany archive log fileCone of the redo log membersDloss of the initialization parameter fileEany data file belonging to the default permanent tablespac
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
多选题Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）AAn EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.BThe SQL* Loader data file myfile1.dat has the column names for the EMP table.CThe SQL* Loader operation fails because no record terminators are specified.DField names should be the first line in the both the SQL* Loader data files.EThe SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatically.COMF can be used with ASM disk groups, as well as with raw devices, for better file management.DOMF automatically creates unique file names for table spaces and control files.EOMF may affect the location of the redo log files and archived log files.
单选题You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）Athe alert log file and the trace filesB the redo log filesC the control fileD the change tracking file
多选题During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information？（）AV$LOGFILEBV$RECOVER_LOGCV$RECOVER_DATABASEDV$LOG_RECOVEREV$LOG
多选题Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）Athe port used by the listenerBthe protocol used by the listenerCthe server name where the listener runsDthe log file and trace file destination for the listenerEthe database services to be registered with the listener
单选题The Master or person in charge of a ship is required to log（）.Athe names of all persons on boardBonly the names of the crew members on boardConly the names of passengers on boardDinformation on emergency training drills