Oracle 1Z0-035 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| SQL, PL/SQL & Development | 15% | - PL/SQL enhancements - SQL syntax and performance improvements - XML and Java integration |
| Oracle9i Server Architecture & Manageability | 20% | - Enhanced memory management - Self-managing database features - Oracle Enterprise Manager improvements |
| Security Enhancements | 15% | - Fine-grained access control - Data encryption and label security - PKI and advanced authentication |
| Internet, Business Intelligence & Networking | 15% | - Internet-ready database features - Data warehouse and BI optimizations - Oracle Net Services improvements |
| Performance & Scalability | 20% | - Partitioning and query optimization - Cursor sharing enhancements - Real Application Clusters (RAC) and Cache Fusion |
| Backup & Recovery | 15% | - Enhanced disaster recovery - Flashback and point-in-time recovery improvements - Recovery Manager (RMAN) new capabilities |
Oracle9i dba new features for Oracle7.3 and Oracle9 ocps Sample Questions:
Question 1
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback? (Choose two.)
A. You can only use an Oracle Flashback view of the data if the required records are still in the online redo log files.
B. Oracle Flashback uses undo information to construct consistent data.
C. You can use a PL/SQL cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.
D. Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
Question 2
An index-organized table (IOT) called SPARSE has had many records deleted.
Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?
A. EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
B. ALTER INDEX REBUILD ONLINE ;
C. ALTER TABLE COALESCE ;
D. CREATE TABLE AS SELECT ONLINE;
Question 3
Which CREATE TABLE parameter should you be concerned with if the length of rows in an index-organized table vary over a wide range of values?
A. PCTTHRESHOLD
B. PCTINCREASE
C. PCTUSED
D. PCTFREE
Question 4
Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method_opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?
A. The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
B. The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
C. The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema.
D. The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
Question 5
Which statement is true when using the DBVERIFY utility to detect corruptions in an Oracle data block?
A. The utility can be used to verify redo-log files for corruption.
B. The utility can be used with the database shut down.
C. The utility is useful only when the database is in ARCHIVELOG mode.
D. The utility can cause contention in the shared pool when there is high activity in the database.
Solutions:
| Question 1 Answer: B,C | Question 2 Answer: C | Question 3 Answer: A | Question 4 Answer: C | Question 5 Answer: B |
918 Customer Reviews
Quality and ValueITCertKing 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 ITCertKing 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 BuyITCertKing 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.
