Category: Oracle Exam

QUESTION 1 Examine the parameters for your database instance: NAMETYPE VALUE ————————– ——————————- ————————— undo_management string AUTO undo_retentioninteger 12 00 undo_tablespace string UNDOTBS1 You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario? A.    Undo data is written to flashback logs after 1200 seconds. B.    Inactive undo...

QUESTION 1 You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the credit period. 2) The data in the column should be stored in a format such that it can...

QUESTION 1 You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance? A.    Enable Memory Access Mode, which reads performance...