Current log sequence.
Recover tuning parameters.
Redo log names and locations.
Data file names and locations.
Undo segment names and locations.
第1题:
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.
第2题:
The Master or person in charge of a ship is required to log ______.
A.the names of all persons on board
B.only the names of the crew members on board
C.only the names of passengers on board
D.information on emergency training drills
第3题:
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
第4题:
Which two file types must be included in a closed database backup taken with operating system commands?()
第5题:
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?()
第6题:
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.
第7题:
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?()
第8题:
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece
第9题:
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?()
第10题:
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?()