-
编辑 删除
043-029
29. Which statement correctly describes the change tracking writer (CTWR) background process?A. It keeps track of changes in the background processes.B. It records the system change number (SCN) in th...
-
编辑 删除
关于内存调整
-
编辑 删除
043-028
28. You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:SGA_TARGET= 10GBSGA_MAX_SIZE = 14GBSTREAMS_POOL_SIZE = 1GBSHARED_POOL_SIZE = 3GBWhich two state...
-
编辑 删除
043-027
27. In which scenarios would you rebuild an index? (Choose all that apply.)A. when you need to disable the index usageB. when you need to change storage optionsC. when you need to enable index monitor...
-
编辑 删除
043-026
26. Exhibit:A.set retenton target; Alter system set DB_Flashback_Retention_target=4320;B:Enable Flashback Database; Alter database flashback on;C mount the database ...
-
编辑 删除
oracle resetlog 都做什么
1.将联机重做日志文件序号设置成1.2.损坏的redolog之内和之后的事务都无效。3.归档当前的联机重做日志。4.产生一个新的数据库原型。不完全恢复都得用这个命令搞一下。...
-
编辑 删除
oracle IOT
-
编辑 删除
oracle cluster
-
编辑 删除
043-025
25. You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken ...
-
编辑 删除
043-024
24. You are designing an application for Certkiller .com and you havebeen asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, list...
-
编辑 删除
043-023
23. While creating a job class using the DBMS_SCHEDULER package, youset the logging level to LOGGING_RUNS. What would be the impact of this setting?A. Oracle Scheduler would write detailed information...
-
编辑 删除
043-022
22. You performed an incomplete recovery on your Oracle Database 10gdatabase using the following command:SQL> RECOVER DATABASE2 UNTIL TIME '2004-08-05:12:10:03'3 USING BACKUP CONTROLFILE;In which situ...
-
编辑 删除
043-021
21. Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night.On Tuesday, client A drops a table at 8:00 a.m. as follows:SQL> DROP TABLE cust_ord PURG...
-
编辑 删除
043-020
20. An RMAN backup job fails, displaying the following error:ORA-19809: limit exceeded for recovery filesYour analysis shows that the Flash Recovery area is full. Which two actions could you take ...
-
编辑 删除
闪回恢复区flash back area 满了怎么办。
设置CONFIGURE RETENTION POLICY， 根据具体备份策略来设置磁盘空间大小，设置自动删除过期备份。
-
编辑 删除
043-019
19. You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1and DG2 with one device each. In the parameter file of th...
-
编辑 删除
043-018
18.You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?A. restore the tablespace from the backu...
-
编辑 删除
043-017
17. The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover thatthe only member of an unarchived redo log group containing info...
-
编辑 删除
043-016
16. Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find thatthe performance of the database decreases initially, until the...
-
编辑 删除
043-014
14. Consider the following configuration:/devices/D1 is a member of disk group dgroupA./devices/D2 is a member of disk group dgroupA./devices/D3 is a member of disk group dgroupA.You plan to add a new...
