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 |
| Exam Format: | Single Answer, Multiple Choice, Multiple Answer |
| Available Languages: | Japanese, English, Brazilian Portuguese, Simplified Chinese |
| Related Certifications: | Oracle Database 10g Administrator Certified Professional (OCP) |
| Passing Score: | 68% |
| Exam Price: | USD 125 - 195 |
| Certificate Validity Period: | Until Oracle 10g certification retirement |
| Real Exam Qty: | 84 |
| 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 |
|---|---|---|
| Instance Management | 12% | - Starting and Stopping Database - Initialization Parameters - Data Dictionary & Dynamic Performance Views |
| Installation & Creation | 10% | - Installing Oracle Database Software - Creating a Database with DBCA |
| Network Environment | 6% | - Connectivity & Naming Methods - Configuring the Listener |
| Data Movement | 6% | - SQL*Loader & Data Pump - Export/Import Utilities |
| Storage Structures | 12% | - Control Files & Redo Log Files - Managing Undo Data - Tablespaces & Datafiles |
| Schema Objects | 10% | - Views, Sequences & Synonyms - Managing Tables, Indexes & Constraints |
| Performance & Maintenance | 10% | - Scheduler & Automated Tasks - Automatic Database Diagnostic Monitor (ADDM) - Automatic Workload Repository (AWR) |
| Backup & Recovery | 16% | - Backup Concepts & Strategies - Complete & Incomplete Recovery - Using RMAN for Backups - Flashback Technology |
| User & Security Administration | 10% | - Privileges & Roles - Database Security Implementation - Creating & Managing Users |
| Database Architecture & ASM | 8% | - Automatic Storage Management (ASM) - Oracle Database Architecture |
Oracle database 10g:Administration I Sample Questions:
You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2:00 p.m.?
- A. Restore the entire database from the recent backup and open it.
- B. Use Flashback Table feature to revert the changes.
- C. Issue the rollback statement with system change number (SCN).
- D. Perform point-in-time recovery to 2:00 p.m.
Correct Answer: B 🗳️
Which two statements are true about simple views? (Choose two.)
- A. Views can be created as read only.
- B. Data manipulation language (DML) operations cannot be performed on views.
- C. Views are data segments like tables.
- D. Views can be created on the basis of more than one table.
Correct Answer: A,D 🗳️
You have a text file that maintains information on thousands of items. The end-user application requires the transfer of that information into a table in the database. What would you use to achieve this task? (Choose two.)
- A. Oracle Import
- B. External table
- C. SQL*Loader
- D. Oracle Text
- E. Data Pump
Correct Answer: B,C 🗳️
The application development team has developed PL/SQL procedures and functions for different purposes and calls them as and when required. The loading of individual procedures or functions into memory degrades performance with every call. Also, it causes a security problem for individual subprograms and loss of program units when the whole system is transported into a new location. Which method would you recommend to the application developers to solve this problem?
- A. referring to views instead of tables inside the subprograms
- B. using anonymous PL/SQL blocks instead of subprograms
- C. creating PL/SQL packages to include interrelated subprograms
- D. avoiding the use of cursors in the subprograms
Correct Answer: C 🗳️
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database:
REMOTE_OS_AUTHENT = TRUE
What could have been the reason to set this parameter as TRUE?
- A. to disable the administration of the operating system from a remote client
- B. to enable operating system authentication for a remote client
- C. to allow the start up and shut down of the database from a remote client
- D. to restrict the scope of administration to identical operating systems
- E. to enable the administration of the operating system from a remote client
Correct Answer: B 🗳️
Viewing page 1 out of 37 pages.
Viewing questions 1-5 out of 185 questions.
By Milo
