What is true about version-enabled tables?
A. The unit of versioning is the schema.
B. It is possible to version enable a table pertaining to SYS.
C. There are as many segments as versions for the same base table.
D. It is possible to create workspaces if there is no version-enabled table in the database.
Answer: D
Explanation:
A workspace is a virtual database facility that enables you to maintain multiple versions of one row of data and it enables each workspace context to reference a different version of this row as compared to another workspace context. It’s possible to create a workspace if there is no version-enabled table in the database.
Incorrect Answers
A: The unit of versioning is the table, not the schema.
B: It is not possible to version enable a table in SYS schema.
C: This statement about the same amount of segments as versions for the same base table is incorrect.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 168-176
Chapter 3: Manageability Enhancements
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment