itgle.com

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

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

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

4.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 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.”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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 files
    • B、 the redo log files
    • C、 the control file
    • D、 the change tracking file

    正确答案:A

  • 第6题：

    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 file
    • B、any archive log file
    • C、one of the redo log members
    • D、loss of the initialization parameter file
    • E、any data file belonging to the default permanent tablespac

    正确答案:A

  • 第7题：

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


    正确答案： E,C
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    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 file

    B

    any archive log file

    C

    one of the redo log members

    D

    loss of the initialization parameter file

    E

    any data file belonging to the default permanent tablespac


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    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,D
    解析： 暂无解析

  • 第11题：

    单选题
    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 files

    B

     the redo log files

    C

     the control file

    D

     the change tracking file


    正确答案： C
    解析： 暂无解析

  • 第12题：

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

    B

    the protocol used by the listener

    C

    the server name where the listener runs

    D

    the log file and trace file destination for the listener

    E

    the database services to be registered with the listener


    正确答案： A,B,C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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 listener
    • B、the protocol used by the listener
    • C、the server name where the listener runs
    • D、the log file and trace file destination for the listener
    • E、the database services to be registered with the listener

    正确答案:A,B,C

  • 第18题：

    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.

    正确答案:A,C,D

  • 第19题：

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


    正确答案： C,D
    解析： 暂无解析

  • 第20题：

    多选题
    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,A
    解析： 暂无解析

  • 第21题：

    多选题
    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
    解析： 暂无解析

  • 第22题：

    多选题
    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,A
    解析： 暂无解析

  • 第23题：

    多选题
    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？（）
    A

    V$LOGFILE

    B

    V$RECOVER_LOG

    C

    V$RECOVER_DATABASE

    D

    V$LOG_RECOVER

    E

    V$LOG


    正确答案： A,D
    解析： 暂无解析

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容