niusouti.com

单选题Which command is used to open the database after an incomplete recovery？（）Aalter database openBalter database open repairlogCalter database open resetlogsDalter database open resetlogEalter database resetlogs open

题目
单选题
Which command is used to open the database after an incomplete recovery？（）
A

 alter database open

B

 alter database open repairlog

C

 alter database open resetlogs

D

 alter database open resetlog

E

 alter database resetlogs open

相似考题

1.单选题What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration？（）AIt improves resync operations.BThis feature enables much faster file opens.CIt improves performance as fewer extent pointers are needed in the shared pool.DIt improves performance by reading from a copy of an extent closest to the node.

2.多选题Which three statements are true about persistent configuration？（）AA user cannot set privileges on the persistent lightweight jobsBPersistent lightweight jobs generate a large amount of metadataCIt is possible to create fully self-contained persistent lightweight jobsDThe use of a template is mandatory to create persistent lightweight jobsEPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time

3.单选题Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature？（）ARSTLNEBNLSRTLCLISTENERDNLSSORTELinguistic sorts

4.单选题How many database instances are used during a database-duplication process？（）AOneBTwoCThreeDFourEFive

参考答案和解析
正确答案： A
解析： 暂无解析
更多“Which command is used to open the database after an incomple”相关问题

  • 第1题：

    多选题
    Which two statements are true with respect to the maintenance window？（） .
    A

    A DBA can enable or disable an individual task in all maintenance windows.

    B

    A DBA cannot change the duration of the maintenance window after it is created.

    C

    In case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.

    D

    A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window


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

  • 第2题：

    单选题
    A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）
    A

    b， a， d， f

    B

    c， a， e， b， d， f， g

    C

    c， e， d， g

    D

    b， d， f 

    E

    e， d， g


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

  • 第3题：

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）
    A

     ADD DIRECTORY

    B

     DROP DISK

    C

     RESIZE DISK

    D

     REBALANCE

    E

     ADD FAILGROUP


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

  • 第4题：

    单选题
    A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）
    A

    b， a， d， f

    B

    c， a， e， b， d， f， g

    C

    c， e， d， g

    D

    b， d， f 

    E

    e， d， g


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

  • 第5题：

    单选题
    Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
    A

    /u01/app/oracle/product/11.1.0/db_1

    B

    /u01/app/oracle

    C

    $ORACLE_HOME/bdump

    D

    $ORACLE_HOME/log


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

  • 第6题：

    单选题
    Evaluate the following code：   SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers  WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’；  DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，  ：task_name， ：sql_stmt）；  END；   What is the outcome of this block of code？（）
    A

     It creates a task and workload， and executes the task.

    B

     It creates a task and workload but does not execute the task.

    C

     It produces an error because a template has not been created.

    D

     It produces an error because the SQL Tuning Set has not been created.


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

  • 第7题：

    多选题
    What is the purpose of the RMAN recovery catalog？（）
    A

    Make backups faster

    B

    Store RMAN metadata

    C

    Store RMAN scripts

    D

    Provide the ability to do centralized backup reporting

    E

    Make recovery faster


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

  • 第8题：

    单选题
    What will be the result of the following configuration？（）   Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydb
    A

     An error will occur during database startup because the second parameter is not valid.

    B

     An error will occur during database startup since you are trying to create archived redo logs in two different locations.

    C

     Archived redo logs will be created in two different locations by the ARCH process.

    D

     Archived redo logs will be created in two different locations by the LGWR process.

    E

     Neither parameter setting is valid， so the database will not start up.


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

  • 第9题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


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

  • 第10题：

    单选题
    Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）
    A

     only the control file， the current SPFILE， and data files

    B

     only the current SPFILE and data files if autobackup is disabled

    C

     only the data files and the archived redo logs

    D

     the control file，current SPFILE file，data files，and archived redo logs


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

  • 第11题：

    单选题
    Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）
    A

     Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

    B

     Capture the plans from the previous version using STS and then load them into the stored outline.

    C

     Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）

    D

     Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.


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

  • 第12题：

    单选题
    You issue the following command：   RMAN>CONFIGURE BACKUP OPTIMIZATION ON；   What is the result of this command on your backups？（）
    A

     An incremental backup strategy will be used automatically.

    B

     Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.

    C

     RMAN will configure itself for maximum performance at the cost of CPU.

    D

     RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.

    E

     RMAN will automatically compress backups.


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

  • 第13题：

    单选题
    You issue the following RMAN command to set a retention policy on a database：   RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of issuing this command？（）
    A

     After two days，a backup will be marked obsolete

    B

     After two days，a backup will be deleted from the media

    C

     If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.

    D

     If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.


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

  • 第14题：

    单选题
    The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this？（）
    A

     to prevent the creation of an excessive number of scheduler job classes

    B

     to allow the Automated Maintenance Tasks to use system resources without any restriction

    C

     to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

    D

     to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources


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

  • 第15题：

    单选题
    You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours：   ALTER DISKGROUP dg01 SET ATTRIBUTE ’disk_repair_time’ = ’5h’；   To which disks in the disk group will the new value be applicable？（）
    A

     all disks in the disk group

    B

     all disks that are currently in OFFLINE mode

    C

     all disks that are not currently in OFFLINE mode

    D

     all disks in the disk group only if all of them are ONLINE


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

  • 第16题：

    单选题
    When youre performing active database duplication，a backup of what kind is required？（）
    A

     A current RMAN backup-set backup is required.

    B

     No backup is required.

    C

     An RMAN image backup is required.

    D

     A manual backup is required.

    E

     A duplicate preparatory backup is required.


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

  • 第17题：

    单选题
    You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?（）
    A

    A list of files that require a backup within 3 days

    B

    A list of files requiring more than 3 days of archivelogs to apply

    C

    A list of files that RMAN recommends be backed up only once in every three days, based on low volatility

    D

    A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them


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

  • 第18题：

    单选题
    The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）
    A

     owner

    B

     touser

    C

     attach

    D

     remap_schema


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

  • 第19题：

    单选题
    Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）
    A

     The database must be running in ARCHIVELOG mode.

    B

     No special setup is required， and the feature is enabled by default.

    C

     The path for the Automatic Diagnostic Repository （ADR） must be configured with the  DIAGNOSTIC_DEST initialization parameter.

    D

     The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.

    E

     Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select  license agreement.


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

  • 第20题：

    单选题
    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）
    A

     Enable supplemental logging for the database.

    B

     Specify undo retention guarantee for the database

    C

     Create Flashback Data Archive in the tablespace where the tables are stored.

    D

     Create Flashback Data Archive and enable Flashback Data Archive for specific tables


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

  • 第21题：

    单选题
    You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）
    A

     Set DYNAMIC_SAMPLING to level 4

    B

     Set the STATISTICS_LEVEL parameter to BASIC

    C

     Set the INCREMENTAL value to TRUE for the partition table

    D

     Increase the value of STALE_PERCENT for the partition table


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

  • 第22题：

    单选题
    While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）
    A

    It updates the existing SQL profiles with current statistics.

    B

    It makes the statistics information available to GATHER_STATS_JOB

    C

    It initiates the statistics collection process by running GATHER_STATS_JOB

    D

    It logs a warning message in the alert log so that the DBA can perform statistics collection manually.


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

  • 第23题：

    多选题
    The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（）
    A

    Date format

    B

    Decimal character

    C

    Group separator

    D

    First day of the month

    E

    None of the above

    F

    All of the above


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

  • 第24题：

    多选题
    Which three are the valid statements in relation to SQL plan baselines？（）
    A

    The plans can be manually loaded to the SQL plan baseline.

    B

    The plans in the SQL plan baseline are verified and accepted plans.

    C

    The plans generated for every SQL statement are stored in the SQL plan baseline by default.

    D

    The plan baselines are stored temporarily in the memory as long as the database instance is running.

    E

    For the SQL plan baselines to be accessible to the optimizer， the SYSAUX tablespace must be online.


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

相关内容