单选题When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）A audit trailB alert log fileC user trace fileD online trace fileE ba

题目
单选题
When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）
A

audit trail

B

alert log file

C

user trace file

D

online trace file

E

background trace file

F

operating system event viewer

相似考题

1.You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

2.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG

3.Your company has a single active directory domain. The company network is protected by a firewall. Remote users connect to your network through a VPN server by using PPTP. When the users try to connect to the VPN server， they receive the following error message： Error 721： The remote computer is not responding. You need to ensure that users can establish a VPN connection. What should you do？ （）A、Open port 1423 on the firewallB、Open port 1723 on the firewallC、Open port 3389 on the firewallD、Open port 6000 on the firewall

4.You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）A. Open the database in NORMAL modeB. Open the database in read-only modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

参考答案和解析
正确答案： B
解析： 暂无解析
更多“When you try to open your database， you receive the followin”相关问题

  • 第1题：

    RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

    • A、’SQL ALTER DATABASE OPEN’；
    • B、SQL ALTER DATABASE ’OPEN’；
    • C、OPEN DATABASE；
    • D、DATABASE OPEN

    正确答案:C

  • 第2题：

    You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

    • A、Mount the database
    • B、Open the database in NORMAL mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:A

  • 第3题：

    Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）

    • A、 The database writer writes to a trace file， indicating that the temporary file is not found.
    • B、 The database prompts for a database recovery.
    • C、 The database opens normally.
    • D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

    正确答案:A,C

  • 第4题：

    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

    • A、 The time when the last flashback operation in your database was performed.
    • B、 The time when the first flashback operation in your database was performed.
    • C、 A list of flashback operations performed in your database using SCN and time.
    • D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.

    正确答案:D

  • 第5题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第6题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第7题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）
    A

     ALTER DATABASE DROP LOGFILE GROUP 1

    B

     ALTER DATABASE CLEAR LOGFILE GROUP 1

    C

     ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1

    D

     ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’


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

  • 第8题：

    单选题
    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
    A

     The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.

    B

     Before the instance starts， you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens， but every attempt to write to redo log files fails with an error.


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

  • 第9题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）
    A

    ALTER DATABASE DROP LOGFILE GROUP 1;

    B

    ALTER DATABASE CLEAR LOGFILE GROUP 1;

    C

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

    D

    ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG


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

  • 第10题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


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

  • 第11题：

    单选题
    When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）
    A

    audit trail

    B

    alert log file

    C

    user trace file

    D

    online trace file

    E

    background trace file

    F

    operating system event viewer


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

  • 第12题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


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

  • 第13题：

    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

    • A、You can perform online whole database backups.
    • B、You can performofflinewhole database backups.
    • C、You cannot perform schema-level export/import operations.
    • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

    正确答案:B

  • 第14题：

    When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）

    • A、audit trail
    • B、alert log file
    • C、user trace file
    • D、online trace file
    • E、background trace file
    • F、operating system event viewer

    正确答案:B

  • 第15题：

    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

    • A、 ALTER DATABASE DROP LOGFILE GROUP 1
    • B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
    • C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
    • D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

    正确答案:C

  • 第16题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第17题：

    Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）

    • A、You can perform open database backups.
    • B、You can perform closed database backups.
    • C、You cannot perform schema-level logical backups.
    • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

    正确答案:B

  • 第18题：

    Your company has a single Active Directory domain. The company network is protected by a firewall.Remote users connect to your network through a VPN server by using PPTP.When the users try to connect to the VPN server, they receive the following error message :Error 721:The remote computer is not responding.You need to ensure that users can establish a VPN connection.What should you do？（）

    • A、Open port 1423 on the firewall.
    • B、Open port 1723 on the firewall.
    • C、Open port 3389 on the firewall.
    • D、Open port 6000 on the firewall.

    正确答案:B

  • 第19题：

    单选题
    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）
    A

     Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.

    B

     Oracle will automatically take the datafile out of hot backup mode and then open the database.

    C

     Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.

    D

     The database will open with the file in hot backup mode. You can restart the backup at any time.

    E

     The datafile in hot backup mode will be corrupted and you will have to recover it.


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

  • 第20题：

    单选题
    You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
    A

     The time when the last flashback operation in your database was performed.

    B

     The time when the first flashback operation in your database was performed.

    C

     A list of flashback operations performed in your database using SCN and time.

    D

     The approximate time and the lowest system change number （SCN） to which you can flash back your database.


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

  • 第21题：

    多选题
    Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）
    A

    The database opens normally.

    B

    The database prompts for a database recovery.

    C

    The database writer writes to a trace file， indicating that the temporary file is not found.

    D

    The database gets mounted and throws an error indicating that the temporary file requires recovery.


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

  • 第22题：

    单选题
    Your Company upgrades its network to 100 Mbps. You remove the old network adapter and install a new 10/100 Mbps network adapter into a Windows 2000 Professional computer. You configure the TCP/IP protocol settings to be the same as they were for the previously installed network adapter.   When you restart eh computer, however, you cannot access the network. You try to ping your network adapter’s TCP/IP address locally. You receive the following error message. “Request timed out.” Next, you try to ping 127.0.0.1 and receive the same error message.   What must you do?（）
    A

    Configure a different TCP/IP address

    B

    Enable DHCP in the TCP/IP properties

    C

    Enable DNS in the TCP/IP properties

    D

    Configure the network adapter to run at 100 Mbps only

    E

    Replace the network adapter.


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

  • 第23题：

    单选题
    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
    A

    the time when the last flashback operation in your database was performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


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

  • 第24题：

    单选题
    RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
    A

    ’SQL ALTER DATABASE OPEN’；

    B

    SQL ALTER DATABASE ’OPEN’；

    C

    OPEN DATABASE；

    D

    DATABASE OPEN


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

相关内容