You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area

题目

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

  • A、Enable the flash recovery area and specify it as the archived redo log destination.
  • B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
  • C、Enable the flash recovery area but do not specify it as the archived redo log destination.
  • D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
相似考题

1.You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.

2.You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）A. Enable Memory Access Mode, which reads performance data from SGA.B. Use emergency monitoring to fetch data directly from SGA analysis.C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.E. Run ADDM in diagnostic mode.

3.In which three cases would you use the USING clause?（）A、You want to create a nonequijoin.B、The tables to be joined have multiple NULL columns.C、The tables to be joined have columns of the same name and different data types.D、The tables to be joined have columns with the same name and compatible data types.E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

4.Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

更多“You want to use the automatic ma”相关问题

  • 第1题：

    You want the size of the tablespace to increase when it is full. Which option would you use？（）

    • A、use automatic extent allocation
    • B、disable threshold for the tablespace
    • C、use freelists to manage the free space
    • D、use automatic segment space management
    • E、create the tablespace as a bigfile tablespace
    • F、use the RESIZE clause while creating the tablespace
    • G、enable AUTOEXTEND for at least one of the data files in the tablespace

    正确答案:G

  • 第2题：

    You use a Windows 2000 Professional desktop computer. The corporate product information is stored on this computer. You want other users on the network to be able to read the product information on your computer. You use Windows Explorer to share the product information folder on the network. You want Sales staff to be able to keep a copy of the product information on their portable computers when they travel. Other users should not be able to synchronize the product information.  What should you do?（）

    • A、Use Synchronization manager to configure synchronization to occur when users are connected to the LAN connection.
    • B、Use Windows Explorer to grant Sales Staff Special access for the reports on the network share.
    • C、Use Windows Explorer to enable automatic caching for documents on the network share.
    • D、Create a new share for the Sales users only and enable caching on that share only.

    正确答案:D

  • 第3题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第4题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第5题：

    Which of the following would you use to enable automatic media recovery for a database？（）

    • A、SET AUTORECOVERY ON
    • B、SET RECOVERY ON
    • C、SET AUTO ON
    • D、You cannot enable automatic media recovery.

    正确答案:A

  • 第6题：

    You install Windows 2000 Professional on your portable computer. You install an SCSI and PC card adapter, that you can use in the office to use color scanner. You use a docking station for your computer when you are in the office. You want to maximize the battery performance for your portable computer. You also want to prevent the driver from loading whenever you are away from the office. What should you do?（）

    • A、When away from the office use Device Manager to remove the adapter. 
    • B、When away from the office configure the startup properties for the adapter to be automatic. 
    • C、Remove the computer from the docking station and start Windows 2000 Professional to disable the SCSI PC card adapter device for the current profile.
    • D、Remove the computer from the docking station and start Windows 2000 Professional, use Device Manager to remove SCSI PC card adapter device.

    正确答案:C

  • 第7题：

    You install a new CD-ROM on your computer. After installing the appropriate drivers and restarting the computer you notice that it is not working correctly. You check resources and find out that it is not using “Automatic resource settings”. How do you get your CDROM to work? （）

    • A、Check ‘Use Automatic Settings’
    • B、Update the drives
    • C、Use the windows troubleshooter
    • D、Manually set the interrupt，I/O port， and memory address to that of the hardware manufacturers specifications.

    正确答案:A

  • 第8题：

    单选题
    In which scenario will you use the Flashback Version Query feature？（）
    A

     when you want to restore a table that has been dropped from the Recycle Bin

    B

     when you want to identify the transaction ID of the transaction that deleted some important records from a table

    C

     when you want to recover the schema of a dropped user

    D

    when you want to restore a dropped tablespace


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

  • 第9题：

    单选题
    Which of the following would you use to enable automatic media recovery for a database？（）
    A

    SET AUTORECOVERY ON

    B

    SET RECOVERY ON

    C

    SET AUTO ON

    D

    You cannot enable automatic media recovery.


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

  • 第10题：

    单选题
    You want the size of the tablespace to increase when it is full. Which option would you use？（）
    A

    use automatic extent allocation

    B

    disable threshold for the tablespace

    C

    use freelists to manage the free space

    D

    use automatic segment space management

    E

    create the tablespace as a bigfile tablespace

    F

    use the RESIZE clause while creating the tablespace

    G

    enable AUTOEXTEND for at least one of the data files in the tablespace


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

  • 第11题：

    单选题
    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）
    A

    Oracle Migration Assistant

    B

    Recovery Manager （RMAN）

    C

    Oracle Data Pump Export and Import

    D

    conventional Oracle Export and Import

    E

    operating system utilities to copy the files to the ASM instance


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

  • 第12题：

    单选题
    You use a Windows 2000 Professional desktop computer. The corporate product information is stored on this computer. You want other users on the network to be able to read the product information on your computer. You use Windows Explorer to share the product information folder on the network. You want Sales staff to be able to keep a copy of the product information on their portable computers when they travel. Other users should not be able to synchronize the product information.  What should you do?（）
    A

    Use Synchronization manager to configure synchronization to occur when users are connected to the LAN connection.

    B

    Use Windows Explorer to grant Sales Staff Special access for the reports on the network share.

    C

    Use Windows Explorer to enable automatic caching for documents on the network share.

    D

    Create a new share for the Sales users only and enable caching on that share only.


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

  • 第13题：

    You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

    • A、 You must use automatic undo management in the database.
    • B、 You must configure OMF in your database.
    • C、 You must configure ASM for storing the datafiles.
    • D、 You must multiplex the online redo log file.

    正确答案:A

  • 第14题：

    You have two NTP servers 10.1.1.1 & 10.1.1.2 and want to configure a router to use 10.1.1.2 as its NTP server before falling back to 10.1.1.1. Which command will you use？


    正确答案: Ntp server 10.1.1.1
    Ntp server 10.1.1.2 prefer
    （notice the answer with the word “prefer”）

  • 第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题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第17题：

    In which scenario will you use the Flashback Version Query feature？（）

    • A、 when you want to restore a table that has been dropped from the Recycle Bin
    • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
    • C、 when you want to recover the schema of a dropped user
    • D、when you want to restore a dropped tablespace

    正确答案:B

  • 第18题：

    You use a Windows 2000 Professional computer.You are responsible for maintaining Company’s client contact list. You want other users on the networkto be able to read the client contact list. You use Windows Explorer to share the client contact list folderon the network.You want users touse the most current available information when contacting clients. You want toprevent users from enabling offline access for the network share that contains the client contact list.What should you do？（）

    • A、Use Synchronization Manager to configure synchronization not to occur when users are connected to the LAN connection.
    • B、Use Windows Explorer to grant users Special access for the reports on the network share.
    • C、Use Windows Explorer to disable caching for the reports on the network share.
    • D、Use Windows Explorer to disable Offline files.

    正确答案:C

  • 第19题：

    单选题
    n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
    A

     Oracle Migration Assistant

    B

     Recovery Manager （RMAN）

    C

     Oracle Data Pump Export and Import

    D

     conventional Oracle Export and Import

    E

     operating system utilities to copy the files to the ASM instance


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

  • 第20题：

    单选题
    You are configuring captive portal on your SRX Series device for guest user access.When would you use the redirect-traffic all command?（）
    A

    When you want all unauthenticated traffic to be redirected

    B

    When you want all clear text traffic to be redirected.

    C

    When you want all authenticated traffic to be redirected.

    D

    When you want all encrypted traffic to be redirected.


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

  • 第21题：

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


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

  • 第22题：

    单选题
    You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）
    A

     You must use automatic undo management in the database.

    B

     You must configure OMF in your database.

    C

     You must configure ASM for storing the datafiles.

    D

     You must multiplex the online redo log file.


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

  • 第23题：

    单选题
    You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
    A

     You must enable the row movement on the SCOTT.EMP table.

    B

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    C

     You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.

    D

     You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.


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

  • 第24题：

    单选题
    You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments.  What would you do to achieve this？（）
    A

     Add a finding directive for the ADDM task.

    B

     Add a segment directive for the ADDM task.

    C

     Add a parameter directive for the ADDM task.

    D

     Disable the Segment Advisor from the Automatic Maintenance Task.


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

相关内容