ITPub博客

703. Given below are RMAN commands to enable backup optimization and set the retention policy:The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.View the Exhibit to examine the operations performed by using RMAN. Which two statements are trueabout the ...

28.You have a range-partitioned table in your database. Each partition in the table contains the sales datafor a quarter.The partition related to the current quarter is modified frequently and other partitions undergo fewer datamanipulations. The preferences for the table are set to their default...

224.You need to create a partitioned table to store historical data and you issued the following command:CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL(NUMTOYMINTERVAL(1,'month')) STORE IN (tbs1,tbs2,tbs3) ( PARTITION p1 VALUES LESSTHAN(TO_DATE('1-1-2005', 'dd-mm-yyyy')), PA...

94.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions: What could havehelped you to correlate server sessions with channels?A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify ...

466.What can you determine about the following linguistic sorts based only on their names?1. GERMAN2. FRENCH_MA. 1 is a monolingual sort.B. 2 is a monolingual sort.C. 1 is case insensitive.D. Both 1 and 2 are case insensitive.E. Case sensitivity is unknown.Answer: Alinguistic: 语法; ...

608.You are managing a 24*7 database. The backup strategy for the database is to performuser-managed backups.Identify two prerequisites to perform the backups. (Choose two.)A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tabl...

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参考：http://blog.csdn.net/leshami/article/details/7909887(Oracle 基于用户管理的不完全恢复)  &nbsp...

707. Because of a logical corruption in the EMPLOYES tables, you want to perform TablespacePoint-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, youqueried the TS_PITR_CHECK view and you realized that the table has a referential constraint withDEPARTMENTS th...

585.What type of backup is stored in a proprietary RMAN format?A. Backup setB. Image copyC. Backup sectionD. Backup groupAnswer: Aproprietary: 专有的

500.You opened the encryption wallet and then issued the following command:SQL>CREATE TABLESPACE securespaceDATAFILE '/home/user/oradata/secure01.dbf'SIZE 150MENCRYPTION USING '3DES168'DEFAULT STORAGE(ENCRYPT);Then you closed the wallet. Later, you issued the following command to create the EM...

389.The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDAAnswer: CRVWR= Recovery Writer ProcessRVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some ...

607.Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located getscorruptedThe disk having active online redo log files is also corru...

437.Within a resource-plan definition, what differentiates a top-level plan from a subplan?A. A subplan has the PLAN_SUB parameter value set to SUB.B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in theresource-plan definition.C. There is no difference in the r...

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: ABCD错误C在软件层面的RAID-1(RAID 1通过磁...

111.Which three statements are true regarding persistent lightweight jobs? (Choose three.)A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.B. The user cannot set privileges on persistent lightweight jobs.C. Persistent lightweight jobs are usefu...

701. A user receives the following error while performing a large volume of inserts into a table:The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the usermay perform such transaction in the future. You want to ensure that the command waits rather than...

711. The following command is executed to shut down an Automatic Storage Management (ASM)instance:SQL>SHUTDOWN ABORT;Which two statements describe the consequences of the above command? (Choose two.)A.The disk groups are orderly dismounted.B.The ASM instance requires recovery when it is started...

26.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schemaowned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalogschema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242,...

196.What is the purpose of the catalog command?A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN backup-related metadata from the recovery catalogC. To create metadata in the control file and the recovery catalog related to backup set pieces...

148.Which dependent object will get invalidated even if it is not affected by the table edefinition?A. packagesB. triggersC. synonymsD. viewsAnswer: B在线重定义之后，新表没有此触发器触发器定义：CREATE OR REPLACE TRIGGER tr_t before update on table_before显然，触发器定义的语句ON部分就已经...