|
|
346.What is the impact of the results of the output of the following command?
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF
A. There are no backup sets with any backups of the users01.dbf datafile.
B. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or
some data loss is possible during a recovery.
C. The users01.dbf datafile is corrupted.
D. The users01.dbf datafile backup exceeds the retention criteria.
E. The last backup of the users01.dbf datafile failed and must be rerun.
Answer: B
答案D，附带解析：http://blog.csdn.net/rlhua/article/details/12372851
371.In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?
A. The datafiles have an ONLINE status.
B. The datafiles have an OFFLINE status.
C. The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
D. The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
E. The datafiles are in STANDBY mode.
Answer: B
答案A，附带解析：http://blog.csdn.net/rlhua/article/details/13761121
379.Users notify you that their application is failing every time they try to add new records. Because of
poor application design, the actual ORA error message is unavailable. What might be the problem?
(Choose the best answers.)
A. The application user has exceeded their undo quota.
B. The FLASHBACK GUARANTEE option is set on the undo tablespace.
C. The table is currently being queried by a Flashback Transaction Query operation.
D. The table is currently being queried by a Flashback Versions Query operation.
E. The RETENTION GUARANTEE option is set on the undo tablespace.
Answer: E
答案A，附带解析：http://blog.csdn.net/rlhua/article/details/17020577
383.At the request of a user, you issue the following command to restore a dropped table: flashback table
"BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop; Later, the user notifies you that the data in the
table seems to be very old and out of date.
What might be the problem?
A. Because a proper range of SCNs was not specified, the wrong data was restored.
B. A proper range of timestamps was not specified, so the wrong data was restored.
C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table
being stored in the Recycle Bin.
D. Either option A or B could be correct. Not enough information was provided to determine which.
E. None of the above.
Answer: E
答案C，附带解析：http://blog.csdn.net/rlhua/article/details/12435615
501.Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;
FLASHBACK_ARCHIEVE_NAME STATUS
FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?
A. The table uses the default Flashback Data Archive.
B. The Flashback Data Archive Is created In the SYSAUX tablespace.
C. The Flashback Data Archive is created in the same tablespace where the tables are stored.
D. The command generates an error because no flashback Data Archive name is specified and there is
no default Flashback Data Achieve.
Answer: D
答案A，附带解析：http://blog.csdn.net/rlhua/article/details/12225237
530.When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass
on to all database instances that rely on the ASM instances disk groups?
A. TRANSACTIONAL
B. IMMEDIATE
C. ABORT
D. NORMAL
Answer: NONE
答案C，附带解析：http://blog.csdn.net/rlhua/article/details/13008005
541.If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what
happens to disks that are already a part of the same or another disk group?
A. The command fails unless you specify the FORCE option.
B. The command fails unless you specify the REUSE option.
C. The command must be reissued with a more specific discovery string.
D. The other disks, already part of the disk group, are ignored.
Answer: D
答案A，附带解析：http://blog.csdn.net/rlhua/article/details/19037149
652.Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that
it is not because of the incremental backup or the empty file backup and that RMAN is sending data
blocks to the tape drive fast enough.
What could be a solution to make tape streaming happen during the backup?
A. Configure backup optimization
B. Configure the channel to increase MAXOPENFILES
C. Configure the channel to increase the capacity with the RATE parameter
D. Configure the channel to adjust the tape buffer size with the BLKSIZE option
Answer: D
答案C，附带解析：http://blog.csdn.net/rlhua/article/details/16105787
698. In your production database, you:
-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular
intervals
-Set the control file autobackup to “on”
-Are maintaining image copies of the database files
You have lost the server parameter file (SPFILE) and the control file. Which option must you consider
before restoring the SPFILE and the control file by using the control file autobackup?
A.Setting DBID for the database
B.Using the RMAN SWITCH command
C.Using the RMAN SRT NEWNAME command
D.Starting up the database instance in the NOMOUNT state
Answer:B
答案D，附带解析：http://blog.csdn.net/rlhua/article/details/19838089
请楼主点评下，为我这个回复收藏伸手党点福利 。（当然这是全itpuber的福利）
楼主兼版主请一个个做解析啊，谢谢。
Please use the professional opinion,do not use intuition！
God bless louzhu!~ |
|
楼主: 2009532140
IP卡
狗仔卡
发表于 2014-6-19 10:07
撸主！！！！！！！！！！！！！！！还在吗？
显身卡
楼主
发表于 2014-6-21 16:03
