PDF Version DemoOracle 1Z0-045 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 10g: New Features for Oracle8i OCPs |
| Exam Number: | 1Z0-045 |
| Real Exam Qty: | 78 |
| Passing Score: | 73% |
| Exam Duration: | 120 minutes |
| Exam Price: | US$195 |
| Exam Format: | Multiple Select, Multiple Choice |
| Available Languages: | Japanese, English |
| Related Certifications: | Oracle8i OCP Oracle Database 10g Administrator Certified Professional |
| Certificate Validity Period: | Retired / No longer valid |
| Recommended Training: | Oracle Database 10g New Features Documentation |
| Exam Registration: | Pearson VUE Oracle Registration |
| Sample Questions: | Oracle 1Z0-045 Sample Questions |
| Exam Way: | Proctored at Pearson VUE test centers; retired exam no longer available |
| Pre Condition: | Active Oracle8i OCP certification (exam 1Z0-020) |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-045 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Installation and Upgrade | 15% | - Upgrade considerations from 8i to 10g - Automatic Storage Management (ASM) introduction - New initialization parameters |
| Other New Features | 15% | - Transaction management enhancements - Data Pump Export/Import - Online redefinition improvements |
| Security and Manageability | 15% | - Regular expression support - Server-generated alerts - LogMiner improvements - Database Scheduler |
| Backup and Recovery | 20% | - Recovery through RESETLOGS - Flashback technology - Fast recovery area - RMAN enhancements |
| Performance and Diagnostics | 20% | - SQL Tuning Advisor and Access Advisor - Automatic Workload Repository (AWR) - Automatic Database Diagnostic Monitor (ADDM) - Resource Manager enhancements |
| Database Storage and Space Management | 15% | - Automatic undo management improvements - Online segment shrink - Locally managed tablespace enhancements - Bigfile tablespaces |
Oracle database 10g:new features for Oracle8i ocps Sample Questions:
Question #1
Examine this startup script called startmydb.sql:
CONNECT myid/mypwd AS SYSDBA STARTUP EXIT
In Oracle8i, you could have executed this script by invoking Server Manager with the command: svrmgrl @startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle 10g database?
A. sqlplus -Sstartmydb.sql
B. sqlplus -S @startmydb.sql
C. sqlplus @startmydb.sql
D. sqlplus /NOLOG @startmydb.sql
Question #2
Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)
A. DBMS_MONITOR package APIs
B. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
C. Enterprise Manager GUI
D. DBMS_TRACE package APIs
E. DBMS_ADVISOR package APIs
Question #3
Which three file types are managed by Data Pump jobs? (Choose three.)
A. alert files
B. error files
C. log files
D. dump files
E. SQL files
F. out files
Question #4
Identify four uses of the Oracle Scheduler. (Choose four.)
A. Enables you to set idle time limits for a resource plan.
B. Enables you to schedule job execution based on time.
C. Enables you to periodically execute operating system script files located on the same server as the database.
D. Enables you to assign priorities to the consumer groups.
E. Enables you to create a job that makes use of saved programs and schedules.
F. Enables you to map a consumer group to an Oracle user.
G. Enables you to execute jobs in a clustered environment.
Question #5
You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?
A. DBMS_MONITOR
B. DBMS_STATS
C. DBMS_ALERT
D. DBMS_SPACE
E. DBMS_SPACE_ADMIN
F. DBMS_SERVER_ALERT
Solutions:
| Question #1 Correct Answer: D | Question #2 Correct Answer: B,C,E | Question #3 Correct Answer: C,D,E | Question #4 Correct Answer: B,C,E,G | Question #5 Correct Answer: F |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
1315 Customer Reviews
Quality and ValueITbraindumps 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 ITbraindumps 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 BuyITbraindumps 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.