ITPub博客

173.Which of the following is not a configurable attribute for an individual disk group?A. AU_SIZEB. COMPATIBLE.RDBMSC. COMPATIBLE.ASMD. DISK_REPAIR_TIMEE. DG_DROP_TIMEAnswer: E 对于一个单独的磁盘组，下列哪一个不是一个可配置的属性？DG_DROP_TIME...

494.Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatic...

49.Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B. If the lost redo log group is CURRENT, you must clear the log file.C. If the lost redo log group is ACTIVE, you must restore, pe...

151.Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET ...

268.You are using Recovery Manager (RMAN) for backup and recovery operations with a recoverycatalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM,you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the ...

648.Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 12399...

633.Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.)A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COM...

592.Which backup option defines a user-defined name for a backup?A. FORMATB. NAMEC. TAGD. FORMAT U%Answer: C哪种备份选项定义了一个用于备份的用户定义名称？

586.Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following were true:Control-file auto backups were enabled.The size of backup sets was not restricted.One channel was allocated.A. 1B. 2C. 3D. 4E. 5...

585.What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup groupAnswer: A什么类型的备份存储在一个专有的RMAN格式中？

577.What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create controlfile command.D. The restore controlfile SQL*Plus command.E. No backup is required. The database will re-create the control file when it is ...

571.Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived redo logsD. Backup control fileE. Control file from a backupAnswer: ACD在归档记录模式下数据库的完整恢复需要哪些文件？完全恢复总是需要在线...

570.What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Transaction number-basedAnswer: ABCD时间点的恢复方法有哪些？Change-based application allows you to recover the database to a specific SCN....

568.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)A. Database datafilesB. Control filesC. Archived redo logsD. Online redo logsE. Flashback logsAnswer: ABD你需要哪些文件执行在非归档记录模式下的数据库的完全恢复？非...

558.Which view provides information on the backup status of the datafiles in the database?A. V$BACKUPB. V$BACKUP_STATUSC. V$BACKUP_DATAFILED. V$DATAFILE_BACKUPE. V$TABLESPCE_BACKUPAnswer: A哪个视图提供在数据库中的数据文件的备份状态的信息？SQL> select table_name from dict where table_name...

543.As the DBA, you run the following query on your ASM instance.What is the implication of the results of the query? (Choose two.)SQL> select group_number, name, state from v$ASM_DISKGROUP;GROUP_NUMBER NAME STATE0 DGROUP1 DISMOUNTED2 DGROUP2 MOUNTED3 DGROUP3 MOUNTEDA. The DGROUP1 disk group ...

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. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMALE. None of the aboveAnswer: E当ASM实例接收一个正常关闭命令，它传递什么命令给依赖于ASM实...

529.Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISKGROUPC. ASM_DISKSTRINGD. ASM_MOUNTGROUPAnswer: B参考：http://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#OSTMG10141哪一个...

522.The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?A. Languages for server messagesB. Day and month names and abbreviationsC. Symbols to represent a.m., p.m., AD, and BCD. Affirmative and negative response strings (YES, N...

521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B. The job affinity is to a service and one node in th...