Which three are true for a version-enabled table?

Which three are true for a version-enabled table? (choose three)

Which three are true for a version-enabled table? (choose three)

A.
must have a primary key

B.
can be owned by the SYS user

C.
triggers that are not supported for version-enabled tables are deactivated when versioning is enabled

D.
a child table cannot be version-enabled without the parent table being version-enabled

E.
can be enabled or disabled by the table owner only

Explanation:
A – True. Must have a PK. The table that is being version-enabled must have a primary key defined. The primarykey can be a composite (multicolumn) primary key.

B – False. Tables owned by SYS CAN’T be version-enabled.

C – True . Any triggers that are not supported for version-enabled tables are deactivated when versioning is enabled, and are activated when versioning is disabled.

D – True – a workspace can be a parent to one or more workspaces (child workspaces).
By default, when a workspace is created, it is created from the topmost, or LIVE, database workspace.

E – False – The owner of a table or a user with the WM_ADMIN_ROLE role can disable versioning on the table.

REF: Oracle(r) Application Developer’s Guide – Workspace Manager 10g Release 2 (10.2), 4-40 and 4-44



Leave a Reply 1

Your email address will not be published. Required fields are marked *


seenagape

seenagape

I have the same idea.