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:

Get full version on:http://www.getfreedumps.com/

Comments

Popular posts from this blog

1Z0-023 Oracle8i: Architecture and Administration Part 2

1Z0-024 Oracle8i: Performance and Tuning Part 3