053 (76)

376.

376. AUserNamed Arren isexecuting this query:Selecttable_name, operation, Undo_sql fromflashback_transaction_query T, (SelectVersions_xid asXID fromEmployees versionsbetweenSCN MinValue andMaxValuewhereemployee_id= 123) ewhereT.xid=E.xid; whenThe query runs, he receives an ORA-01031: InsufficientPrivilegesError. Since theUserOwns the employeesTable, you know that it is  notThe problem. which ofThe following SQL statements would correct this problem? A.GRANT SELECT  any TRANSACTION  toARREN; B.GRANT SELECT  onFlashback_transaction_query toARREN; C.GRANTSelect_any_transaction toarren;d.GRANTFLASHBACK toARREN; E.GRANT SELECT  any VIEW  toARREN;

377.

377. AUM have been retaining about theMinutes worth ofUndo. You want to DoubleThe retention period, but notAt the expense ofnew transactions failing. You decide to AlterThe system to SetThe parameter undo_retention=18000. However, AUM still retains onlyAbout theMinutes worth ofUndo. what isThe problem? (Choose the best answer.) A. You need to AlterThe Undo Tablespace to AddThe RETENTION GUARANTEE setting. B. You need toIncrease the size ofThe undo tablespace. C. The Undo tablespace is  not Set  toAuto-extend. D. You need to AlterThe Recycle Bin to AddThe RETENTION GUARANTEE setting.

378.

378.inch Order  toPerform FlashbackTransactionQuery operations, which ofThese steps is required? (Choose Allthat apply.) A. Ensure thatDatabase  isRunning withVersion10.1compatibility. B. Enable Flashback logging.c. Enable Supplemental LOGGING.D. Ensure that theDatabase  isRunning withVersion10.0compatibility. E. Ensure thatDatabase  is inchARCHIVELOG mode

379.

379. Users notify you their application isFailing every time they try to Addnew records. Because ofPoor application design, the actual ORA error message isunavailable. What might is the problem? (Choose the best answers.) A. The applicationUserhas exceeded their undo quota. B. The FLASHBACK GUARANTEEoption  is Set  onThe undo tablespace. C. theTable  isCurrently being queried byA FlashbackTransactionQuery operation. D. theTable  isCurrently being queried bya Flashback Versions Query operation. E. The RETENTION GUARANTEEoption  is Set  onThe Undo tablespace.

380.

380. which ofThe following statements best describes Flashback Versions Query? A. Flashback Versions Query isUsed toMake changes toMultiple Versions ofData that existedbetweenPointsinchTime . B. Flashback Versions Query isUsed to View  AllVersion changes onRows that existedbetweenThe time the query was executed andA pointinchTimeinchThe past. C. Flashback Versions Query isUsed to ViewVersion changes andThe SQL toUndo those changes onRows that existedbetweenPointsinchTime . D. Flashback Versions Query isUsed to View  AllVersion changes onRows that existedbetweenPointsinchTime.

053 (76)