单选题You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Sta

题目
单选题
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
A

4， 1， 3， 2， 5

B

1， 3， 4， 5， 2

C

1， 3， 2， 5； 4 not required

D

4， 1， 5， 2； 3 not required

E

1， 3， 4， 5； 2 not required

相似考题

1.You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

2.You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.

3.You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.

4.You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

更多“You want to enable archiving on your database. Presently， th”相关问题

  • 第1题：

    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

    • A、to enable the ASM instance to identify the alert log file
    • B、to enable the ASM instance to identify the server parameter file
    • C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
    • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

    正确答案:B

  • 第2题：

    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.

    正确答案:A

  • 第3题：

    You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. What should you do？ （）

    • A、Enable Internet Connection Sharing
    • B、Enable on-demand dialing
    • C、Enable sharing a modem on one computer on the network
    • D、Configure a DHCP Server
    • E、Disable Internet Connection Sharing

    正确答案:A

  • 第4题：

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


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

  • 第5题：

    单选题
    You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）
    A

    Information about each Oracle Net connection.

    B

    Information about each entry in theLinstener.orafile

    C

    Information about the changed done in the database

    D

    Information about the different listeners in your system

    E

    Information about all thenondatabasefiles required to operate the database


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

  • 第6题：

    单选题
    You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
    A

    4， 1， 3， 2， 5

    B

    1， 3， 4， 5， 2

    C

    1， 3， 2， 5； 4 not required

    D

    4， 1， 5， 2； 3 not required

    E

    1， 3， 4， 5； 2 not required


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

  • 第7题：

    单选题
    You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
    A

    4， 1， 3， 2， 5

    B

    1， 3， 4， 5， 2

    C

    1， 3， 2， 5； 4 not required

    D

    4， 1， 5， 2； 3 not required

    E

    1， 3， 4， 5； 2 not required


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

  • 第8题：

    单选题
    You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet.  You have enabled Internet connection sharing. You do not want to initiate this connection automatically when a request for Internet reaches your computer. What should you do? （）
    A

    You should uncheck “Enable on demand dialing

    B

    Enable on-demand dialing

    C

    Enable sharing a modem on one computer on the network

    D

    Configure a DHCP Server

    E

    Disable Internet Connection Sharing


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

  • 第9题：

    单选题
    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）
    A

     the system change number

    B

     the locations of the redo log files

    C

     the locations of the datafiles

    D

     the physical location of all the database changes


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

  • 第10题：

    单选题
    You are attempting to connect to your ISP. You view the status change from Dialing to Verifying user name and password. After several seconds， the status changes to Disconnecting. You are then disconnected from the computer you dialed. You verify that your user name and password are entered correctly. You want to enable your Computer to connect to your ISP correctly. What should you do？ （）
    A

    Configure your connection to enable data encryption.

    B

    Configure your connection to use the UNIX SLIP server.

    C

    Configure your connection to allow unsecured passwords.

    D

    Instruct your ISP to configure your account to support Multilink.


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

  • 第11题：

    单选题
    You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order：  1：Shut down the instance.  2：Execute the ALTER DATABASE ARCHIVELOG command.  3：Start up the instance and mount the database.  4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database.  Which is the correct sequence of steps for accomplishing the task（）
    A

    4，1，3，2，5

    B

    1，3，4，5，2

    C

    1，3，2，5；4 not required

    D

    4，1，5，2；3 not required

    E

    1，3，4，5；2 not required


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

  • 第12题：

    单选题
    You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）
    A

     Run Segment Advisor

    B

     Run the SQL Tuning Advisor （STA）

    C

     Run the Automatic Workload Repository （AWR） report

    D

     Run the SQL Access Advisor with a hypothetical workload


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

  • 第13题：

    You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet.  You have enabled Internet connection sharing. You do not want to initiate this connection automatically when a request for Internet reaches your computer. What should you do? （）

    • A、You should uncheck “Enable on demand dialing
    • B、Enable on-demand dialing
    • C、Enable sharing a modem on one computer on the network
    • D、Configure a DHCP Server
    • E、Disable Internet Connection Sharing

    正确答案:A

  • 第14题：

    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

    • A、 the system change number
    • B、 the locations of the redo log files
    • C、 the locations of the datafiles
    • D、 the physical location of all the database changes

    正确答案:D

  • 第15题：

    You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. What should you do？ （）

    • A、Enable Internet Connection Sharing
    • B、Enable on-demand dialing
    • C、Enable sharing a modem on one computer on the network
    • D、Configure a DHCP Server
    • E、Disable Internet Connection Sharing
    • F、Configure all the other computers to be DHCP enabled.

    正确答案:A,F

  • 第16题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）
    A

    Set MEMORY_TARGET to zero

    B

    Set the STATISTICS_LEVEL parameter to BASIC

    C

    Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

    Set the PGA_AGGREGATE_TARGET parameter to nonzero value


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

  • 第17题：

    单选题
    You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
    A

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第18题：

    单选题
    You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually.  Which action should you take to enable archiving at instance startup？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第19题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）
    A

     Set MEMORY_TARGET to zero

    B

     Set the STATISTICS_LEVEL parameter to BASIC

    C

     Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

     Set the PGA_AGGREGATE_TARGET parameter to nonzero value


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

  • 第20题：

    单选题
    You have a DHCP server that runs Windows Server 2008.You need to reduce the size of the DHCP database. What should you do？（）
    A

    From the DHCP snap-in， reconcile the database.

    B

    From the folder that contains the DHCP database， run jetpack.exe dhcp.mdb temp.mdb.

    C

    From the properties of the dhcp.mdb file， enable the File is ready for archiving attribute.

    D

    From the properties of the dhcp.mdb file， enable the Compress contents to save disk space attribute.


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

  • 第21题：

    单选题
    You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）
    A

    Use the Database Resource Manager.

    B

    Set the limits in the profiles used by users.

    C

    Modify the SESSIONS initialization parameter.

    D

    Set the warning threshold for the Current Logons Count metric.


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

  • 第22题：

    单选题
    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.  Which statement about performing user-managed backups in a 24x7 environment is true？（）
    A

     You must have change tracking enabled in your database

    B

     Your database must be running in NOARCHIVELOG mode

    C

     To back up a tablespace，it must be in backup mode

    D

     To back up a tablespace，it must first be taken offline


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

  • 第23题：

    单选题
    You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature？（）
    A

     ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

     ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 

    C

     ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

    D

     ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第24题：

    单选题
    You have a DHCP server that runs Windows Server 2008 R2.You need to reduce the size of the DHCP database. What should you do？（）
    A

    From the DHCP snap-in, reconcile the database.

    B

    From the folder that contains the DHCP database, run jetpack.exe dhcp.mdb temp.mdb.

    C

    From the properties of the dhcp.mdb file, enable the File is ready for archiving attribute.

    D

    From the properties of the dhcp.mdb file, enable the Compress contents to save disk space attribute.


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

相关内容