PDF Version DemoNot sure a study set is what you need? Download the free 1Z0-035 demo from Getcertkey and review a sample of the Oracle9i dba new features for Oracle7.3 and Oracle9 ocps practice questions before you spend anything — the 2026 edition is ready to try today.
Oracle 1Z0-035 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle9i DBA New Features for Oracle7.3 and Oracle9i OCPs |
| Exam Number: | 1Z0-035 |
| Available Languages: | English |
| Related Certifications: | Oracle9i Database Administrator (OCP) Oracle Database Administration Certification Track |
| Exam Format: | Multiple Choice |
| Recommended Training: | Oracle University Training Courses |
| Exam Registration: | Oracle Certification Registration |
| Sample Questions: |  |
| Exam Way: | Proctored exam (center-based testing or authorized testing provider) |
| Pre Condition: | Basic knowledge of Oracle Database administration (Oracle7.x level experience recommended) |
| Official Syllabus URL: | https://education.oracle.com |
Oracle 1Z0-035 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Oracle9i Architecture Enhancements | - Database structural changes
|
| Performance Tuning | - Instance tuning
|
| Backup and Recovery Enhancements | - Improved recovery mechanisms
|
| Networking and Security | - Oracle Net Services
|
| Installation and Configuration | - Oracle9i installation process
|
1Z0-035 Exam FAQs for 2026 Candidates
Which certification does the 1Z0-035 exam lead to?
The 1Z0-035 exam is the official Oracle exam behind the Oracle Certified Professional (OCP) - Oracle9i DBA certification, validating the skills measured by the Oracle9i dba new features for Oracle7.3 and Oracle9 ocps credential. It sits at the Professional level of the Oracle certification program. It also connects to Oracle9i Database Administrator (OCP), Oracle Database Administration Certification Track, so the knowledge you build here carries over to those tracks as well.
Are there any prerequisites for the 1Z0-035 exam?
Basic knowledge of Oracle Database administration (Oracle7.x level experience recommended) Requirements can change when Oracle revises its certification program, so confirm the current eligibility rules on the official exam page before you register.
How do I register for the 1Z0-035 exam?
You can book the Oracle9i dba new features for Oracle7.3 and Oracle9 ocps exam through the official registration channels below:
As for delivery, the exam is offered in the following format: Proctored exam (center-based testing or authorized testing provider). Choose the option that suits you best when you book your seat.
What official training is recommended for the 1Z0-035 exam?
Oracle recommends the following training resources for the Oracle9i dba new features for Oracle7.3 and Oracle9 ocps exam:
Official courses build the foundation; the 168 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.
Can I try the 1Z0-035 practice questions before I buy?
Yes. Getcertkey provides a free 1Z0-035 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Oracle revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.
What if I fail the 1Z0-035 exam, and how is my order delivered?
Every Oracle9i dba new features for Oracle7.3 and Oracle9 ocps purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.
Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.
What topics are covered in the 1Z0-035 exam?
The Oracle9i dba new features for Oracle7.3 and Oracle9 ocps exam blueprint is organized into 5 domains. The first three are:
- Performance Tuning
- Networking and Security
- Installation and Configuration
For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.
Oracle9i dba new features for Oracle7.3 and Oracle9 ocps Sample Questions:
Question 1
What statement is true about taking a database default temporary tablespace offline?
A. You cannot take a default temporary tablespace offline.
B. You must first ensure that the default temporary tablespace has the permanent tablespace characteristic.
C. The database must be quiesced before you perform this action.
D. You must ensure that all users are assigned to an alternative temporary tablespace first.
Question 2
The EMPLOYEES table is stored in the SAMPLE tablespace.
The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX tablespace.
Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace.
Which objects will be exported by this command? exp system/manager tablespaces=SAMPLE
A. the EMPLOYEES table, IPK_EMP index, and the SALES table
B. only the EMPLOYEES table and its corresponding primary key index
C. only the EMPLOYEES table
D. the EMPLOYEES table and partition P1
Question 3
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only.
What is meant by 'safe literals only'?
A. The substitution of a literal value will produce different execution plans.
B. No literal value is substituted for a shared cursor.
C. The substitution of any literal value will produce exactly the same execution plan.
D. Different execution plans are generated for substituted literal values.
Question 4
What does fine-grained access enable you to do?
A. associate policies with tables and views
B. choose the schema in which a stored PL/SQL block will execute in
C. select how external object references are resolved in queries
D. select which user's privilege map is used during execution
Question 5
Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.
What is the least disruptive recovery strategy available in Oracle9i?
A. Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
B. Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
C. Rebuild the index using the online option.
D. Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
Solutions:
| Question 1 Answer: A | Question 2 Answer: A | Question 3 Answer: C | Question 4 Answer: A | Question 5 Answer: B |
852 Customer Reviews
Quality and ValueGetCertKey Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our GetCertKey testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyGetCertKey offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.