1z0-020 Oracle8i: New Features for Administrators Part 1
Oracle8i: New Features for Administrators Part 1
get Full version on: http://www.updateddumps.com/
QUESTION 1
Which two statements are true? (Choose two)
A. Dimensions are based on summaries.
B. The ALTER MATERIALIZED VIEW CONSIDER FRESH statement directs Oracle to consider the
materialized view fresh, and therefore eligible for query rewrite in the TRUSTED or STALE_TOLERATED
mode only.
C. Summaries without dimensions are used for faster aggregation.
D. Additional query rewrites at a higher level of aggregation can take place if summaries are created at the
lowest level of aggregation.
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 2
Which two statements are true? (Choose two)
A. Composite partitioning supports local indexes.
B. Composite partitioning supports hash-partitioned global indexes.
C. Composite partitioning supports range-partitioned global indexes
D. Composite partitioning supports composite-partitioned global indexes.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 3
Which tool, integrated with Oracle universal installer, can be used by third-party vendors to install their products
as art of an Oracle installation?
A. Oracle Software Packager.
B. Java Run-Time environment.
C. Database migration assistant.
D. Optimal flexible architecture.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
QUESTION 4
Which two options are valid for LOBs during their creation? (Choose two)
A. REDO
B. NOREDO
C. LOGGING
D. NOLOGGING
E. RECOVERABLE
F. UNRECEOVERABLE
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 5
You set the PARALLEL_AUTOMATIC_TUNING initialization parameter to FALSE.
What happens? (Choose two)
A. Parallel execution buffers are allocated from the large pool.
B. Parallel execution
buffers are allocated from the shared pool.
C. Only tables with a degree of parallelism specified will be scanned in parallel.
D. A load balancing algorithm will be used to distribute evenly load across nodes in a multi instance PQ
environment.
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
get Full version on: http://www.updateddumps.com/
QUESTION 6
Which parameter would you use to set up archiving to a remote machine?
A. LOG_ARCHIVE_DEST
B. LOG_ARCHIVE_DEST_2
C. LOG_ARCHIVE_REMOTE_DEST
D. ARCHIVE_REMOTE_DEST
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
QUESTION 7
Which two factors can influence the time taken for instance recovery? (Choose two)
A. Size of the redo log buffer.
B. Value of FAST_START_TO_TARGET
C. Size of the system tablespace.
D. Value of RECOVERY_PARALLELISM
E. The number of archived redo logs that have to be read.
F. The number of tables stored in the database buffer cache at the moment of failure.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 8
Examine this command:
ALTER SYSTEM SET USESTORED_OUTLINE=TRUE;
Which outline category will be used?
A. SYS
B. OUTLINE
C. TRUE
D. DEFAULT
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 9
Which tablespace stores the segment of a temporary table?
A. The default tablespace for user SYS.
B. The temporary tablespace for user SYS.
C. The default tablespace for the current user.
D. The temporary tablespace for the current user.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 10
What can you see when querying V$LOGMNR_CONTENTS?
A. The SQL statement run and the old image.
B. The SQL statement run, and the new
image.
C. Only the redo generated by the current schema.
D. The SQL statement run, and the relevant undo SQL statement.
E. The old image and the new image of the row that was modified.
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
Explanation:
The V$LOGMNR_CONTENTS table includes multiple sets of place holder columns. Each place holder column
set contains a name column, a redo value column, and an undo value column.
get Full version on: http://www.updateddumps.com/
Comments
Post a Comment