OCP Oracle 12C Advanced Administration(1Z0-063) Set 4

In order to perform Flashback Transaction Query operations, which of these steps are required? 


Options are :

  • Enable Supplemental Logging.
  • Ensure that the database is in archive log mode.
  • Enable Flashback Logging.
  • Ensure that the database is running with version 10.1 or greater compatibility.

Answer : Enable Supplemental Logging.

1Z0-409 Oracle Linux Fundamentals Practice Test Set 3

Which of the following statements best describes Flashback Version Query?


Options are :

  • Flashback Version Query is used to view all version changes on rows that existed between two points in time.
  • 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.
  • Flashback Version Query is used to make changes to multiple versions of data that existed between two points in time.
  • 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.

Answer : Flashback Version Query is used to view all version changes on rows that existed between two points in time.

Which of the following are prerequisite steps to transport a database?


Options are :

  • Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the intended destination is listed.
  • Verify that there are no restrictions or limitations that the source or destination database may encounter.
  • None of the above

Answer : Verify that there are no restrictions or limitations that the source or destination database may encounter.

Which of these components, in order, correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?


Options are :

  • Instance number, username, session ID
  • Instance number, session ID, username
  • None of the above
  • Username, instance number, session ID
  • Username, session ID, instance number

Answer : Username, session ID, instance number

Oracle 1Z0-207 Billing & Revenue Mgmt Pricing Practice Exam Set 2

Which of the following can be used in conjunction with a Flashback Version Query to filter the results?


Options are :

  • A list of sequence values
  • Minimum and maximum sequence values
  • A list of SCN values
  • A range of SCN values

Answer : A range of SCN values

Which of the following are not fundamental tasks of the Support Workbench?


Options are :

  • Create a service request
  • TheGather additional diagnostic information.
  • View problem details.
  • View long-running SQL workloads.

Answer : View long-running SQL workloads.

Which of the following is not an advantage of block media recovery (BMR)?


Options are :

  • Data files remain online while corrupt blocks are repaired.
  • Reduced MTTR.
  • Data files remain offline while corrupt blocks are repaired.
  • A and C

Answer : Data files remain offline while corrupt blocks are repaired.

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 1

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?


Options are :

  • The application user has exceeded their undo quota.
  • The application was coded by an idiot.
  • The table is currently being queried by a Flashback Transaction Query operation.
  • The table is currently being queried by a Flashback Version Query operation.
  • The FLASHBACK GUARANTEE option is set on the undo tablespace.

Answer : The application user has exceeded their undo quota.

While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corrup- tion is verified. Which RMAN command do you use to perform BMR and repair the corrupt block? 


Options are :

  • RECOVER FILE=1201 BLOCK=1968;
  • RECOVER CORRUPTION LIST;
  • RECOVER BLOCK CORRUPTION LIST;
  • None of the above

Answer : RECOVER CORRUPTION LIST;

Choose the correct order to package and upload data for an incident to Oracle Support.


Options are :

  • Schedule, create new package, view manifest, view contents
  • Schedule, create new package, view contents, view manifest
  • None of the above
  • Create new package, view contents, view manifest, schedule
  • Create new package, view manifest, view contents, schedule

Answer : Create new package, view contents, view manifest, schedule

Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 3

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions