多选题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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.


参考答案:B, D

第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


正确答案:D

第3题:

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece


参考答案:B, C, E

第4题:

Which two file types must be included in a closed database backup taken with operating system commands?()

  • A、data files
  • B、control file
  • C、password file
  • D、online redo log files
  • E、initialization parameter file

正确答案:A,B

第5题:

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.

正确答案:A,B,E

第6题:

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.


参考答案:A, B, E

第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?()

  • A、 Database Identifier (DBID)
  • B、 names and location of datafiles
  • C、 names and location of control files
  • D、 names and location of online redo log files

正确答案:A

第8题:

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 file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece


参考答案:B, C, E

第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?()

  • 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.

正确答案:D

第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?()

  • 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.

正确答案:A,C

更多相关问题