-
编辑 删除
043-156
156. You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?A. restore the tablespace from the backup, ...
-
编辑 删除
043-155
155. Which two statements regarding compressed backups in Recovery Manager (RMAN) are true? (Choose two.)A. Backup compression is disabled by default.B. Backup compression can be used with both backup...
-
编辑 删除
043-154
154. Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform. an incomplete recovery. Which two tasks would you be required to perform...
-
编辑 删除
043-153
153. View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace:SQL> ALTER TABLE trans SHRINK S...
-
编辑 删除
043-152
152. In your Automatic Storage Management (ASM) instance, one of thenonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following comma...
-
编辑 删除
043-151
151. You noticed that large memory allocations for the Oracle backupand restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid th...
-
编辑 删除
电子商务1
企业和企业之间 竞争是一种商业模式的竞争。 人与人之间的竞争也是一种模式的竞争。电子商务的优势在于消除中间商，消除现金流。电子商务失败的案例。没有市场经验。不能预计库存。...
-
编辑 删除
043-150
150. From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the databas...
-
编辑 删除
043-149
149. You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. Whatmethods can you use to re-create the indexes? (Choose all that...
-
编辑 删除
043-148
148. You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in theparameter file of the database:INSTANCE_TYPE = RDBMSDB_NAME = ...
-
编辑 删除
043-147
147. You have created a resource plan, PROD_DB_PLAN, that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan:Consumer gr...
-
编辑 删除
043-146
146. The database is running in ARCHIVELOG mode and the FORMAT optionis not configured in RMAN for disk backups. You configured the flashrecovery area location and size by using the DB_RECOVERY_FI...
-
编辑 删除
043-145
145. You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choosetwo.)A. backup piecesB. copies of all the parameter filesC. tra...
-
编辑 删除
043-145
145. You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choosetwo.)A. backup piecesB. copies of all the parameter filesC. tra...
-
编辑 删除
043-144
144. Last night, a media failure caused the loss of a temporary filethat belongs to your database. Which two things may happen this morning when you try to open your database? (Choose two.)A. The data...
-
编辑 删除
043-143
143. What are the prerequisites for enabling Flashback Database? (Choose all that apply.)A. The database must be started in the MOUNT EXCLUSIVE state.B. The database must have multiplexed control file...
-
编辑 删除
043-142
142. View the Exhibit and examine the characteristics of the USERS tablespace. You observe that a large volume of inserts and deletes arehappening on the TRANS table in the USERS tablespace and you su...
-
编辑 删除
043-041
141. The DB_BLOCK_CHECKING initialization parameter is set to FALSE.What level of block checking would be performed?A. The Oracle database will not perform. block checking for any of thedata blocks.B....
-
编辑 删除
043-140
140. You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)A. log bufferB. Java poolC. Large poolD. Fixed SGAE. Shared poolF. ...
-
编辑 删除
043-139
139. The database is currently running in the NOARCHIVELOG mode. Whatwould be the first step to configure Flashback Database?A. Enable flashback logging.B. Start the database in the ARCHIVELOG mode.C....
