-
编辑 删除
043-199
199: 117. In Recovery Manager (RMAN), you set the retention policy to NONEby executing the followingcommand:CONFIGURE RETENTION POLICY TO NONE;What would be the impact of this setting?A.The retention ...
-
编辑 删除
043-200
200: You execute the following command to perform. a backup by usingRecovery Manager (RMAN):RMAN> run{allocate channel c1 type sbt;backup datafile 1;}The command errors out. A part of the error messag...
-
编辑 删除
043-201
201: Using the LIST command in Recovery Manager (RMAN), which two piecesof information from the RMAN repository can be listed? (Choose two.)A.backups that can be deletedB.stored scripts in the recover...
-
编辑 删除
043-202
202: The backup retention policy is configured as RECOVERY WINDOW 2. Youexecuted the followingcommand in Recovery Manager (RMAN) against your database:RMAN> REPORT OBSOLETE;What would you see in the o...
-
编辑 删除
043-203
203: In the parameter file of the production database, theBACKGROUND_DUMP_DEST parameter is setto $ORACLE_HOME/users. Which two types of files would you find in thislocation? (Choose two.)A.the alert ...
-
编辑 删除
043-204
204: In which case would you use the Flashback Database feature to performa recovery?A.to recover a dropped tablespaceB.to recover data from a truncated tableC.to recover a data file that has been shr...
-
编辑 删除
043-205
205: You performed a backup of the flash recovery area by using thefollowing command for the first time:RMAN> BACKUP RECOVERY AREA;Which files in the flash recovery area are backed up? (Choose all tha...
-
编辑 删除
043-189
189: You have many users complaining about slow inserts into a large table.While investigating the reason,you find that the number of indexes on thetable is high. You want to find out which indexes ar...
-
编辑 删除
043-188
188: In your datawarehousing application, you generate reports frequently.The data is static in the tables being used to generate reports. You arecurrently using joins, resulting in a large performanc...
-
编辑 删除
043-187
187: In your production database, you have observed that the databaseserver performance degrades ,whenever there is a switch between the loggroups. On further investigation, you find that the database...
-
编辑 删除
043-186
186. You want to configure the Flashback Database feature and retainflashback logs for three days.The steps used in this process are:A.Set the retention target:SQL> ALTER SYSTEM SET DB_FLASHBACK_RETEN...
-
编辑 删除
043-185
185.Identify four uses of the Oracle Scheduler.(Choose four.)A.enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB.enables Oracle database to...
-
编辑 删除
043-184
184. You executed the following command in Recovery Manager (RMAN) toperform. a backup of the DETTBS tablespace:RMAN> BACKUP TABLESPACE DETTBS;Under which conditions would this command execute success...
-
编辑 删除
043-183
183. You are connected to Recovery Manager (RMAN) without a recoverycatalog. There is no copy of the control file available. You want torestore the control file from an autobackup. To retrieve the aut...
-
编辑 删除
043-182
182. In which two conditions are resumable statements suspended? (Choose two.)A. when a user exceeds the space quotaB. when a user session is terminatedC. when a table that is being accessed by the cu...
-
编辑 删除
043-181
181. View the Exhibit. You executed the following command to performa backup of the USERS tablespace:RMAN> BACKUP TABLESPACE USERS;Which three types of files are backed up? (Choose three.)Exhibit:A. a...
-
编辑 删除
043-180
180. You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with ...
-
编辑 删除
043-179
179. The backup retention policy is configured as RECOVERY WINDOW 2.You executed the following command in Recovery Manager (RMAN) againstyour database:RMAN> REPORT OBSOLETE;What would you see in the o...
-
编辑 删除
043-178
178. You have an Automatic Storage Management (ASM) instance managingthe database files of your production database. The database containsASM files and non-ASM files. Using Recovery Manager (RMAN), yo...
-
编辑 删除
043-177
177. On Monday, you dropped the DEPT table from your schema and thenyou re-created the DEPT table in your schema. On Wednesday, you havea requirement to restore the DEPT table from the recycle bin. Wh...
