单选题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 packageB The BACKUP_JOB packageC The DBMS_BACKUP_RESTORE pac

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

相似考题

1.You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

2. You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）A、It would attempt to start the default listenerB、It would start the most recently created listener.C、It would display an error with a message asking for the listener name to be specified.D、It would show you a list of listeners and prompts for the listener name that you want to start.

3.our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）A、Oracle Net ManagerB、Listener Control utilityC、Database Configuration AssistantD、Oracle Net Configuration Assistant

4.You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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 packageB The BACKUP_JOB packageC The DBMS_BACKUP_RESTORE pac”相关问题

  • 第1题：

    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

    • A、Application Server Control
    • B、Oracle Management Service
    • C、Oracle Enterprise Manager Repository
    • D、Oracle Enterprise Manager Database Control

    正确答案:C,D

  • 第2题：

    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

  • 第3题：

    You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）

    • A、Enable instance failover
    • B、Configure shared server
    • C、Enable database failover
    • D、Enable connect-time failover
    • E、Enable Transparent Application Failover （TAF）

    正确答案:D

  • 第4题：

    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

  • 第5题：

    You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

    • A、use enterprise manager
    • B、use DBMS_SQL package
    • C、use DBMS_AWR package
    • D、use PRVT_WORKLOAD package
    • E、query the AWR snapshot repository objects
    • F、use DBMS_WORKLOAD_REPOSITORY package

    正确答案:A,F

  • 第6题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal？（）  

    • A、You should recreate the indexes. 
    • B、You should compress the log file backups 
    • C、You should make the Dworks database use the Full recovery mode 
    • D、You should make the Dworks database use the Simple recovery mode.

    正确答案:B

  • 第7题：

    单选题
    You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


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

  • 第8题：

    单选题
    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


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

  • 第9题：

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


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

  • 第10题：

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

  • 第11题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
    A

    Control file

    B

    Password file

    C

    Parameter file

    D

    Online redo log file

    E

    Listener controller file

    F

    Server parameter file


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

  • 第12题：

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

  • 第13题：

    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第14题：

    You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）

    • A、AFTER CREATE
    • B、AFTER SUSPEND
    • C、BEFORE CREATE
    • D、AFTER TRUNCATE
    • E、BEFORE SUSPEND
    • F、AFTER INSERT OR DELETE OR DELETE
    • G、BEFORE INSERT OR DELETE OR DELETE

    正确答案:B

  • 第15题：

    You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

    • A、use enterprise manager
    • B、use DBMS_SQL package
    • C、use DBMS_AWR package
    • D、use PRVT_WORKLOAD package
    • E、query the AWR snapshot repository objects
    • F、use DBMS_WORKLOAD_REPOSITORY package

    正确答案:A,F

  • 第16题：

    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

    • A、Hot backup
    • B、Online backup
    • C、consistent backup
    • D、incremental backup
    • E、inconsistent backup

    正确答案:C

  • 第17题：

    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第18题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第19题：

    单选题
    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
    A

     Oracle Net Manager

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第20题：

    单选题
    You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）
    A

    It would attempt to start the default listener

    B

    It would start the most recently created listener.

    C

    It would display an error with a message asking for the listener name to be specified.

    D

    It would show you a list of listeners and prompts for the listener name that you want to start.


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

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第22题：

    单选题
    You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）
    A

    Enable instance failover

    B

    Configure shared server

    C

    Enable database failover

    D

    Enable connect-time failover

    E

    Enable Transparent Application Failover （TAF）


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

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）
    A

    AFTER CREATE

    B

    AFTER SUSPEND

    C

    BEFORE CREATE

    D

    AFTER TRUNCATE

    E

    BEFORE SUSPEND

    F

    AFTER INSERT OR DELETE OR DELETE

    G

    BEFORE INSERT OR DELETE OR DELETE


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

  • 第24题：

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

相关内容