1z0-020 Oracle8i: New Features for Administrators Part 2
Oracle8i: New Features for Administrators Part 2
Get full version on:http://www.getfreedumps.com/
QUESTION 11
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.
QUESTION 12
What happens during a complete refresh
of a materialized view?
A. The materialized view is dropped
and recreated.
B. Changes in the materialized view
are
applied to the underlying table.
C. Changes captured in the
materialized view log are applied to the materialized view.
D. The materialized view is truncated
or deleted and repopulated by re-executing the materialized view query.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 13
Examine this execution plan:
Execution Plan
0SELECT STATEMENT Optimizer = CHOOSE
10COUNT(STOPKEY)
21VIEW
32SORT (ORDER BY STOPKEY)
43TABLE ACCESS (FULL) OF 'CLASSES'
Which statement generated this
execution plan?
A. SELECT COUNT (*)
FROM classes
ORDER BY stopkey;
B. SELECT COUNT (*)
FROM classes
ORDER BY start_date;
C. SELECT *
FROM (SELECT * FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM<11;
D. SELECT *
FROM (SELECT * FROM classes
WHERE ROWNUM< 11)
ORDER BY start_date DESC;
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
QUESTION 14
What is the maximum number of archival
destinations allowed in Oracle 8i?
A. 1
B. 2
C. 3
D. 5
E. 7
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 15
What is true about creating indexes
for a index-organized table?
A. Indexes cannot be added to
index-organized tables.
B. An index can be created only for
the primary key values.
C. An index can be created for any
column or set of columns in the table.
D. At most, one index can be created
for the primary key values and one for nonprimary key values.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
Get full version on:http://www.getfreedumps.com/
QUESTION 16
Which command will no longer be
supported after Oracle 8.1?
A. CONNECT INTERNAL
B. CONNECT/ AS SYSDBA
C. CONNECT/ AS SYSTEM
D. CONNECT/ AS SYSOPER
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
QUESTION 17
In which tablespace are temporary LOBs
stored?
A. In the SYSTEM tablespace.
B. In the user's temporary tablespace.
C. In the user's default tablespace.
D. Any tablespace depending on the
temporary LOBs' definition.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 18
Which type of LOBs cannot be declared
as temporary?
A. CLOB
B. NCLOB
C. BLOB
D. BFILE
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 19
Which command will open a standby
database in read-only mode?
A. AFTER DATABASE OPEN READ ONLY;
B. STARTUP READ ONLY;
C. ALTER DAMOUNTREADONLY;
D. ALTER DATABASE READ ONLY;
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
QUESTION 20
Which two statements about dimensions
are true? (Choose two)
A. A hierarchy can consist of multiple
levels.
B. A dimension can be based on
multiple
tables.
C. A dimension can contain only a
single hierarchy.
D. No special privileges are required
to create a dimension.
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
Comments
Post a Comment