-
编辑 删除
043-106
106. Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due toa space-related problem?A. functionsB. packageC. procedureD. da...
-
编辑 删除
043-105
105. Exhibit:View the Exhibit.You have more than one table in the recycle bin having the same original name, DEPT2. You do not have any table with the nameDEPT2 in yourschema. You executed the followi...
-
编辑 删除
043-104
104. Exhibit:View the Exhibits.You performed operations on the DEPT4 table as shown in the Exhibit.When you perform. the Flashback Versions Query, you find that the first two updates are not listed.Wh...
-
编辑 删除
043-103
103. You are using Oracle Database 10g. The log LOG_ARCHIVE_FORMAT parameter is set to 'LOG%t_%_s_%r.dbf'.Why is %r used in the file name format?A. To uniquely identify the archived log files with the...
-
编辑 删除
043-102
102. While designing the database for one of your online transactionprocessing (OLTP) applications, you want to achieve the following:a) high availability of datab) faster primary key access to the ta...
-
编辑 删除
043-101
101. You executed the following query in your database:SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;What would you determine from the output?A. The time when the la...
-
编辑 删除
043-100
100. You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sundaynight. On Tuesday, at 9:00 a.m. the current log sequence number was369. Also, on Tuesday you...
-
编辑 删除
043-099
99. You lost a data file that belongs to an index tablespace in yourdatabase, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries.Which two opt...
-
编辑 删除
043-098
98. Consider the following scenario: You have a directory, data, under the disk group tdgroupA.You want to create an alias for one of thedata files and you execute the following command:ALTER DISKGROU...
-
编辑 删除
043-097
97. Users in your production database complain that they are gettingthe following error message while trying to insert rows into the ORDERS table:ERROR at line 1:ORA-01654: unable to extend index USER...
-
编辑 删除
043-095
95. You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this ob...
-
编辑 删除
043-094
94. Which statement is true regarding the creation of nested plans using Resource Manager?A. Only one nested subplan is allowed.B. The plans can be nested up to four levels.C. Resource Manager does no...
-
编辑 删除
043-092
92. Your business has departmental reports that are generated every day. Each department must use the same set of queries, but access a different subset of data in the tables, depending on which depar...
-
编辑 删除
043-096
96. You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belongto the correct partition. Which option could you use?A. LogMin...
-
编辑 删除
043-090
90. You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? (Chooseall that apply)A. To recover a dropped table.B. To recover a dr...
-
编辑 删除
043-089
89. In Recovery Manager (RMAN), you have set control file autobackupto ON by using the following command:CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause thecontrol file to be backed ...
-
编辑 删除
043-091
91. Consider the following command to add a new disk group called "tdgroupA" with two failover groups:CREATE DISKGROUP tdgroupA NORMAL REDUNDANCYFAILOVERGROUP control01 DISK'/devices/A1','/devices/A2'...
-
编辑 删除
043-088
88. You execute the following RMAN command in the order shown below:BACKUP VALIDATE DATABASE;BLOCKRECOVER CORRUPTION LIST;What will these commands do?A. Create a backup of the database and recover all...
-
编辑 删除
043-087
87. What purpose would you achieve by enabling the block change tracking feature?A. Eliminate the necessity for backups.B. Perform. optimized image copy backups.C. Perform. optimized incremental backu...
-
编辑 删除
043-086
86. For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state? (Choose two)A. UPDATE TABLEB. CREATE CLUSTERC. TRUNCATE TABLED. ALTER TABLE MOVEE. INS...
