Which two statements are true when row archival management is enabled? (Choose two.)
A.
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
B.
The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
C.
The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D.
The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
E.
The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer
Option D:
To manage in-database archiving for a table, you must enable ROW ARCHIVAL for the table either CREATE TABLE/ALTER TABLE, for example:
CREATE TABLE residents (
id NUMBER,
street VARCHAR2(50),
CONSTRAINT tbb1_pk PRIMARY KEY (id))
ROW ARCHIVAL;
Enabling in-database archiving causes the addition of a system generated hidden
column called ORA_ARCHIVE_STATE
SELECT column_id, column_name, data_type, data_length, hidden_column FROM user_tab_cols
WHERE table_name = 'RESIDENTS'
ORDER BY column_id;
COLUMN_ID COLUMN_NAME DATA_TYPE DATA_LENGTH HID
---------- -------------------- -------------------- ---------- ---
1 ID NUMBER 22 NO
2 STREET VARCHAR2 50 NO
ORA_ARCHIVE_STATE VARCHAR2 4000 YES
Option C: By default, ORA_ARCHIVE_STATE column is populated with the value '0' for each row
When the value for ORA_ARCHIVE_STATE is set to '0' then that row is visible to applications, meaning that the row is active and visible via a standard query
alter session set row archival visibility = all;
select employee_id, first_name, ora_archive_state from hr.employees;
ORA-00904: "ORA_ARCHIVE_STATE": invalid identifier
alter table hr.employees row archival;
select employee_id, first_name, ora_archive_state from hr.employees;---now output returned. So, ROW ARCHIVAL VISILITY does not control ora_archive_state visibility.
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/ilm/row_archival/row_archival.html
I think
https://oracle-base.com/articles/12c/in-database-archiving-12cr1
Answer is B C D or.... CD? (if hggz is right. but I do not know why B is wrong. )
B is wrong. The “OR by a program that could reference
activity tracking columns” is false
upvoted 4 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
mynameisladyviolette
2 years, 4 months agoRay520
2 years, 10 months agoJMAN1
3 years agoeuler
5 years, 5 months agohggz
4 years, 11 months ago