- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
71.
Which of the following Oracle features utilize the undo tablespace? (Choose all that apply.)
- A.Flashback Query
- B.Flashback Drop
- C.Flashback Table
- D.Flashback Database
- E.Transaction Processing
- F.Recycle Bin
- Answer & Explanation
- Report
Answer : [A, C, E]
Explanation :
Explanation :
| Flashback Drop utilizes the Recycle Bin, which does not use the undo tablespace; therefore options B and F are incorrect. Flashback Database is a physical recovery method and does not use undo; therefore option D is incorrect. |
72.
Which of the following statements are true regarding the Recycle Bin? (Choose all
that apply.)
- A.The Recycle Bin is a physical storage area for dropped objects.
- B.The Recycle Bin is a logical container for dropped objects.
- C.The Recycle Bin stores the results of a Flashback Drop operation.
- D.The objects in the Recycle Bin are stored in the tablespace in which they were created.
- Answer & Explanation
- Report
Answer : [B, D]
Explanation :
Explanation :
| The Recycle Bin is a logical container of Flashback dropped objects. The objects in the Recycle Bin are stored in the tablespace they were created in. |
73.
Over the course of a day, a department performed multiple DML statements (inserts,
updates, deletes) on multiple rows of data in multiple tables. The manager would like
a report showing the time, table name, and DML type for all changes that were made.
Which Flashback technology would be the best choice to produce the list?
- A.Flashback Drop
- B.Flashback Query
- C.Flashback Transaction Query
- D.Flashback Version Query
- E.Flashback Table
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Flashback Transaction Query could provide the data requested in a single query. Option A is an invalid choice because the table wasn’t dropped. Option B is incorrect because Flashback Query returns data at only a specific point in time, not for a range of times. Option D is incorrect because, although it could produce the data needed for the report, Flashback Version Query would have to be run for each table individually. Option E is incorrect because the user does not want to recover the table at all. |
74.
A user named Arren is executing this query:
select table_name, operation, undo_sql
from
flashback_transaction_query t,
(select versions_xid as xid
from employees versions between scn minvalue
and maxvalue
where employee_id = 123) e
where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error.
Since the user owns the employees table, you know that it is not the problem. Which of the following SQL statements will correct this problem?
select table_name, operation, undo_sql
from
flashback_transaction_query t,
(select versions_xid as xid
from employees versions between scn minvalue
and maxvalue
where employee_id = 123) e
where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error.
Since the user owns the employees table, you know that it is not the problem. Which of the following SQL statements will correct this problem?
- A.GRANT SELECT ANY TRANSACTION TO ARREN;
- B.GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
- C.GRANT SELECT_ANY_TRANSACTION TO ARREN;
- D.GRANT FLASHBACK TO ARREN;
- E.GRANT SELECT ANY VIEW TO ARREN;
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The user needs to have the SELECT ANY TRANSACTION privilege granted to him. All of the other choices are incorrect. |
75.
AUM has been retaining about 15 minutes’ worth of undo. You want to double the
retention period but not at the expense of new transactions failing. You decide to alter
the system to set the parameter UNDO_RETENTION=18000 . However, AUM still retains
only about 15 minutes’ worth of undo. What is the problem? (Choose the best answer.)
- A.You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
- B.You need to increase the size of the undo tablespace.
- C.The undo tablespace is not set to autoextend.
- D.You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| AUM will ignore the UNDO_RETENTION parameter if the undo tablespace is not set to autoextend. Option A is incorrect because guaranteeing retention could result in failed transactions, which you specifically want to avoid. Option B is not the best answer because the size of the undo tablespace is not the cause of the issue, but increasing the size of the undo tablespace could increase the amount of undo retained. Option D is wrong because this question is not dealing with the Recycle Bin and because it has no guaranteed retention setting. |
|
|
||||||||||||||||||||||||||||
