- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
76.
In order to perform Flashback Transaction Query operations, which of these steps are
required? (Choose all that apply.)
- A.Ensure that the database is running with version 10.1 or greater compatibility.
- B.Enable Flashback Logging.
- C.Enable Supplemental Logging.
- D.Ensure that the database is running with version 10.0 compatibility.
- E.Ensure that the database is in archive log mode.
- Answer & Explanation
- Report
Answer : [C, D]
Explanation :
Explanation :
| Version 10.0 or higher compatibility must be set, so option A is incorrect. Option B is incorrect because there is no such thing as Flashback Logging. Option E is incorrect because ARCHIVELOG mode has no effect on Flashback Transaction Query functionality. |
77.
Users notify you that their application is failing every time they try to add new records.
Because of poor application design, the actual ORA error message is unavailable. What
might be the problem? (Choose the best answers.)
- A.The application user has exceeded their undo quota.
- B.The FLASHBACK GUARANTEE option is set on the undo tablespace.
- C.The table is currently being queried by a Flashback Transaction Query operation.
- D.The table is currently being queried by a Flashback Version Query operation.
- E.The RETENTION GUARANTEE option is set on the undo tablespace.
- F.The application was coded by an idiot.
- Answer & Explanation
- Report
Answer : [A,E]
Explanation :
Explanation :
| The likely causes are that the RETENTION GUARANTEE option has been set on the undo tablespace and there are no expired transactions to remove to make room for new transactions, or that the user has exceeded the undo quota that has been set by the database resource manager. FLASHBACK GUARANTEE is not a valid option, so option B is incorrect. Flashback queries would not interfere with transactions entering the system, so options C and D are incorrect. |
78.
Which of the following statements best describes Flashback Version Query?
- A.Flashback Version Query is used to make changes to multiple versions of data that existed between two points in time.
- B.Flashback Version Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
- C.Flashback Version Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
- D.Flashback Version Query is used to view all version changes on rows that existed between two points in time.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Flashback Version Query does not change data at all, so option A is incorrect. B could be correct, but only if one of the specified points in time was the current timestamp. Therefore, B is not the best description. Option C is incorrect because Flashback Version Query does not provide the SQL to undo the changes. |
79.
Which pseudocolumn could you use to identify a unique row in a Flashback
Version Query?
- A.XID
- B.VERSIONS_PK
- C.VERSIONS_XID
- D.VERSIONS_UNIQUE
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The VERSIONS_XID column contains the unique transaction identifier for the row. None of the other choices are valid pseudocolumn names. |
80.
Which of the following can be used in conjunction with a Flashback Version Query to
filter the results? (Choose all that apply.)
- A.A range of SCN values
- B.A list of SCN values
- C.Starting and ending timestamps
- D.Minimum and maximum sequence values
- E.A list of sequence values
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| Lists of values are not valid, so both B and E are incorrect. Also, sequence values are not valid, so D is also incorrect. |
|
|
||||||||||||||||||||||||||||
