Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 301:

  The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? (Choose two)

  A. All the related indexes and views are automatically dropped

  B. The flashback drop feature can recover only the table structure

  C. Only the related indexes are dropped whereas views are invalidated

  D. The flashback drop feature can recover both the table structure and its data

  Correct Answer: CD

• Question 302:

  Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

  A. Undo retention guarantee for the database must be configured.

  B. Supplemental log must be enabled for the primary key.

  C. Supplemental log must be enabled.

  D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

  Correct Answer: BCD

• Question 303:

  Note the following statements that use flashback technology:

  1.

  FLASHBACK TABLE [table] TO SCN ;

  2.

  SELECT * FROM [table] AS OF SCN 123456;

  3.

  FLASHBACK TABLE [table] TO BEFORE DROP;

  4.

  FLASHBACK DATABASE TO TIMESTAMP ;

  5.

  SELECT * FROM [table] VERSIONS AS OF SCN 123456 AND 123999;

  Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

  A. 1, 2, and 5

  B. 1, 3, and 4

  C. 2, 3, 4, and 5

  D. 1, 2, 3, 4, and 5

  Correct Answer: A

  The BEFORE DROP clause uses Recycle Bin;

  The FLASHBACK DATABASE uses flashback logs at FRA area.

• Question 304:

  You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.

  You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:

  SQL> SELECT object_name, original_name, droptime FROM recyclebin;

  

  What would be the outcome of the precedent statement?

  A. It retrieves the latest version of the table from the recycle bin

  B. It retrieves the oldest version of the table from the recycle bin

  C. It retrieves the version of the table for which undo information is available

  D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

  Correct Answer: A

• Question 305:

  A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

  A. Initiate an incomplete recovery operation using RMAN.

  B. Copy the table from a development database.

  C. Advise the user to rekey the data.

  D. Perform a Flashback Drop operation.

  E. Perform a Flashback Recovery operation.

  Correct Answer: D

• Question 306:

  On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time?

  A. Check the alert log file

  B. Query the V$FLASHBACK_DATABASE_LOG view

  C. Query the V$RECOVERY_FILE_DEST_SIZE view

  D. Query the V$FLASHBACK_DATABASE_STAT view

  E. Check the value assigned for the UNDO_RETENTION parameter

  Correct Answer: B

  To query the V$FLASHBACK_DATABASE_LOG to get the lowest SCN or the nearest TIMESTAMP to decide the recovery possibility.

• Question 307:

  Examine the following commands and their output:

  SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';

  ENAME SAL

  JAMES 1050

  SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES'; 1 row updated.

  SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';

  ENAME SAL

  JAMES 2310

  View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.

  What could be the possible cause for the query not displaying any row?

  Exhibit:

  

  A. Flashback logging is not enabled for the database.

  B. The changes made to the table are not committed.

  C. Supplemental logging is not enabled for the database.

  D. The database is not configured in ARCHIVELOG mode.

  Correct Answer: B

• Question 308:

  Before a Flashback Table operation, you execute the following command:

  ALTER TABLE employees ENABLE ROW MOVEMENT;

  Why would you need this to be executed?

  A. Because row IDs may change during the flashback operation

  B. Because the object number changes after the flashback operation

  C. Because the rows are retrieved from the recycle bin during the flashback operation

  D. Because the table is moved forward and back to a temporary during the flashback opertion

  Correct Answer: A

• Question 309:

  The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.

  Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)

  Exhibit:

  

  A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.

  B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.

  C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.

  D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

  Correct Answer: AD

  Using Oracle Flashback Transaction Query with Oracle Flashback Version Query (link) The query uses Oracle Flashback Version Query pseudocolumns:

  SELECT versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN, versions_operation OPERATION, empname, salary FROM emp

  VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE

  WHERE empno = 111;

  Results are similar to:

  

  3 rows selected.

  The results table rows are in descending chronological order.

  The third row corresponds to the version of the row in the table emp that was inserted in the table when the table was created.

  The second row corresponds to the row in emp that the erroneous transaction deleted.

  The first row corresponds to the version of the row in emp that was reinserted with a new employee name.

• Question 310:

  In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)

  A. Ensure that database is running with version 10.1 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 ARCHIVELOG mode

  Correct Answer: CD