You performed rollback after commit.
If a log switch occurs in your database.
Thearchiverfails to generate an archived log file.
Instance recovery fails to find one of the redo log files.
A long-running query is unable to get read-consistent image.
If you perform manual undo management operations in auto mode.
第1题:
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
第2题:
You work as a database administrator for Supportcenter.cn. You want to administer your database servers, which are running on different host machines, using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()
第3题:
You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old In which situation would you receive such an error?()
第4题:
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?()
第5题:
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning, while querying the user1.employeestable, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following: The data file should remain online. The mean time to recover (MTTR) should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose?()
第6题:
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?()
第7题:
While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()
第8题:
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()
第9题:
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?()
第10题:
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()