Which four are true regarding the workspace Manager in Oracle 10G? (choose four)
A.
automatically versions all tables
B.
automatically installed with Oracle 10G.
C.
provides concurrency by isolating versions of data until they are explicity merged with production data or discarded
D.
provides mechanism to identify and resolve conflicts
E.
allows for version enabling tables by use of a packaged procedure
F.
creates a database wide system table that maps row versions to workspaces and is visible to all users
Explanation:
Workspace Manager lets you version-enable one or more user tables in the database. When a table is version-enabled, all rows in the table can support multiple versions of the data.
A workspace is a virtual environment that one or more users can share to make changes to the data in the database. A workspace logically groups collections of new row versions from one or more version-enabled tables, and isolates these versions until they are explicitly merged with production data or discarded, thus providing maximum concurrency.
Workspace Manager automatically detects conflicts, which are differences in data values resulting from changes to the same row in a workspace and its parent workspace. You can use workspace locks to avoid conflicts.
Workspace Manager is installed by default in the seed database and in all databases created by the Database Configuration Assistant (DBCA). D – False. The Workspace manager detects conflicts, but YOU must resolve conflicts before merging changes from a workspace into its parent workspace. F- False. Will be visible only AFTER making the changes public. REF.: Oracle(r) Application Developer’s Guide – Workspace Manager 10g Release 2 (10.2), 1-2 and 1-3