Exam 1z0-020: Oracle8i: New Features for Administrators

Exam Number: 1Z0-020
Associated Certifications: Oracle8 DBA OCPs to Oracle8i DBA
Exam Price: $125.00 USD
Exam Registration: Register

Duration: 90 minutes
Number of Questions: 54
Passing Score: 67%
Recommended Training and Preparation
Oracle8i: New Features for Administrators
OCP – 8.0 to 8i Upgrade Exam Prep

Additional Information & Resources
Practice Exams

Oracle authorized practice exam from Self Test Software. 1Z0-020 Oracle8i: New Features for Administrators
Oracle authorized practice exam from Transcender: Cert-1Z0-020 : DBCert: 8i Database: New Features for Administrators
Oracle 8 and 8i DBA Candidate Guide
Exam Retake Policy

Exam Topics
Java in the Database
[ ] Describe Oracle java components
[ ] Describe JServer installation
[ ] Tune JServer

Optimizer and Query Improvements
[ ] Describe the features of optimizer plan stability
[ ] Describe the contents of the DBMS_STATS Package
[ ] Explain Top-N SQL queries
[ ] Identify new SQL keywords for computing subtotals
[ ] Identify new sort processing options
[ ] Explain automatic parallel execution
Summary Management
[ ] Build and Manage Materialized views for Oracle Summaries
[ ] Build and Manage Dimensions

Indexes and Index-Organized Tables
[ ] Describe bitmap indexes improvements
[ ] Describe a function-based index
[ ] Build an index online
[ ] Compute index statistics
[ ] Describe an index-organized table (IOT)
[ ] Explain logical ROWIDs
[ ] Create multiple indexes on an IOT
[ ] Explain how to partition an IOT

Partitioning Improvements
[ ] Revise the general partitioning concepts
[ ] Implement range, hash, and composite partitioning
[ ] Explain ENABLE/DISABLE ROW MOVEMENT
[ ] Explain the new partition pruning capabilities
[ ] Describe partition-wise join
[ ] Review partition maintenance operations

Object Relational Features and LOBs
[ ] Define LOBs from a DBA perspective

Oracle Universal Installer: Migration and Upgrade
[ ] List the features of the Oracle Universal Installer
[ ] Migrate an Oracle7 database to Oracle8i
[ ] Upgrade an Oracle8 database to Oracle8i

Tablespace Management
[ ] Manage locally managed tablespaces
[ ] Manage transportable tablespaces
[ ] Use read-only tablespace enhancements

Database Resource Manager
[ ] List the features of the database resource manager
[ ] Limit the use of resources using the database resource manager

Manageability Enhancements
[ ] Identify database limits
[ ] Relocate and reorganize tables
[ ] Remove unused columns from a table
[ ] Define temporary tables
[ ] Identify SQL*Loader enhancements
[ ] Monitor long-running operations
[ ] Define new constraints features
[ ] Define new Export/Import features

Availability and Recoverability Enhancements
[ ] Learn RMAN new features
[ ] Implement duplex and multiple archive logs
[ ] Set up a standby database in sustained recovery mode
[ ] Start up a database for read operations
[ ] Suspend database I/Os
[ ] Describe the funtionality of LogMiner
[ ] Implement fast-start fault recovery
[ ] Manage corrupt block detection and repair
[ ] Describe the new possibility of dynamically changing the number of free lists

Features of NET8
[ ] Describe the new service naming scheme
[ ] Explain automatic registration
[ ] Describe load balancing
[ ] Configure the network for JServer

SQL*Plus, PL/SQL, and National Language Support Enhancements
[ ] Use SQL*Plus for database management
[ ] Describe the use of PL/SQL for: Event Triggers, Autonomous Transactions, Native Dynamic SQL

Database Security
[ ] Describe N-Tier authentication
[ ] Describe invoker’s rights security management
[ ] Implement application context areas
[ ] Implement fine-grained access control

Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.

Recommended Training about 1z0-020 exam PDF
The following courses are the recommended training for 1z0-020 exam PDF.
1z0-020 Q & A with Explanations
1z0-020 Audio Exam
1z0-020 Study Guide
1z0-020 Preparation Lab
1z0-020 Exam: Freetestking’s oracle8l:new features for administrators PDF
The oracle8l:new features for administrators PDF for preparing for the 1z0-020 exam – Freetestking’s oracle8l:new features for administrators. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.

Question: 1
Which two statements are true? (Choose two)

A. Dimensions are based on summaries.
B. The ALTER MATERIALIZED VIEW CONSIDER FRESH statement directs Oracle to consider the materialized view fresh, and therefore eligible for query rewrite in the TRUSTED or STALE_TOLERATED mode only.
C. Summaries without dimensions are used for faster aggregation.
D. Additional query rewrites at a higher level of aggregation can take place if summaries are created at the lowest level of aggregation.
Answer: A, D Question: 2
Which two statements are true? (Choose two)

A. Composite partitioning supports local indexes.
B. Composite partitioning supports hash-partitioned global indexes. C. Composite partitioning supports range-partitioned global indexes
D. Composite partitioning supports composite-partitioned global indexes.
Answer: B, D Question: 3
Which tool, integrated with Oracle universal installer, can be used by third-party vendors to install their products as art of an Oracle installation?

A. Oracle Software Packager.
B. Java Run-Time environment. C. Database migration assistant. D. Optimal flexible architecture.
Answer: A Question: 4
Which two options are valid for LOBs during their creation? (Choose two)

A. REDO
B. NOREDO C. LOGGING
D. NOLOGGING
E. RECOVERABLE
F. UNRECEOVERABLE
Answer: C, D Question: 5
You set the PARALLEL_AUTOMATIC_TUNING initialization parameter to FALSE. What happens? (Choose two)

A. Parallel execution buffers are allocated from the large pool.
B. Parallel execution buffers are allocated from the shared pool.
C. Only tables with a degree of parallelism specified will be scanned in parallel.
D. A load balancing algorithm will be used to distribute evenly load across nodes in a multi instance PQ environment.

TK

Exam Name: Oracle 8i: New Features For Administrators
Exam Type: Oracle
Exam Code: 1Z0-020 Total Questions: 82

Answer: B, C

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

A. LOG_ARCHIVE_DEST
B. LOG_ARCHIVE_DEST_2
C. LOG_ARCHIVE_REMOTE_DEST D. ARCHIVE_REMOTE_DEST
Answer: A Question: 7
Which two factors can influence the time taken for instance recovery? (Choose two)

A. Size of the redo log buffer.
B. Value of FAST_START_TO_TARGET C. Size of the system tablespace.
D. Value of RECOVERY_PARALLELISM
E. The number of archived redo logs that have to be read.
F. The number of tables stored in the database buffer cache at the moment of failure.
Answer: B, D Question: 8
Examine this command:

ALTER SYSTEM SET USESTORED_OUTLINE = TRUE; Which outline category will be used?
A. SYS
B. OUTLINE C. TRUE
D. DEFAULT
Answer: D Question: 9
Which tablespace stores the segment of a temporary table?

A. The default tablespace for user SYS.
B. The temporary tablespace for user SYS.
C. The default tablespace for the current user.
D. The temporary tablespace for the current user.
Answer: D Question: 10
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.

TK

Exam Name: Oracle 8i: New Features For Administrators
Exam Type: Oracle
Exam Code: 1Z0-020 Total Questions: 82

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.
Answer: E Question: 11
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.
Answer: D Question: 12
Examine this execution plan:

Execution Plan
————————————————————–
0 SELECT STATEMENT Optimizer = CHOOSE
1 0 COUNT (STOPKEY)
2 1 VIEW
3 2 SORT (ORDER BY STOPKEY)
4 3 TABLE 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;
Answer: A Question: 13
What is the maximum number of archival destinations allowed in Oracle 8i?

A. 1
B. 2
C. 3
D. 5
E. 7

TK

Exam Name: Oracle 8i: New Features For Administrators
Exam Type: Oracle
Exam Code: 1Z0-020 Total Questions: 82

Answer: D

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

PassGuide offers free demo for Certification Exams You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. Download links:http://demo.passguide.com/download

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.
Answer: C Question: 15
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
Answer: A Question: 16
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.
Answer: C Question: 17
Which type of LOBs cannot be declared as temporary?

A. CLOB B. NCLOB C. BLOB D. BFILE
Answer: D Question: 18
Which command will open a standby database in read-only mode?

A. AFTER DATABASE OPEN READ ONLY; B. STARTUP READ ONLY;
C. ALTER DA MOUNT READ ONLY; D. ALTER DATABASE READ ONLY;
Answer: A Question: 19
Which two statements about dimensions are true? (Choose two)

Interactive Testing 1z0-020 Engine Included!
83 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-020
Exam Name: oracle8l:new features for administrators

Testking 1z0-020 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-020 exam?Searching 1z0-020 Test Questions,
1z0-020 Practice Exam,1z0-020 Braindumps ? 1z0-020 practice exam covers all

the practice test objectives to pass 1z0-020 exam.

Pass your exam at first attempt with our Testking 1z0-020 study guide,1z0-020 Braindumps, As well Audio exam, Realistic

Practice Labs, and Interactive Testing Engine.

Our Testking practice test covers the information associated with each 1z0-020 exam topics in details and includes

information found in no other practice test sites on the web.

Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re

never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most

questions and answers along with explanations. Our practice test will determine you to take your 1z0-020 certification exam

and pass the official exam on your first try, guaranteed

Now guaranteed Testking 1z0-020 exam training is available in various formats to best suit your needs and learning style.

Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-020 pdf vce

format resources that will enable you to pass your 1z0-020 test with flying colors.

Comprehensive questions with complete explanations about actualtests 1z0-020 exam
download 1z0-020 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-020 exam questions updated on regular basis

Oracle 1z0-020 Transcender Torrent
Oracle 1z0-020 P4S
Oracle 1z0-020 Study Guide
Oracle 1z0-020 Exams
Oracle 1z0-020 Braindumps
Oracle 1z0-020 Pass4sure
Oracle 1z0-020 Real Exams
Oracle 1z0-020 Exam
Oracle 1z0-020 Actual Tests
Oracle 1z0-020 Pdf

1z0-020 also gives new editions of Real Exams 1z0-020 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-

710 are useful for understanding 1z0-020 exam terminologies and these brain dumps also very useful for enhancing people brain

power. These Testking Real Practice Questions 1z0-020 are prepare by highly qualified and 1z0-020 professionals. 1z0-020 Certification experts’

teams always try to give you real exam environment in these 4shared training materials links.

Question: 1
Which two statements are true? (Choose two)
A. Dimensions are based on summaries.
B. The ALTER MATERIALIZED VIEW CONSIDER FRESH statement directs Oracle to consider
the materialized view fresh, and therefore eligible for query rewrite in the TRUSTED or
STALE_TOLERATED mode only.
C. Summaries without dimensions are used for faster aggregation.
D. Additional query rewrites at a higher level of aggregation can take place if summaries are
created at the lowest level of aggregation.
Answer: A, D
Question: 2
Which two statements are true? (Choose two)
A. Composite partitioning supports local indexes.
B. Composite partitioning supports hash-partitioned global indexes.
C. Composite partitioning supports range-partitioned global indexes
D. Composite partitioning supports composite-partitioned global indexes.
Answer: B, D
Question: 3
Which tool, integrated with Oracle universal installer, can be used by third-party vendors to install
their products as art of an Oracle installation?
A. Oracle Software Packager.
B. Java Run-Time environment.
C. Database migration assistant.
D. Optimal flexible architecture.
Answer: A
Question: 4
Which two options are valid for LOBs during their creation? (Choose two)
A. REDO
B. NOREDO
C. LOGGING
D. NOLOGGING
E. RECOVERABLE
F. UNRECEOVERABLE
Answer: C, D
Question: 5
You set the PARALLEL_AUTOMATIC_TUNING initialization parameter to FALSE. What
happens? (Choose two)
A. Parallel execution buffers are allocated from the large pool.
B. Parallel execution buffers are allocated from the shared pool.
C. Only tables with a degree of parallelism specified will be scanned in parallel.
D. A load balancing algorithm will be used to distribute evenly load across nodes in a multi
instance PQ environment.
Answer: B, C
Question: 6
Which parameter would you use to set up archiving to a remote machine?
A. LOG_ARCHIVE_DEST
B. LOG_ARCHIVE_DEST_2
C. LOG_ARCHIVE_REMOTE_DEST
D. ARCHIVE_REMOTE_DEST
Answer: A
Question: 7
Which two factors can influence the time taken for instance recovery? (Choose two)
A. Size of the redo log buffer.
B. Value of FAST_START_TO_TARGET
C. Size of the system tablespace.
D. Value of RECOVERY_PARALLELISM
E. The number of archived redo logs that have to be read.
F. The number of tables stored in the database buffer cache at the moment of failure.
Answer: B, D
Question: 8
Examine this command:
ALTER SYSTEM SET USESTORED_OUTLINE = TRUE;
Which outline category will be used?
A. SYS
B. OUTLINE
C. TRUE
D. DEFAULT
Answer: D
Question: 9
Which tablespace stores the segment of a temporary table?
A. The default tablespace for user SYS.
B. The temporary tablespace for user SYS.
C. The default tablespace for the current user.
D. The temporary tablespace for the current user.
Answer: D
Question: 10
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.
Answer: E
Question: 11
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.
Answer: D
Question: 12
Examine this execution plan:
Execution Plan
————————————————————–
0 SELECT STATEMENT Optimizer = CHOOSE
1 0 COUNT (STOPKEY)
2 1 VIEW
3 2 SORT (ORDER BY STOPKEY)
4 3 TABLE 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;
Answer: A
Question: 13
What is the maximum number of archival destinations allowed in Oracle 8i?
A. 1
B. 2
C. 3
D. 5
E. 7
Answer: D
Question: 14
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.
Answer: C
Question: 15
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
Answer: A
Question: 16
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.
Answer: C
Question: 17
Which type of LOBs cannot be declared as temporary?
A. CLOB
B. NCLOB
C. BLOB
D. BFILE
Answer: D
Question: 18
Which command will open a standby database in read-only mode?
A. AFTER DATABASE OPEN READ ONLY;
B. STARTUP READ ONLY;
C. ALTER DA MOUNT READ ONLY;
D. ALTER DATABASE READ ONLY;
Answer: A

Testking 1z0-020
TK Questions&Answers(Q & As with Expert Explanations): 83 Q&A
Update: 03/11/2008

Free Down: Testking 1z0-020
Free Down: Pass4sure 1z0-020

High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.www.freepassguide.co.uk

Dowload PassGuide Practice Test Questions

• testking-oracle-oca-exams
• testking-oracle-OCP8 to OCP8i DBA Upgrade -exams
• testking-oracle-oca-exams
• testking-oracle-Linux-exams
• testking-oracle-9i Internet Application Developer-exams
• testking-oracle-9i DBA-exams
• testking-oracle-8i DBA-exams
• testking-oracle-11i-exams
• testking-oracle-11g-exams
• testking-oracle-10g OCA-exams
• testking-oracle-10g DBA-exams
• testking oracle 10g 1z0-311
• testking oracle OCA 1z0-301
• testking oracle 9i 1z0-147
• testking oracle 9i 1z0-141