1z0-020 Oracle8i: New Features for Administrators Part 3

Oracle8i: New Features for Administrators Part 3

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


QUESTION 21

What does using the package DBMS_RESOURCE_MANAGER enable you to do?
A. Dynamically change profiles assigned to sets of users.
B. Limit the degree of parallelism on a given set of tables.
C. Guarantee a minimum degree of parallelism to a set of users.
D. Distribute available processing resources among sets of users.
E. Guarantee certain sets of users a minimum amount of disk space.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:

QUESTION 22

Which two statements are true? (Choose two)
A. Composite partitioning supports partition-wise dumps.
B. Composite partitioning improves performance for parallel DML.
C. Composite partitioning is used primarily in OLTP environments.
D. Composite partitioning allows more granular partition elimination.
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:

QUESTION 23

Which two statements are true for materialized views? (Choose two)
A. They must be built in the SYSTEM tablespace.
B. They can reduce the aggregation
required for a query.
C. They are rebuilt with the ALTER VIEW . . . REBUILD command.
D. They can be created in a different tablespace than the base tables.
E. A container table stores the data for multiple materialized view objects.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:

QUESTION 24

Which statement is true?
A. Materialized view based on prebuilt tables are eligible for selection by query rewrite, provided that the
QUERY_REWRITE_INTEGRITY parameter is set to TRUSTED or STALE_TOLERATED.
B. Query rewrites occur only if dimensions are present.
C. Materialized views are eligible for fast refresh even if the defining query contains an analytic function in 8.1.6
D. Query rewrites occur only if summaries are created at the lowest level of aggregation.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:

QUESTION 25

Which would you use to create a multiple databases with the same configuration?
A. ORAINST
B. Enterprisemanager
C. Universal installer
D. Database Replication Assistant
E. Database configuration Assistant
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:

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



QUESTION 26

What is characteristic of autonomous transactions?
A. They share resources with the calling transaction.
B. Committed changes in an autonomous transaction are visible to other transactions (except possibly the
calling transaction) regardless of whether the calling transaction commits or rolls back.
C. Deadlocks between the autonomous transaction and its calling transaction are previewed.
D. Savepoint names need to be unique between the calling transaction and the autonomous transaction.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:

QUESTION 27

A stored outline uses which database feature when creating an execution plan for a SQL statement?
A. SQL statement hints.
B. Statement pinning in the large pool.
C. Statement pinning in the shared pool.
D. Automatic analysis of objects to collect current statistics.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:

QUESTION 28

Which action can be performed on a composite index partition?
A. Dropping the partition.
B. Splitting the partition.
C. Modifying the partition of a global index.
D. Rebuilding the partition of a local index.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:

QUESTION 29

Which statement is true for locally managed tablespaces?
A. A free list contains information about free blocks in the file.
B. A set of blocks in the system tablespace tracks space usage.
C. Dictionary tables in the system tablespace track space usage.
D. A file bitmap contains information about free blocks in the file.
E. A dictionary table contains information about free blocks in the file.
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:

QUESTION 30

When creating plans with database resources management, the pending area is used to _______.
A. Roll back a transaction
B. Store resource usage statistics
C. Facilitate validation before committing
D. Hold rows inserted into temporary tables.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:

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

Comments

Popular posts from this blog

1z0-020 Oracle8i: New Features for Administrators Part 2

1Z0-023 Oracle8i: Architecture and Administration Part 2

1Z0-024 Oracle8i: Performance and Tuning Part 3