Oracle
1Z0-083 · Question #243
1Z0-083 Question #243: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #243. The question stem and answer options stay visible for context.
Oracle Database Architecture
Question
Which two statements are true when row-archival management is enabled?
Options
- AThe ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
- BThe ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select
- CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.
- DThe ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.
- EThe ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Row Archival Management#ORA_ARCHIVE_STATE column#Session Parameters#Data Visibility