audit trail
alert log file
user trace file
online trace file
background trace file
operating system event viewer
第1题:
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
第2题:
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?()
第3题:
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
第4题:
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?()
第5题:
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?()
第6题:
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? ()
第7题:
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()
第8题:
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 mode
B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
第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题:
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:()