ITPub博客

699. Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default temporary tablspace. A user issues a query on the ORDERS table and receives the following error:What would be the most efficient way to rectify this...

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 filesYou have lost the server parameter file (SPFILE) and t...

696. Examine the following command for RMAN backup:Which statement Is true regarding the approach in the command?A.The RMAN multiplexing level is 4.B.It is the use of asynchronous I/O by RMAN.C.It is a case of parallelization of the backup set.D.It is an implementation of a multisection backup...

694. As part of archiving the historical data, you want to trans fer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online.The source and target databases use the same compatibility level and character sets.View the...

689. View the Exhibit and examine the RMAN commands.Which statement describes the effect of a backup retention policy on the backup of a backup set?A.Either all the copies of a backup set are obsolete or none of them are as per the retention policy.B.The copies of the backup will be reported as ...

688. Which two statements are true about the compressed backups in RMAN? (Choose two.)A.Compressed backups can only be taken on the tape drives.B.The binary compression creates some performance overhead during backup operation.C.The ZLIB compression algorithm can be used only if the COMPATIBLE in...

685. In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOARCHIVELOG mode-One of the data files is corrupted-All online redo log files are lost because of a media failureWhich option must you consider...

684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.You decide to perform an i...

532.As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy inyour database. Using ASM, you want to create a disk group that will provide for the greatestamount of redundancy for your ASM data (you do not have advanced SAN mirroring technologyavailable to you, u...

525.What components are present in an ASM instance? (Choose three.)A. SGAB. Database processesC. Database datafilesD. Control filesE. Database parameter file or spfileAnswer: ABEASM 实例是ASM 的进程和内存组件的组合。每次启动ASM 或数据库时，都会分配名为系统全局区(SGA) 的共享内存区...

524.What are three benefits of using ASM? (Choose three.)A. Ease of disk administration and maintenanceB. Load balancing across physical disksC. Software RAID-1 data redundancy with double or triple mirrorsD. Automatic recovery of failed disksAnswer: ABC优点? 对文件而不是逻辑卷进行条带...

523.The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)A. Date formatB. Decimal characterC. Group separatorD. First day of the monthE. None of the aboveF. All of the aboveAnswer: ABC参考：http:/...

519.You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value.Which of these actions is appropriate?A. Abort t...

518.The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?A. 20% SGA...

480.View the Exhibit exhibit1 to examine the series of SQL commands.View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhib...

473.How many different calendars does Oracle 11g support?A. 22B. 7C. 6D. 15E. 2Answer: B参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG215NLS_CALENDAR can have one of the following values:Arabic HijrahEnglish HijrahG...

464.Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)A. ASCIIB. ANSIC. BINARYD. MONOLINGUALE. MULTILINGUALAnswer: BCSQL> show parameter nls_compNAME               &nb...

341.If a backup set is expired, what can you do to correct the problem?A. Change the retention criteria.B. Make the lost backup set pieces available to RMAN again.C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D. Nothing. The backup set p...

339.Why would you run the delete obsolete command? (Choose all that apply.)A. To remove missing backup set pieces physically from diskB. To remove metadata related to backup set pieces in the control file and the recovery catalogC. To mark as deleted records in the control file and the recovery c...

338.You run the following commands:RMAN> list expired backup;RMAN> delete expired backup;What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?A. They will be renamed.B. Nothing will happen to them. The backup set pieces do not exis...