1Z0-025经典考试回忆

王朝other·作者佚名  2008-05-19
窄屏简体版  字體: |||超大  

覆盖率可以,不过答案不是很准确。

1. What are two benefits of making recovery operations parallel? (Choose two)

Answer: Recovering more than one data file.

2. With the instance down, how would you recover a lost control file?

Answer: Use the CREATE CONTROLFILE command.

3. You are restoring a backup data file to a different location. To recover

successfully, what must you do?

Answer: Use the ALTER DATABASE command to rename the data file.

4. Which two benefits does the command ALTER DATABASE MOUNT

CLOSE DATABASE offer for the tablespace point-in-time recovery?

(Choose two)

Answer: It prevents accidental corruption of the primary database.

It allows you to remove a data file that has been added to the wrong tablespace.

5. Which statement about ‘cancel-based recovery’ is true?

Answer: Recovery is stopped by entering CANCEL at the recovery prompt.

6. A media management layer is always used when Recovery Manager

________.

Answer: Performs media recovery.

7. Why would you set a data file offline when the database is in MOUNT state?

Answer: To allow for automatic data file recovery.

8. When configuring a database in ARCHIVELOG mode and enabling automatic archiving, the database must be shut down and opened in the MOUNT stage. Which three options can be used to do this? (Choose Three)

Answer: SHUTDOWN NORMAL AND STARTUP MOUNT

SHUTDOWN IMMEDIATE AND STARTUP MOUNT

SHUTDOWN TRANSACTIONAL AND STARTUP MOUNT

9. When configuring a database in ARCHIVELOG mode and enabling automatic archiving, the database must be shut down and opened in the MOUNT stage. Which two options should not be used to do this? (Choose two)

Answer: STARTUP FORCE MOUNT

SHUTDOWN ABORT and STARTUP MOUNT

10. What is the correct procedure for multiplexing existing online redo logs?

Answer: Issue the ALTER DATABASE. . . ADD LOGFILE MEMBER command.

11. In the view V$DATAFILE_HEADER, what does value ‘YES’ in the ‘FUZZY’ column as specified?

Answer: The data file is in backup mode.

12. During an opened database backup, a power failure occurs. Which SQL statement do you issue to resolve this situation after mounting the database?

Answer: ALTER DATABASE DATAFILE n END BACKUP

13. You perform an incomplete recovery using RMAN. You write the following

script:

RUN{

SET UNTIL TIME = ‘yyyy-nm-dd:hh:mi:ss’;

RESTORE DATABASE;

RECOVER DATABASE;

SQL “alter database open resetlogs”;}

Which command is missing?

Answer: RELEASE CHANNEL.

14. Which statement regarding Recovery Manager with a database operating in

NOARCHIVELOG mode is true?

Answer: Recovery Manager supports multi-level incremental backups.

15. After rebuilding the recovery catalog by resynchronizing it with a copy of the backup control file, you notice references to files that no longer exist. Which CRETAE command clause should you use to remove these references?

Answer: UNCATALOG.

16. When configuring a database for ARCHIVELOG mode, you use initialization parameter to specify which two actions? (Choose two)

Answer: Where log files will be archived. The names that will be given to archived log files.

17. A tablespace becomes unavailable because of a failure. The database is

running in NOARCIVELOG mode? What should the DBA do to make the database available?

Answer: Restore the data files, redo log files, and control files from an earlier copy of a full database backup.

18. In which situation would you need to create a new control file for an existing

database?

Answer: When MAXLOGMEMBERS needs to be changed.

19. Why would a DBA load a table using the NOLOGGING options?

Answer: To reduce redo during a direct loaded operation.

20. Which technique does Oracle use to perform full backups of data files?

Answer: The server process reads the entire file and skips blocks that have never

been used.

21. Which statement regarding the allocation of processes to Recovery Manager is true?

Answer: Setting BACKUP_TAPE_IO_SLAVES=TRUE will enable a dedicated

slave to write to a tape device.

22. What is the effect of issuing an ALTER DATABASE OPEN RESETLOGS command on the primary database?

Answer: It invalidates the standby database.

23. In order to keep a standby database up-to-date, archived redo-log files need

to be transferred from the primary to the standby server. What are two ways

to do this? (Choose two)

Answer: Specify LOG_SARCHIVE_DEST_n on the standby database.

24. When configuring a database for ARCHIVELOPG mode, you use an initialisation parameter to specify which action?

Answer: That the database is in ARCHIVELOG mode.

25. You have just created a script in Recovery Manager. After noticing an error

in the script, you decide to recreate it. Which command replaces the stored script in the recovery catalog?

Answer: REPLACE_SCRIPT

26. When two or more databases are backed up using RMAN, is it appropriate

to use each database as the other’s recovery catalog? Why?

Answer: No. A database that contains a catalog cannot be target database.

27. What is the advantage of managed recovery mode?

Answer: The standby database automatically applies the archived redo log when the

files become available.

28. Which import option do you use to create tables without data?

Answer: ROWS.

29. Which statement is true when using the LogMiner utility?

Answer: The dictionary file is created in a directory as defined as defined by

UTL_FILE_DIR.

30. The developers have implemented parallel DML operations. How can a DBA

make sure that the archiving process is able to keep up with archiving the redo-log files?

Answer: Spawn multiple database writers.

31. Which action does Oracle recommend after a DBA recovers from the loss of

the current online redo-log?

Answer: Back up the instance.

Back up the control file.

32. What is the last step when setting up a recovery catalog?

Answer: Run the REGISTER DATABASE command.

33. What is the difference between using NOLOGGING operations in a single

database environment and a standby database environment?

Answer: NOLOGGING operations can be used on the standby database, but not on the primary database.

34. What is the function of SMON in instance recovery?

Answer: It roles forward by applying changes in the redo log.

35. What are two causes of user errors? (Choose two)

Answer: Incorrect data is committed.

A table is accidentally truncated.

36. Which statement is true when using the DELIVERY utility to detect corruptions in an Oracle data block?

Answer: The utility can be used to verify the data files of a backup database.

37. The alert log can contain specific information about which database backup activity?

Answer: Placing tablespace in begin and end backup mode.

38. In which two situations would you have to apply redo information to a read-only

tablespace? (Choose two)

Answer: When the tablespace being recovered is writeable, but was read-only when the last backup occurred.

When the tablespace being recovered is read-only, but was writeable when the last backup occurred.

39. Your database is configured in ARCHIVELOG mode. Which three types of

backups can be performed? (Choose three)

Answer: Open database backups.

Operating system back

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航