Oracle Exam 1Z0-595 Topic 3 Question 1 Discussion

Actual exam question for Oracle's 1Z0-595 exam

Question #: 1
Topic #: 3

When you enable versioning using the DBMS_WM.EnableVersioning('PARCELS') command, what is the impact on the PARCELS table?

AIt adds some columns to thePARCELStable and fills in metadata to enable long transaction mechanisms. You will be only user having access to that table.

BIt adds some columns to thePARCELStable, renames itPARCELS_LT, and creates aPARCELSview with an ''instead off'' trigger to enable long transaction mechanisms.

CIt creates aPARCELS_LTtable that should be used in an application to enable long transactions. Each row will then be saved and versioned.

DIt locks thePARCELStable. Only thePARCELS_LTtable is available to be used within the applications. You should merge the workspace to use it again.

Show Suggested Answer

Suggested Answer: B

DBMS_WM.EnableVersioningversion-enables a table, creating the necessary structures to enable the table to support multiple versions of rows.

References:

http://download.oracle.com/otndocs/products/workspace_manager/pdf/wrkspmgr_longtrans_s298742_120403.pdf, page 9

https://docs.oracle.com/cd/B19306_01/appdev.102/b14253/long_ref.htm

by Dorthy at Dec 27, 2022, 01:09 AM

Limited Time Offer

25%

Off