|Exam Name||:||Oracle Database 10g New Features for Administrators|
|Questions and Answers||:||200 Q & A|
|Updated On||:||November 21, 2017|
|PDF Download Mirror||:||[1Z0-040 Download Mirror]|
|Get Full Version||:||Pass4sure 1Z0-040 Full Version|
Which statement correctly describes setup of a server-persistent parameter file (SPFILE) when used with Real Application Clusters?
One SPFILE, created from a text parameter file (PFILE), is required for each instance
You must create a separate text parameter file (PFILE) for each instance and merge them with the CREATIVE SPFILE FROM PFILE= ( list of files); command to create one common SPFILE
You can add the instance-specific parameters to a common SPFILE with the ALTER SYSTEM
?SCOPE=SPFILE SID=name ; command.
One common SPFILE is required for all instances; it has a parameter INSTANCE_name_SPFILE, which in turn points to the instance-specific SPFILE
All instances in the cluster database use the same SPFILE at startup. Oracle recommends, you to use one shared server parameter file (SPFILE) with instance-specific entries. For example, you assign undo tablespaces in your RAC database by specifying a different value for the UNDO_TABLESPACE parameter for each instance in your SPFILE or individual PFILEs.
REF. Oracle(r) 10g Database Oracle Clusterware and Oracle Real Application Clusters Guide, 5-7
Which command meets these two criteria? 1 Runs the backup at full speed
2 Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time.
RMAN> BACKUP AS COPY DURATION 300 MINIMIZE LOAD DATABASE;
RMAN> BACKUP AS COPY DURATION 300 MINIMIZE TIME DATABASE;
RMAN> BACKUP AS COPY DURATION 300 PARTIAL MINIMIZE LOAD DATABASE;
RMAN> BACKUP AS COPY DURATION 300 PARTIAL MINIMIZE TIME DATABASE;
By default, when a BACKUP... DURATION command runs out of time before the backup completes, RMAN reports an error. (The effect of this is that if the command is running in a RUN block, the RUN block terminates.) You can control this behavior by adding the PARTIAL option to the BACKUP... DURATION command, as in this example BACKUP DURATION 400 PARTIAL TABLESPACE users FILESPERSET 1; When PARTIAL is used, no error is reported when a backup command is interrupted due to the end of the backup window. Instead, a message showing which files could not be backed will be displayed. If the BACKUP command is part of a RUN block, then the remaining commands in the RUN block will continue to execute. When using DURATION you can run the backup with the maximum possible performance, or run as slowly as possible while still finishing within the allotted time, to minimize the performance impact of backup tasks. To extend the backup to use the full time available, use the MINIMIZE LOAD option,
REF. Oracle(r) 10g Backup and Recovery Guide, 2-40 and 2-41
Which two statements regarding the result of the query shown in the Exhibit are correct? (Choose two.)
The LAST_SCN value in the first row is NULL which means that version of the row still exists at SCN 6636300
The LAST_SCN value in the second row is NULL which means that version of the row still exists at SCN 6636300
The LAST_SCN value in the second row is NULL which means that version of the row no longer exists because it was deleted
The LAST_SCN value in the third row is 6636280 which means that version of the row exists above SCN 6636280
VERSIONS_STARTSCN or VERSIONS_STARTTIME
Starting SCN and TIMESTAMP when row took on this value. The value of NULL is returned if the row was created before the lower bound SCN or TIMESTAMP. VERSIONS_ENDSCN or VERSIONS_ENDTIME
Ending SCN and TIMESTAMP when row last contained this value. The value of NULL is returned if the value of the row is still current at the upper bound SCN ot TIMESTAMP. VERSIONS_XID - ID of the transaction that created the row in it's current state. VERSIONS_OPERATION - Operation performed by the transaction ((I)nsert, ( U)pdate or (D)elete)
REF. Metalink Note270270.1 - Flashback Version Query & Flashback Transaction Query - Oracle 10G Enhancement
A query on the sales table returned the following error Tue May 11 070540 2004 Some indexes or index [sub]partitions of table SCOTT. SALES have been marked unusable. Which statement caused this error to be returned when you issued the query?
DELETE FROM sales;
UPDATE sales SET prod_status='sold' WHERE prod_cat='pens';
ALTER TABLE sales MOVE PARTITIONsal_ql TABLESPACE EXAMPLE;
ALTER TABLE sales MOVE PARTITION sal_q1 TABLESPACE EXAMPLE UPDATE INDEXES;
The statement ALTER TABLE sales MOVE PARTITION sal_q1 TABLESPACE EXAMPLE, won't have a UPADATE INDEXES clause. By default, many table maintenance operations on partitioned tables invalidate (mark UNUSABLE) the corresponding indexes or index partitions.
You must then rebuild the entire index or, in the case of a global index, each of its partitions. The database lets you override this default behavior if you specify UPDATE INDEXES in your ALTER TABLE statement for the maintenance operation. Specifying this clause tells the database to update the index at the time it executes the maintenance operation DDL statement.
REF. Oracle(r) 10g Administrator Guide, 17-24
You set SGA parameters in your database as DB_CACHE_SIZE=24MB JAVA_POOL_SIZE=48MB SHARED_POOL_SIZE=96MB You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?
change JAVA_POOL SIZE to 68MB
change DB_CACHE_SIZE to 44MB
change SHARED_POOL_SIZE to 116MB
change JAVA_POOL_SIZE to 58MB and DB_CACHE_SIZE to 34MB
change SHARED_POOL_SIZE to 106MB and DB_CACHE_SIZE to 34MB
The SHARED_POOL_SIZE initialization parameter is a dynamic parameter that lets you specify or adjust the size of the shared pool component of the SG
A. Oracle Database
selects an appropriate default value. Starting with Oracle Database 10 g Release 1, the size of internal SGA overhead is included in the user-specified value of SHARED_POOL_SIZE. In other words, if you are not using the automatic shared memory management feature, then the amount of shared pool memory that is allocated at startup is exactly equal to the value of SHARED_POOL_SIZE initialization parameter. In manual SGA mode, this parameter must be set so that it includes the internal SGA overhead in addition to the desired value of shared pool size. REF. Oracle(r) 10g Administrator Guide, 2-31
What does the Character Set Scanner command line utility do?
reports only on any Unicode character conversions required
performs character set conversions to the new specified characterset
scans on any character set conversion required, then converts the data
checks for any character definitions that will fail conversion to the new characterset
The character set scanner (csscan) allows the users to evaluate the impact of migrating an existing database to a new character set or to check if a database contains codepoints outside the current character set (from V1.1 onwards). The tool scans the data in the database including the data dictionary and provides an analysis of the current data, highlighting data which will be converted when migrated to the new database character set or what data is incorrectly stored in the database.These findings are summarized in the database scan summary report and individual exception report.
REF. Metalink Note179843.1Availability & versioning of the Character Set Scanner
An AFTER SUSPEND system event trigger containing no exception handler is fired, and runs out of space after inserting some audit records. Which two events happen? (Choose two.)
The trigger is aborted
The trigger is recursively fired
The original operation (the one that fired the trigger) continues
The original operation (the one that fired the trigger) is aborted
Different parallel execution server processes may encounter one or more correctable errors. This may result in firing an AFTER SUSPEND trigger multiple times, in parallel. Also, if a parallel execution server process encounters a non-correctable error while another parallel execution server process is suspended, the suspended statement is immediately aborted. If the user registered a trigger on the AFTER SUSPEND system event, the user trigger is executed. A user supplied PL/SQL procedure can access the error message data using the DBMS_RESUMABLE package and the DBA_ or USER_RESUMABLE view.
REF. Oracle(r) 10g Administrator Guide, 14-9 and 14-10
Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (choose three)
The SWITCH_CONSUMMER_GROUP_FOR_SESS causes the specified session to immediately be moved into the specified resource consumer group. In effect, this statement can raise or lower priority. SWITCH_GROUP Specifies consumer group to which this session is switched if other switch criteria are met. If the group name is 'CANCEL_SQL', then the current call will be canceled when other switch criteria are met. If the group name is 'KILL_SESSION', then the session will be killed when other switch criteria are met. Default is NULL. SWITCH_TIME Specifies time (in seconds) that a session can execute before an action is taken. Default in UNLIMITED. You cannot specify both SWITCH_TIME and SWITCH_TIME_IN_CALL. SWITCH_ESTIMATE If TRUE, tells the database to use its execution time estimate to automatically switch the consumer group of an operation prior to beginning its execution. Default is FALSE. REF. Oracle(r) 10g Administrator Guide, 24-17
Which Oracle-supplied package is used by Data Pump Export and Import worker processes to load and unload metadata information?
Consider the following configuration /devices/D1 is a member of disk group dgroupA .
/devices/D2 is a member of disk group dgroupA . /devices/D3 is a member of disk group dgroupA
. You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D*'; Which task would be accomplished by the command?
The command first detaches all the member disks starting with "D" and then reattaches all of them including the new disk.
The command adds the new disk, D4 , to the disk group.
The command will be ignored because disks starting with "D" are already members of the disk group.
The command would result in an error because there is no disk by the name " /devices/D* ".
The command would result in an error because no wildcard characters can be used in the disk name.
You set SGA parameters in your database as DB_CACHE_SIZE =24 MB JAVA_POOL_SIZE
=48 MB SHARED_POOL_SIZE =96 MB You plan to upgrade to Oracle Database 10 g . You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?
change DB_CACHE_SIZE to 44 MB
change SHARED_POOL_SIZE to 106 MB and DB_CACHE_SIZE to 34 MB
change JAVA_POOL_SIZE to 58 MB and DB_CACHE_SIZE to 34 MB
change JAVA_POOL_SIZE to 68 MB
change SHARED_POOL_SIZE to 116 MB
Get Unlimited Access to all ExamCollection's PREMIUM files!
Enter Your Email Address to Receive Your 30% Off Discount Code
Please enter a correct email to Get your Discount Code
Download Free Demo of VCEExam Simulator
Experience Avanset VCE Exam Simulator for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your free trial.
2004 | 574 Pages | ISBN: 0782143555 | PDF | 9.9 MB
Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (">1Z0-040). This study guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the 'Best Study Guide' selection in CertCities Readers Choice Awards for two consecutive years, this book provides: clear and concise information on the enhancements included in Oracle 10g; practical examples and insights drawn from the authors' real-world experiences; and, leading-edge exam preparation software, including a test engine and electronic flashcards.You'll also find authoritative coverage of key exam topics, including: Installing and Configuring the Server; Loading and Unloading Data; Tuning Applications; Supporting Analytical Applications; Backing Up and Recovering Data; Automating Data Storage Management; Applying Security Policies; and, Supporting Upgrade Paths to Oracle 10g. Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.
[Fast Download] OCP: Oracle 10g New Features for Administrators Study Guide: Exam ">1Z0-040
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.Article by ArticleForge
Upgrade your OCP 9i certification to OCP 10g
November 5, 2007; 02:07 AM
uCertify, a reputed name in the field of I.T. certification exams, has released new practice test for the OCP 10g exam ">1Z0-040. The ">1Z0-040 is the only exam required for Oracle 9i DBAs to upgrade to Oracle 10g.
If you are looking for a preparation tool that can really help you prepare for the exam, uCertify PrepKit is the right choice for you. The PrepKit includes 4 full-length realistic practice tests, which covers all the topics for the Oracle 10g: New features for Admin exam. The PrepKit simulate actual exams to test your preparedness.
The PrepKit consists of 261 questions, including 111 quiz questions, study notes, articles, exam tips, etc. A comprehensive analysis of all the correct as well as incorrect answer options is given with further study notes and references. The PrepKit support both Learn modes and Test modes. Learn mode enables you to review the answer immediately after attempting the question, and test mode enables you to put yourself under real examination conditions.
The ">1Z0-040 PrepKit contains reports and analysis tools, which inform you about your strengths and weaknesses in a particular test. The performance reports keep track of your progress over time and suggest proper course of action.
Mark Smith, Director of Product Management, said, " The ">1Z0-040 Oracle Database 10g: New Features For Administrators is an upgrade exam to the Oracle 9i DBA. This test is popularly referred to as the '10g Upgrade Test.' Passing it upgrades your Oracle 9i Certified Professional status to be current for Oracle 10g. Those certified at the Professional level can upgrade their credential by passing an upgrade exam, or by passing the exams 1Z0-042 and 1Z0-043.
He further added, "Our exam simulation software not only help you pass the exam with a good score but also provide you knowledge to become an expert in the related field. While authoring the test questions, we also take into account the needs of the candidates who are new in the field of I.T. certifications so that they can understand the questions and their solutions easily. So try our product and if you could not pass the exam in first attempt we will provide 100% money back."
Founded in 1996, uCertify is a leading developer of exam preparation solutions for Oracle certification exams. The continuously growing range of uCertify products includes Exam Simulation PrepKits for OCP DBA9i, OCA DBA9i PLSQL, OCA DBA10g, OCP DBA10g, and other significant certifications and exams. For more information about uCertify, please
1684 Decoto Road, Suite 152 Union City, CA - 94587 USA, 1-800-796-3062, ucertify_pryahoom,
Article by ArticleForge
Guest Post from Matthew Morris of the Oracle Certification Prep blog.
I was recently asked to submit a guest post for this blog about the pros and cons of the two new OCA to OCP certifications currently undergoing beta testing. Since I have been following those exams from before they were officially announced, I was happy to do so. In May, I speculated on my own blog about the possibility of a cross-version OCA-to-OCP exam following a teaser comment that was made in the LinkedIn OCP group. When the exams were announced in late June, I wrote about my first impressions of the announcement and what the new tracks meant for OCAs certified in older releases. In the months since that post, I have researched both exams and have a reasonably detailed picture of the subject matter being tested in each.
Before I start making comparisons, it is necessary to define exactly what the alternative to these exams would be. There is often more than one potential upgrade path between database releases. The grid below contains what I consider to be the most likely paths that Oracle Certified Associates in 9i, 10g and 11g would take to become 11g or 12c Oracle Certified Professionals.
11gOCP 12c OCP 9i OCA 1Z0-052, 1Z0-053 1Z0-062, 1Z0-063 10g OCA 1Z0-043, 1Z0-050 1Z0-043, 1Z0-060 11g OCA NA 1Z0-053, 1Z0-060
On the Positive side…
As the grid shows, the traditional cross-release upgrade paths all require two exams. Most of the advantages of taking either 1Z0-034 or 1Z0-067 stem from consolidation to a single exam. The benefits from upgrading via the 034067 exams include:
On the Negative Side…
There is no such thing as a free lunch. These exams can help OCAs in older releases to upgrade for a lower cost, but there is still a price to be paid.
Both 1Z0-034 and 1Z0-067 borrow heavily from earlier tests offered by Oracle. For 1Z0-034, the test developers from Oracle Certification cherry-picked topics from the 10g Admin II (1Z0-043) and New Features (">1Z0-040) exams, along with the 11g Admin I (1Z0-052), Admin II (1Z0-053), and New Features (1Z0-050) exams. 1Z0-067 contains most of those same topics, plus a number from the 12c administration exams (1Z0-060, 1Z0-062, and 1Z0-063), and several topics that are brand new. The end result is that both exams present a very comprehensive set of topics to certification candidates. Additional information about the two exams can be located at the following links:
1Z1-034: Upgrade Oracle9i10g OCA to Oracle Database 11g OCP
1Z1-067: Upgrade Oracle9i10g11g OCA to Oracle Database 12c OCP
Numerous times I have seen posts on various forums by Oracle Certified Associates specifically requesting exams that would allow a cross-release upgrade to OCP. The Oracle Certification program listened and has responded. So long as certification candidates make use of these new paths with eyes wide open, the exams have the potential to provide a faster, cheaper route to enhancing their Oracle credentials.