ITPub博客

682. Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all thatapply.)A.To check that the obsolete backups are deleted from the repository records and from the disk.B.To update the RMAN repository if you delete archived redo logs with operating system commands.C.To u...

2.You plan to have a larger moving window size for the default system-defined moving window baselinebecause you want to use the adaptive threshold.Which statement factors in this consideration while increasing the size of the moving window.?A. The collection level for the AWR should be set to BAS...

502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each grouphas one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo logfile and the LWGR terminates causing the instance to crash. The steps to recover fr...

620.You are using the control file to maintain information about the database backups that are beingperformed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. (Choose two.)A. To store the backup information of multiple databaseB. To restrict the amount...

368.When issuing the duplicate database command, you use the parameterDB_FILE_NAME_CONVERT. For what purpose do you use this parameter?A. To indicate the location of the auxiliary-instance online redo logs.B. To indicate the location of the target database datafiles.C. To indicate the location o...

240.You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.One of the disks in the disk group becomes unavailable because of power failure. You issued thefollowing command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER DISKGROUP dg...

14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts between two online patches.D. It is available for installing all patches on all platforms.E. It works ...

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 passon to all database instances that rely on the ASM instances disk groups?A. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMALAnswer: NONEhttp://blog.csdn.net/rlhua/article/details/13008005注：有连接的RDBMS 实例...

660.You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:1. Set the retention target:SQL> ALTER SYSTEM SET DB_FLASHBA...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: Ahttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276Linguistic Sort...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: Ahttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276Linguistic Sort...

46.What happens when you run the SQL Tuning Advisor with limited scope?A. Access path analysis is not performed for SQL statements.B. SQL structure analysis is not performed for SQL statements.C. SQL Profile recommendations are not generated for SQL statements.D. Staleness and absence of statist...

319.What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_nameORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultBackup database tag=gold_copy plus archivelog tag=gold_copy delete input; B...

604.You realize that the control file is damaged in your production database. After restoring the control filefrom autobackup, what is the next step that you must do to proceed with the database recovery?A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED m...

687. Users are connected to a database instance that is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the ASM instance:SQL> SHUTDOWN IMMEDIATE;What happens to the database instance?A.It shuts down long with the ASM instance.B.It is aborted and the...

694. As part of archiving the historical data, you want to transfer data from one database to anotherdatabase, 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 ...

277.The BOOKINGS table contains online booking information. When a booking is confirmed, the detailsare transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is nofixed time interval between each online booking and its confirmation. Because sufficient space is n...

482.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want toconvert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methods would you use to achieve this? (Choose all that apply.)A. Use Data Pump to transfer the exi...

452.Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)A. Schedule objectsB. Program argumentsC. Job classesD. Job argumentsE. All of the aboveAnswer: ABD