niusouti.com

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It

题目

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()

  • A、It is a SQL script.
  • B、It is a PL/SQL file.
  • C、It is an operating system (OS) file.
  • D、It is a Recovery Manager (RMAN) script

相似考题
更多“You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It”相关问题
  • 第1题:

    You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this? ()

    • A、The DBMS_JOB package
    • B、The BACKUP_JOB package
    • C、The DBMS_BACKUP_RESTORE package
    • D、The calendar tool in the Operating System (OS)
    • E、The backup scheduler in Enterprise Manager (EM)
    • F、The DBMS_BACKUP_SCHEDULER packager inline mode

    正确答案:E

  • 第2题:

    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script:   SQL>@utlu111i.sql   Which statement about the execution of this script is true?()

    • A、 It must be executed from the Oracle Database 11g environment.
    • B、 It must be executed only after the SYSAUX tablespace has been created.
    • C、 It must be executed from the environment of the database that is being upgraded.
    • D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
    • E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

    正确答案:C

  • 第3题:

    You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this()

    • A、the XML script
    • B、the PL/SQL script
    • C、the DBMS_SCHEDULER package
    • D、Enterprise Manager to schedule the backup

    正确答案:D

  • 第4题:

    You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based?()

    • A、 column sizes
    • B、 column data types
    • C、 PCTFREE
    • D、 projected number of row
    • E、 PCTUSED

    正确答案:E

  • 第5题:

    You issue this RMAN command:   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   (database include current controlfile);   sql ‘alter database archive log current’;   }  Which three statements are true about the Level0Backup script you just created?()

    • A、The script is stored only in the control file.
    • B、The script is stored only in the recover catalog.
    • C、The script can be executed only by using the RMAN RUN command.
    • D、The commands of the script can be displayed with the LIST command.
    • E、The commands of the script can be displayed with the PRINT command.
    • F、The commands of the script can be displayed with the REPORT command.

    正确答案:B,C,E

  • 第6题:

    单选题
    You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler()
    A

    XML script

    B

    PL/SQL script

    C

    Operating system script

    D

    Recovery Manager (RMAN) script


    正确答案: B
    解析: 暂无解析

  • 第7题:

    单选题
    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()
    A

     space allocated in the tablespace

    B

     space required for the bitmap index on a column of the table

    C

     space remaining in the tablespace after creating the table

    D

     estimated value of the PCTFREE storage parameter


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

  • 第8题:

    单选题
    You issued the following statement:  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What will be the result of issuing the statement?()
    A

     The control file will be multiplexed.

    B

     The control file will be recreated.

    C

    The script containing the CREATE CONTROLFILE statement will be created.

    D

     The binary backup of the control file will be created.


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

  • 第9题:

    单选题
    You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based?()
    A

     column sizes

    B

     column data types

    C

     PCTFREE

    D

     projected number of row

    E

     PCTUSED


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

  • 第10题:

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script:   SQL>@utlu111i.sql   Which statement about the execution of this script is true?()
    A

     It must be executed from the Oracle Database 11g environment.

    B

     It must be executed only after the SYSAUX tablespace has been created.

    C

     It must be executed from the environment of the database that is being upgraded.

    D

     It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

     It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第11题:

    单选题
    You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this()
    A

    the XML script

    B

    the PL/SQL script

    C

    the DBMS_SCHEDULER package

    D

    Enterprise Manager to schedule the backup


    正确答案: A
    解析: 暂无解析

  • 第12题:

    单选题
    You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()
    A

    It is a SQL script.

    B

    It is a PL/SQL file.

    C

    It is an operating system (OS) file.

    D

    It is a Recovery Manager (RMAN) script


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

  • 第13题:

    Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressedmode for an installation()

    • A、Run the root.sh script.
    • B、Create the oraInst.loc file.
    • C、Create the tnsnames.ora file.
    • D、Run the oraintRoot.sh script.

    正确答案:B

  • 第14题:

    You issued the following statement:  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What will be the result of issuing the statement?()  

    • A、 The control file will be multiplexed.
    • B、 The control file will be recreated.
    • C、The script containing the CREATE CONTROLFILE statement will be created.
    • D、 The binary backup of the control file will be created.

    正确答案:C

  • 第15题:

    You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? ()

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System (OS) script
    • D、Enterprise Manager (EM) script
    • E、Recovery Manager (RMAN) script

    正确答案:E

  • 第16题:

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

    正确答案:C

  • 第17题:

    You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()

    • A、 space allocated in the tablespace
    • B、 space required for the bitmap index on a column of the table
    • C、 space remaining in the tablespace after creating the table
    • D、 estimated value of the PCTFREE storage parameter

    正确答案:A

  • 第18题:

    单选题
    You backed up the control file to trace. Which statement is true about the trace file generated?()
    A

    The trace file is in binary format.

    B

    The trace file has a SQL script to re-create the control file.

    C

    The trace file is a backup set created during the backup of the control file. 

    D

    The trace file contains the instructions to manually re-create the control file.

    E

    The trace file is an image copy of the control file created during the backup of the control file.


    正确答案: B
    解析: 暂无解析

  • 第19题:

    单选题
    You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler()
    A

    XML script

    B

    PL/SQL script

    C

    Operating system scriptThis document was downloaded from =>> http://www.amaderforum.com

    D

    Recovery Manager (RMAN) script


    正确答案: A
    解析: 暂无解析

  • 第20题:

    单选题
    You want to configure and schedule offline database backups to run automatically.  Which tool or utility wouldyou use to achieve this()
    A

    The XML script

    B

    The PL/SQL script

    C

    The DBMS_SCHEDULER package

    D

    Enterprise Manager to schedule the backup


    正确答案: B
    解析: 暂无解析

  • 第21题:

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).


    正确答案: E
    解析: 暂无解析

  • 第22题:

    单选题
    You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()
    A

    SQL script

    B

    PL/SQL script

    C

    Operating System (OS) script

    D

    Enterprise Manager (EM) script

    E

    Recovery Manager (RMAN) script


    正确答案: E
    解析: 暂无解析

  • 第23题:

    单选题
    You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this?()
    A

    The DBMS_JOB package

    B

    The BACKUP_JOB package

    C

    The DBMS_BACKUP_RESTORE package

    D

    The calendar tool in the Operating System (OS)

    E

    The backup scheduler in Enterprise Manager (EM)

    F

    The DBMS_BACKUP_SCHEDULER packager inline mode


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