Oracle8i New Features for Administrators Set 1

1.

Which tool, integrated with Oracle universal installer, can be used by third-party vendors to install their products
as art of an Oracle installation?

Oracle Software Packager. Java Run-Time environment. Database migration assistant. Optimal flexible architecture.

2.

Which parameter would you use to set up archiving to a remote machine?

LOG_ARCHIVE_DEST

LOG_ARCHIVE_DEST_2

LOG_ARCHIVE_REMOTE_DEST

ARCHIVE_REMOTE_DEST

3.

Examine this command:

ALTER SYSTEM SET USESTORED_OUTLINE=TRUE;

Which outline category will be used?

SYS OUTLINE 1 DEFAULT

4.

Which tablespace stores the segment of a temporary table?

The default tablespace for user SYS. The temporary tablespace for user SYS. The default tablespace for the current user. The temporary tablespace for the current user.

5.

What can you see when querying V$LOGMNR_CONTENTS?

The SQL statement run and the old image. The SQL statement run, and the newimage. Only the redo generated by the current schema. The SQL statement run, and the relevant undo SQL statement. The old image and the new image of the row that was modified.

6.

What happens during a complete refresh of a materialized view?

The materialized view is dropped and recreated. Changes in the materialized view areapplied to the underlying table. Changes captured in the materialized view log are applied to the materialized view. The materialized view is truncated or deleted and repopulated by re-executing the materialized view query.

7.

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?

SELECT COUNT (*)
FROM classes
ORDER BY stopkey;

SELECT COUNT (*)FROM classes
ORDER BY start_date;

SELECT *FROM (SELECT * FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM<11;

SELECT *FROM (SELECT * FROM classes
WHERE ROWNUM< 11)
ORDER BY start_date DESC;

8.

What is the maximum number of archival destinations allowed in Oracle 8i?

1 2 3 5 7

9.

What is true about creating indexes for a index-organized table?

Indexes cannot be added to index-organized tables. An index can be created only for the primary key values. An index can be created for any column or set of columns in the table. At most, one index can be created for the primary key values and one for nonprimary key values.

10.

Which command will no longer be supported after Oracle 8.1?

CONNECT INTERNAL CONNECT/ AS SYSDBA CONNECT/ AS SYSTEM CONNECT/ AS SYSOPER

Oracle8i New Features for Administrators Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle8i New Features for Administrators Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner