单选题You executed the following command to start the database： SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 by

题目

单选题

You executed the following command to start the database： SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）

V$INSTANCE

V$CONTROLFILE

DBA_CONTROL_FILES

V$DATABASE_PROPERTIES

V$CONTROLFILE_RECORD_SECTION

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）

A. It must be executed from the Oracle Database 11g environment.

B. It must be executed only after the SYSAUX tablespace has been created.

C. It must be executed from the environment of the database that is being upgraded.

D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

参考答案：C

第2题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）

A、 The command restores only the missing control file.
B、 The command restores all the control files.
C、 The command fails because the database is running.
D、 This is the correct way to address this problem.
E、 This is not the correct way to address this problem.

正确答案:C,E

第3题：

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

参考答案：B

第4题：

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

A、Start the instance and open the database， instance recovery automatically recoverscontrol files
B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

正确答案:D

第5题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

A、Image of the control file
B、Location of the control file
C、Contents of the control file in text format
D、SQL command to re-create the database
E、SQL command to re-create the control file
F、Contents of the control file in binary format

正确答案:E

第6题：

You executed the following command to perform a backup of the USERS tablespace： SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）

A、The MTTR Advisor is disabled.
B、The database is in NOARCHIVELOG mode.
C、The tablespace is already in backup mode.
D、The Flash Recovery Area is not configured.

正确答案:B

第7题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？（）

A、The database is in NOMOUNT state.
B、The database is in ARCHIVELOG mode and the tablespace is online.
C、The database is in ARCHIVELOG mode and the tablespace is offline.
D、The database is in NOARCHIVELOG mode and the tablespace is online.
E、The database is in NOARCHIVELOG mode and the tablespace is offline.

正确答案:B,C,E

第8题：

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

参考答案：C

第9题：

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.

正确答案:A

第10题：

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files
B、dropping a user in your database
C、enabling or disabling redo log archiving
D、dropping a tablespace in your database
E、re-creating the control files， after you lost all the control files in your database

正确答案:C

You executed the following command to start the database： S

题目

相似问题和答案

更多相关问题

相关内容