We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-042 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | Oracle Database 10g: Administration I |
| Exam Number: | 1Z0-042 |
| Exam Duration: | 120 minutes |
| Available Languages: | English, Japanese, Brazilian Portuguese, Simplified Chinese |
| Passing Score: | 68% |
| Certificate Validity Period: | Until Oracle 10g certification retirement |
| Exam Format: | Multiple Choice, Single Answer, Multiple Answer |
| Real Exam Qty: | 84 |
| Exam Price: | USD 125 - 195 |
| Related Certifications: | Oracle Database 10g Administrator Certified Professional (OCP) |
| Recommended Training: | Oracle Database 10g: Administration I |
| Exam Registration: | Oracle Education & Certification |
| Sample Questions: | Oracle 1Z0-042 Sample Questions |
| Exam Way: | Computer-based, delivered at authorized test centers (Prometric originally, now retired) |
| Pre Condition: | Recommended: Basic SQL knowledge; Oracle Database 10g: Introduction to SQL (1Z0-007 or 1Z0-047) or equivalent experience |
| Official Syllabus URL: | http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_042 |
Oracle 1Z0-042 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Schema Objects | 10% | - Views, Sequences & Synonyms - Managing Tables, Indexes & Constraints |
| Topic 2: Installation & Creation | 10% | - Installing Oracle Database Software - Creating a Database with DBCA |
| Topic 3: User & Security Administration | 10% | - Creating & Managing Users - Database Security Implementation - Privileges & Roles |
| Topic 4: Network Environment | 6% | - Connectivity & Naming Methods - Configuring the Listener |
| Topic 5: Storage Structures | 12% | - Control Files & Redo Log Files - Tablespaces & Datafiles - Managing Undo Data |
| Topic 6: Data Movement | 6% | - Export/Import Utilities - SQL*Loader & Data Pump |
| Topic 7: Backup & Recovery | 16% | - Using RMAN for Backups - Complete & Incomplete Recovery - Backup Concepts & Strategies - Flashback Technology |
| Topic 8: Performance & Maintenance | 10% | - Scheduler & Automated Tasks - Automatic Workload Repository (AWR) - Automatic Database Diagnostic Monitor (ADDM) |
| Topic 9: Instance Management | 12% | - Initialization Parameters - Data Dictionary & Dynamic Performance Views - Starting and Stopping Database |
| Topic 10: Database Architecture & ASM | 8% | - Oracle Database Architecture - Automatic Storage Management (ASM) |
Oracle database 10g:Administration I Sample Questions:
1. Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.)
A) Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
B) You have to shut down the database to perform the backups.
C) All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
D) Archiving information is written to the data files and redo log files.
E) You can perform complete database backups without closing the database.
2. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view. After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE
Tablespace [TEST] is [28 perce 28.125 nt] full
What could be the two reasons for the elimination of the other rows in the output? (Choose two.)
A) The threshold alert conditions are cleared.
B) The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C) The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
D) The threshold alerts are transferred to DBA_ALERT_HISTORY.
3. Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)
A) Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
B) Reducing the value of the SGA_TARGET parameter takes away memory from both autotuned and manually sized components.
C) Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.
D) It can be increased up to the value of the SGA_MAX_SIZE parameter.
4. You plan to use static database registration for a new listener when you create it. What could be the two reasons for this? (Choose two.)
A) More than one database is to be registered with the listener.
B) The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
C) The database that is to be registered with the listener is configured in shared server mode.
D) The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
E) The users will connect the database by using the host naming method.
5. What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)
A) The database is closed, but the instance is still started.
B) Uncommitted changes are not rolled back.
C) The database files are synchronized.
D) The database undergoes automatic media recovery during the next startup.
E) Database buffers and redo buffers are not written to the disk.
Solutions:
| Question # 1 Answer: C,E | Question # 2 Answer: A,D | Question # 3 Answer: A,D | Question # 4 Answer: B,D | Question # 5 Answer: B,E |
By Leonard
