QUESTION: 1
Oracle9 i provides a database package called dbms_redefinition to perform an online rebuild of
a table. Which two steps are you recommended doing prior to issuing the
dbms_redefinition.start_redef_table procedure call? (Choose two).

A. create an empty interim table with all the desired characteristics
B. invoke the dbms_redefinition.can_redef_table procedure
C. grant privileges on the interim table
D. invoke the dbms_redefinition.sync_interim_table procedure
E. create any triggers, indexes, or constraints on the interim table
Answer(s): A, B

QUESTION: 2
What must you do to enable Automated SQL Execution Memory Management?

A. Set the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE,
CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and
SORT_AREA_RETAINED_SIZE all to AUTO.
B. Set the instance parameters PGA_AGGREGATE_TARGET and
WORKAREA_SIZE_POLICY to appropriate values.
C. Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE,
CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and
SORT_AREA_RETAINED_SIZE.
D. Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values
Answer(s): B

QUESTION: 3
When enabling Flashback using a wall-clock time, within what period does the database choose
a System Commit Number (SCN)?

A. one minute of the time specified
B. one second of the time specified
C. five minutes of the time specified
D. five seconds of the time specified
Answer(s): C

QUESTION: 4
What is the meaning of using "character semantics" to create a table?

A. You specify the width of a column in characters, not in bytes.
B. You use single letter names of all columns.
C. You use only character type data types (CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB,
NCLOB).
D. Al columns are a single character wide.
E. You use only use CHAR data types.
2

Free Oracle 1Z0-030 Exam Braindumps

Pass your Oracle9i New Features for Administrators exam with these free Actual Questions and Answers

1Z0-030 Exam Discussions & Posts