Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 321:

  You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.

  You execute the following statement:

  FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;

  What will be the result of executing this statement?

  A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

  B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

  C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

  D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.

  Correct Answer: B

• Question 322:

  Which method would you use to undo the changes made by a particular transaction without affecting the made by other transactions?

  A. Point-in-time recovery

  B. Execute the ROLLBACK command with transaction number

  C. Flashback the database to before the transaction was committed

  D. Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

  Correct Answer: D

• Question 323:

  On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

  A. fixed tables

  B. heap tables

  C. external tables

  D. temporary tables

  E. Index-Organized Tables (IOTs)

  F. views

  Correct Answer: BE

• Question 324:

  The EMP table exists in your schema. You want to execute the following query:

  SELECT ename, sal

  FROM emp

  AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

  WHERE ename = 'ALLEN';

  What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

  A. ARCHIVELOG mode must be enabled

  B. Row Movement must be enabled for the table

  C. FLASHBACK must be set to ON for the database

  D. The UNDO_MANAGEMENT parameter must be set to AUTO

  E. The UNDO_RETENTION parameter must be set appropriately

  Correct Answer: DE

• Question 325:

  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

  Correct Answer: ACE

• Question 326:

  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.

  Correct Answer: BD

• Question 327:

  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 Versions Query

  E. Flashback Table

  Correct Answer: C

• Question 328:

  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?

  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;

  Correct Answer: A

• Question 329:

  You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.

  You issued the following command to drop the Flashback Archive FLA1:

  DROP FLASHBACK ARCHIVE fla1;

  What is the effect of this command?

  A. The Flashback Archive FLA1 is dropped only if it is empty.

  B. The tablespace having Flashback Archive is dropped.

  C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.

  D. The Flashback Data Archive and historical data are dropped.

  Correct Answer: D

• Question 330:

  You want to configure the Flashback Database feature and retain flashback logs for three days. Presently base is open and configured in ARCHIVELOG mode.

  The following steps must be performed in the correct sequence to do this:

  1.Set the retention target:

  SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;

  2.Enable Flashback

  Database:

  SQL> ALTER DATABASE FLASHBACK ON;

  3.Mount the database:

  SQL> STARTUP MOUNT EXCLUSIVE

  4.Shutdown the instance:

  SQL> SHUTDOWN IMMEDIATE

  5.Open the database:

  SQL> ALTER DATABASE OPEN; Choose the correct sequence.

  A. 4, 1, 3, 2, 5

  B. 4, 3, 1, 2, 5

  C. 2, 4, 3, 5, 1

  D. 4, 2, 5, 3, 1

  Correct Answer: B