We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-035 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle9i DBA New Features for Oracle7.3 and Oracle9i OCP |
| Exam Number: | 1Z0-035 |
| Certificate Validity Period: | Retired |
| Available Languages: | English |
| Related Certifications: | Oracle Certified Professional (OCP) DBA |
| Exam Format: | Multiple Choice |
| Sample Questions: | Oracle 1Z0-035 Sample Questions |
| Exam Way: | Proctored exam at authorized testing center or online proctored delivery (historical format) |
| Pre Condition: | Oracle DBA certification or equivalent Oracle administration experience (commonly associated with OCP track) |
| Official Syllabus URL: | https://education.oracle.com |
Oracle 1Z0-035 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Backup, Recovery, and Data Management Enhancements | - Recovery scenarios and strategies - RMAN improvements in Oracle9i |
| Installation and Upgrade Concepts | - Database migration considerations - Upgrade paths from Oracle7.3 to Oracle9i |
| Oracle9i Architecture and New Features Overview | - New initialization parameters and configuration enhancements - Database architecture changes in Oracle9i |
| Networking and Security Enhancements | - Oracle Net Services updates - Security feature enhancements in Oracle9i |
| Performance Tuning and Optimization | - Query optimization improvements - Automatic performance features |
Oracle9i dba new features for Oracle7.3 and Oracle9 ocps Sample Questions:
Before adding a nonstandard block size to your database, which preparatory task must you complete?
- A. Redefine the buffer pool by setting the DB_mK_CACHE_SIZE and DB_nK_CACHE_SIZE parameters, where m is the standard block size and n is the new block size.
- B. Define a new buffer pool by setting the DB_nK_CACHE_SIZE parameter where n is the new block size.
- C. Rebuild the control file using an instance with an initialization file containing two DB_nK_CACHE_SIZE parameters, one for the standard and one for the new block size.
- D. Rebuild the control file using an instance with an initialization file containing two DB_BLOCK_SIZE parameters, one for the standard and one for the new block size.
Correct Answer: B 🗳️
Consider the following scenario using incremental backups. A level 1 backup is taken on the first of the month. A level 2 backup is taken every Sunday, and a level 3 backup is taken daily. If the database gets corrupted on the second Wednesday of the month and is lost, which scenario would restore the database completely?
- A. the monthly backup (level 1) and the daily backup (level 3)
- B. a base level backup (level 0) is missing and nothing can be recovered
- C. the weekly backup (level 2) and the daily backup (level 3)
- D. the monthly backup (level 1), the weekly backup (level 2) and the daily backup (level 3)
Correct Answer: B 🗳️
Which command can you use to alter the active size of the SGA dynamically, where the entered value differs from the current one?
- A. ALTER SYSTEM SET SHARED_POOL_SIZE=40M;
- B. ALTER SYSTEM SET SGA_MAX_SIZE=500M ;
- C. ALTER SYSTEM DROP DB_2K_CACHE_SIZE ;
- D. ALTER SYSTEM SET DB_CACHE_SIZE=AUTO ;
Correct Answer: A 🗳️
What is true regarding a shared, server-side parameter file for a Real Application Clusters database?
- A. It must contain an IFILE parameter for each instance's individual parameter file.
- B. It can contain only parameters with identical values for each instance.
- C. It must be located in the default location for the primary instance's parameter file.
- D. It can contain parameters with distinct values for each instance.
Correct Answer: D 🗳️
What statement is true about taking a database default temporary tablespace offline?
- A. You must ensure that all users are assigned to an alternative temporary tablespace first.
- B. The database must be quiesced before you perform this action.
- C. You must first ensure that the default temporary tablespace has the permanent tablespace characteristic.
- D. You cannot take a default temporary tablespace offline.
Correct Answer: D 🗳️
By Kevin
