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:
Comments
Post a Comment