Shared pool
Control file
SGA
PGA
第1题:
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement: SQL>ALTER DATABASE OPEN RESETLOGS; Which of the following options is true about using the RESETLOGS option?()
第2题:
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
第3题:
Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?()
第4题:
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?()
第5题:
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d:/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database?()
第6题:
You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error. SQL> startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02a.log ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02.log ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 SQL> alter database clear logfile group 2; alter database clear logfile group 2 * ERROR at line 1: ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02.log ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error?() a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery, applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.
第7题:
This operation resets the SCN for the database.
This operation creates a new incarnation of the database.
This operation moves all the redo log files to a different location.
This operation deletes the old redo log files and creates new redo log files.
This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
第8题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第9题:
The redo log file should belong to an active group.
The redo log file should belong to an inactive group.
The redo log file should belong to the current group.
The redo log file can be dropped only if all the transactions are stopped.
Before a redo log file is dropped, it should be deleted from the operating system (OS).
第10题:
The archived redo logs are stored in an operating system-dependent location.
The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
第11题:
the alert log file and the trace files
the redo log files
the control file
the change tracking file
第12题:
b, a, f
e, b, a, f
e, b, a, g
b, a, g
c, e, b, d, f
第13题:
When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()
第14题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第15题:
You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()
第16题:
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
第17题:
You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()
第18题:
multiplexed control files
RMAN obsolete backups
multiplexed online redo log files
archived redo logs that have not been copied to tape
第19题:
Shared pool
Control file
SGA
PGA
第20题:
Writes buffers to disk
Writes current redo log number to datafile headers
Writes redo log information to disk
Reads information into memory for users
第21题:
The log sequence is reset to 0.
All the online redo logs are deleted.
All the archived redo logs from a previous incarnation become useless.
The full database backup taken from a previous incarnation can be used in future.
Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
第22题:
recycle buffer cache
large pool
streams pool
keep buffer cache
redo log buffer
第23题:
RMAN keeps a list of archive logs in a text file.
The DBA must manually tell RMAN which archive logs to backup.
RMAN has access to target control file and/or catalog information.
RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
第24题:
Flashback logs are not archived.
Flashback logs are maintained in redo log files.
Flashback logs are maintained in the Flash Recovery Area.
Flashback logs are used to maintain Flashback Database related errors.
Flashback logs need to be cleared manually after you disable Flashback Database.