-
编辑 删除
043-176
176. Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log s...
-
编辑 删除
043-175
175. You have a read-only tablespace on read-only media. You want toperform. a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the st...
-
编辑 删除
043-174
174. You want to create a consumer group, GROUP1, and you execute thefollowing command in the command-line interface:SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP =>'group1', CO...
-
编辑 删除
043-173
173. You need to create a schedule that will run a job on the secondFriday of each month. What should the repeat interval of the schedulebe set to?A. FREQ = MONTHLY; BYDAY = 2FRI;B. FREQ = MONTHLY; BY...
-
编辑 删除
043-172
172. 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 sta...
-
编辑 删除
043-171
171. Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts.Which method would you use to create jobs without specifying t...
-
编辑 删除
043-170
170. A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect...
-
编辑 删除
043-169
169. The EMPLOYEES table is stored in the USERS tablespace. You needto check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?A. the...
-
编辑 删除
043-168
168. You are working on an Oracle Database 10g database that operatesin the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictio...
-
编辑 删除
043-167
167. In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The followingcommands are used in the process of recovering the database by ...
-
编辑 删除
043-166
166. You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS)user deletes all the redo log files in a group. What will happ...
-
编辑 删除
043-165
165. You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sund...
-
编辑 删除
043-164
164. You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?A. streams poolB. shared poolC. log bufferD. keep buffer cacheE. rec...
-
编辑 删除
043-163
163. You are managing a database for which incremental backups can bevery time consuming. In order to perform. optimized incremental backups you enable the block change tracking feature. How would you...
-
编辑 删除
043-162
162. You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? (Choose two.)A. The member jobs would get dropped when the job class is drop...
-
编辑 删除
043-161
161. The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perfor...
-
编辑 删除
043-160
160. Which two statements are correct regarding the Flashback Versions Query feature? (Choose two.)A. You can use this feature to identify the committed versions of therows, but not the uncommitted ve...
-
编辑 删除
159
159. You executed the following FLASHBACK TABLE command:FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi');Which two statements are correct? (Choose two.)A. The FLASHBACK TABLE statement will not be...
-
编辑 删除
043-158
158. Every Sunday, consistent backups are performed on your database.Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user ...
-
编辑 删除
043-157
157. The loss of the control file forced you to re-create the controlfile. After re-creating it and opening the database, you find that some of the data files are named as MISSING nnnnn, where nnnnn i...
