testking oracle 9i 1z0-032
Visited 1102 times, 4 so far today
Exam 1z0-032: Oracle9i Database: Fundamentals II
Exam Number: 1Z0-032
Associated Certifications: Oracle9i DBA OCP
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 120 minutes
Number of Questions: 63
Passing Score: 73%
Recommended Training and Preparation
The exam is based on Oracle9i Release 2
Oracle9i Database: Fundamentals II
Oracle9i DBA Fundamentals II Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.
Additional Information & Resources
Practice Exams
Oracle authorized practice exam from Self Test Software. 1Z0-032 Oracle9i: DBA Fundamentals II
Oracle authorized practice exam from Transcender: Cert-1Z0-032 : DBCert: 9i Database: Fundamentals II
Oracle9i DBA Certification Exam Candidate Guide
Exam Retake Policy
Sample Questions
Exam Topics
Networking Overview
[ ] Explain solutions included with Oracle9i for managing complex networks
[ ] Describe Oracle networking add-on solutions
Basic Oracle Net Architecture
[ ] Explain the key components of the Oracle Net layered architecture
[ ] Explain Oracle Net Services role in client server connections
[ ] Describe how web client connections are established through Oracle networking products
Basic Net Server-Side Configuration
[ ] Identify how the listener responds to incoming connections
[ ] Configure the listener using Oracle Net Manager
[ ] Control the listener using the Listener Control Utility (lsnrctl)
[ ] Describe Dynamic Service Registration
[ ] Configure the listener for IIOP and HTTP connections
Basic Oracle Net Services Client-Side Configuration
[ ] Describe the difference between host naming and local service name resolution
[ ] Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
[ ] Perform simple connection troubleshooting
Usage and Configuration of the Oracle Shared Server
[ ] Identify the components of the Oracle Shared Server
[ ] Describe the Oracle Shared Server architecture
[ ] Configure the Oracle Shared Server
[ ] Identify and explain usefulness of related dictionary views
Backup and Recovery Overview
[ ] Describe the basics of database backup, restore and recovery
[ ] List the types of failure that may occur in an Oracle environment
[ ] Define a backup and recovery strategy
Instance and Media Recovery Structures
[ ] Describe the Oracle processes, memory structures, and files relating to recovery
[ ] Identify the importance of checkpoints, redo log files, and archived log files
[ ] Describe ways to tune instance recovery
Configuring the Database Archiving Mode
[ ] Describe the differences between Archivelog and Noarchivelog modes
[ ] Configure a database for Archivelog mode
[ ] Enable automatic archiving
[ ] Perform manual archiving of logs
[ ] Configure multiple archive processes
[ ] Configure multiple destinations, including remote destinations
Oracle Recovery Manager Overview and Configuration
[ ] Identify the features and components of RMAN
[ ] Describe the RMAN repository and control file usage
[ ] Describe channel allocation
[ ] Describe the Media Management Library interface
[ ] Connect to RMAN without the recovery catalog
[ ] Configure the RMAN environment
User-Managed Backups
[ ] Describe user-managed backup and recovery operations
[ ] Discuss backup issues associated with read tablespaces
[ ] Perform closed database backups
[ ] Perform open database backups
[ ] Back up the control file
[ ] Perform cleanup after a failed online backup
[ ] Use the DBVERIFY utility to detect corruption
RMAN Backups
[ ] Identify types of RMAN specific backups
[ ] Use the RMAN BACKUP command to create sets
[ ] Back up the control file
[ ] Back up the archived redo log files
[ ] Use the RMAN COPY command to create image copies
User-Managed Complete Recovery
[ ] Describe media recovery
[ ] Perform recovery in Noarchivelog mode
[ ] Perform complete recovery in Archivelog mode
[ ] Restore datafiles to different locations
[ ] Relocate and recover a tablespace by using archived redo log files
[ ] Describe read-only tablespace recovery
RMAN Complete Recovery
[ ] Describe the use of RMAN for restoration and recovery
[ ] Perform recovery in Noarchivelog mode
[ ] Perform complete recovery in Archivelog mode
[ ] Restore data files to different locations
[ ] Reloate and recover a tablespace by using archived redo log files
User-Managed Incomplete Recovery
[ ] Describe the steps of incomplete recovery
[ ] Perform an incomplete database recovery
[ ] Identify the loss of current online redo log files
RMAN Incomplete Recovery
[ ] Perform an incomplete database recovery using UNTIL TIME
[ ] Perform an incomplete database recovery using UNTIL SEQUENCE
RMAN Maintenance
[ ] Perform cross checking of backups and copies
[ ] Update the repository when backups have been deleted
[ ] Change the availability status of backups and copies
[ ] Make a backup or copy exempt from the retention policy
[ ] Catalog backups made with operating system commands
Recovery Catalog Creation and Maintenance
[ ] Describe the contents of the recovery catalog
[ ] Create the recovery catalog
[ ] Maintain the recovery catalog by using RMAN commands
[ ] Use RMAN to register, resynchronize, and reset a database
[ ] Query the recovery catalog to generate reports and lists
[ ] Create, store, and run scripts
[ ] Describe methods for backing up and recovering the recovery catalog
Transporting Data Between Databases
[ ] Describe the uses of the Export and Import utilities
[ ] Describe Export and Import concepts and structures
[ ] Perform simple Export and Import operations
[ ] List guidelines for using Export and Import
Loading Data into a Database
[ ] Demonstrate usage of direct- load insert operations
[ ] Describe the usage of SQL*Loader
[ ] Perform basic SQL*Loader operations
[ ] List guidelines for using SQL*Loader and direct-load insert
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-032 exam PDF
The following courses are the recommended training for 1z0-032 exam PDF.
1z0-032 Q & A with Explanations
1z0-032 Audio Exam
1z0-032 Study Guide
1z0-032 Preparation Lab
1z0-032 Exam: Freetestking’s orcacle9l database:fundamentals ii PDF
The orcacle9l database:fundamentals ii PDF for preparing for the 1z0-032 exam – Freetestking’s orcacle9l database:fundamentals ii. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
QUESTION 1:
What criterion does Oracle9i use to determine whether a database file is an Oracle
Managed File?
A. The filename format.
B. Information stored inside a data dictionary table.
C. Information stored in the ALERT.LOG file for the corresponding instance.
D. Information stored inside the corresponding initialization parameter file for the instance.
Answer: A Explanation:
Oracle will use naming conventions when it creates the OMF files. In this naming convention,
%t represents the tablespace name, %u is a unique 8-character string, and %g stands for the redo log group number.
Incorrect Answers
B: Oracle will create a locally managed tablespaces, so information about a datafile will not
be stored inside a data dictionary table.
C: Oracle does not use ALERT.LOG file to store information about datafiles. It just keep log
of database events and database structure changes.
D: Initialization parameter file will not be used to store this information. Oracle reads this file
to set initialization parameters to start the instance. The structure of the database is stored inside control files. Oracle uses them to mount and open the database.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 2-12
Chapter 1: Oracle9i Database Administration and Management Features
QUESTION 2:
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for
the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ’safe literals only’?
A. No literal value is substituted for a shared cursor.
B. Different execution plans are generated for substituted literal values.
C. The substitution of a literal value will produce different execution plans.
D. The substitution of any literal value will produce exactly the same execution plan. Answer: D
Explanation:
Oracle9i has enhanced cursor sharing mode. It can use additional value, SIMILAR, in
TK
1Z0-032
addition to the EXACT and FORCE cursor sharing modes. When you specify SIMILAR,
Oracle only uses the execution plan if is certain that the execution plan does not have any association with the specific literal value. You can enable similar statements to share the same SQL execution plan by setting CURSOR_SHARING to either FORCE or SIMILAR.
Incorrect Answers
A: Literal value is substituted for a shared cursor. The substitution of any literal value will produce exactly the same execution plan.
B: Exactly the same execution plans will be generated for substituted literal values.
C: The substitution of any literal value will produce exactly the same execution plan.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 215-217
Chapter 4: Performance and Scalability Enhancements
Oracle 9i New Features, Robert Freeman, p. 57-59
Chapter 2: Oracle9i Architecture Changes
QUESTION 3:
The Dynamic SGA feature allows the SGA to grow and shrink dynamically according to
an ALTER SYSTEM command. This avoids the previous need of shutting down the instance in order to modify the components of the SGA, namely the buffer cache and shared pool components.
Which three statements are true for the Dynamic SGA feature? (Choose three)
A. The maximum granule size is 4 MB.
B. The minimum SGA configuration is three granules.
C. SGA memory is based on granules by SGA components.
D. The size of the SGA components is set by the SGA_MAX_SIZE parameter.
E. The size of the SGA components is limited by the setting of SGA_MAX_SIZE
parameter. Answer: B, C, E
Explanation:
The minimum SGA configuration is three granules. One is for fixed SGA, one for database buffer, one for shared pool. Oracle9i has enhanced the nature of SGA parameters; they are now dynamic. You can change the values of the shared pool and the buffer cache without restarting the database instance. The Oracle9i dynamic SGA concept enables you to take
memory from one area of the SGA and allocate it to another area as needed while the database instance is up and running. Additionally, the unit of memory allocation fr SGA is a granule in Oracle9i. Oracle9i also introduces SGA_MAX_SIZE, a new static parameter that enables the DBA to start with a smaller SGA and dynamically increase it to the maximum value specified
by SGA_MAX_SIZE. If you do not set SGA_MAX_SIZE or if you set it to a value less than initial SGA size, you cannot increase the SGA size later.
Incorrect Answers
A: The size of a granule is 4 MB if the SGA at startup is less than 128 MB; it will be 16 MB
otherwise.
D: The size of the SGA components is not set by the SGA_MAX_SIZE parameter. This
TK
1Z0-032
parameter is just maximum limit for sum of the SGA components.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 16-17
Chapter 1: Oracle9i Database Administration and Management Features
QUESTION 4:
There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations?
A. Define user profiles and set the CPU_PER_CALL limit.
B. Define a SWITCH_TIME for a plan in the Resource Manager.
C. Create a batch job that checks V$SESSION_LONGOPS; the batch job alters the session priority of the long running operations.
D. Create a user defined event in the Oracle Enterprise Manager, which monitors
V$SESSION_LONGOPS. Answer: B
Explanation:
You can define a SWITCH_TIME for a plan in the Resource Manager to reduce the impact of long running operations on other users without aborting the long running operations.
Incorrect Answers
A: You cannot do this with CPU_PER_CALL limit.
C: You don’t need to use a batch job to check V$SESSION_LONGOPS for this purpose.
D: It can be done with a SWITCH_TIME for a plan in the Resource Manager, you don’t need
to monitor V$SESSION_LONGOPS.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129
Chapter 3: Manageability Enhancements
QUESTION 5:
What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause? (Choose three)
A. Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.
B. You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.
C. Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.
D. Global indexes remain intact and available for use by data manipulation language
(DML) statements even for sessions that have not enabled the skipping of unusable
Interactive Testing 1z0-032 Engine Included!
348 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-032
Exam Name: orcacle9l database:fundamentals ii
Testking 1z0-032 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-032 exam?Searching 1z0-032 Test Questions,
1z0-032 Practice Exam,1z0-032 Braindumps ? 1z0-032 practice exam covers all the practice test objectives to pass 1z0-032 exam.
Pass your exam at first attempt with our Testking 1z0-032 study guide,1z0-032 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-032 exam topics in details and includes information found in no other practice test sites on the web.
Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most questions and answers along with explanations. Our practice test will determine you to take your 1z0-032 certification exam and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-032 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-032 pdf vce format resources that will enable you to pass your 1z0-032 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-032 exam
download 1z0-032 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-032 exam questions updated on regular basis
Oracle 1z0-032 Transcender Torrent
Oracle 1z0-032 P4S
Oracle 1z0-032 Study Guide
Oracle 1z0-032 Exams
Oracle 1z0-032 Braindumps
Oracle 1z0-032 Pass4sure
Oracle 1z0-032 Real Exams
Oracle 1z0-032 Exam
Oracle 1z0-032 Actual Tests
Oracle 1z0-032 Pdf
1z0-032 also gives new editions of Real Exams 1z0-032 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-032 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-032 are prepare by highly qualified and 1z0-032 professionals. 1z0-032 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.
QUESTION 1:
What criterion does Oracle9i use to determine whether a database file is an Oracle
Managed File?
A. The filename format.
B. Information stored inside a data dictionary table.
C. Information stored in the ALERT.LOG file for the corresponding instance.
D. Information stored inside the corresponding initialization parameter file for the
instance.
Answer: A
Explanation:
Oracle will use naming conventions when it creates the OMF files. In this naming convention,
%t represents the tablespace name, %u is a unique 8-character string, and %g stands for the
redo log group number.
Incorrect Answers
B: Oracle will create a locally managed tablespaces, so information about a datafile will not
be stored inside a data dictionary table.
C: Oracle does not use ALERT.LOG file to store information about datafiles. It just keep log
of database events and database structure changes.
D: Initialization parameter file will not be used to store this information. Oracle reads this file
to set initialization parameters to start the instance. The structure of the database is stored
inside control files. Oracle uses them to mount and open the database.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 2-12
Chapter 1: Oracle9i Database Administration and Management Features
QUESTION 2:
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for
the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors
are shared for safe literals only. What is meant by ’safe literals only’?
A. No literal value is substituted for a shared cursor.
B. Different execution plans are generated for substituted literal values.
C. The substitution of a literal value will produce different execution plans.
D. The substitution of any literal value will produce exactly the same execution plan.
Answer: D
Explanation:
Oracle9i has enhanced cursor sharing mode. It can use additional value, SIMILAR, in
addition to the EXACT and FORCE cursor sharing modes. When you specify SIMILAR,
Oracle only uses the execution plan if is certain that the execution plan does not have any
association with the specific literal value. You can enable similar statements to share the same
SQL execution plan by setting CURSOR_SHARING to either FORCE or SIMILAR.
Incorrect Answers
A: Literal value is substituted for a shared cursor. The substitution of any literal value will
produce exactly the same execution plan.
B: Exactly the same execution plans will be generated for substituted literal values.
C: The substitution of any literal value will produce exactly the same execution plan.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 215-217
Chapter 4: Performance and Scalability Enhancements
Oracle 9i New Features, Robert Freeman, p. 57-59
Chapter 2: Oracle9i Architecture Changes
QUESTION 3:
The Dynamic SGA feature allows the SGA to grow and shrink dynamically according to
an ALTER SYSTEM command. This avoids the previous need of shutting down the
instance in order to modify the components of the SGA, namely the buffer cache and
shared pool components.
Which three statements are true for the Dynamic SGA feature? (Choose three)
A. The maximum granule size is 4 MB.
B. The minimum SGA configuration is three granules.
C. SGA memory is based on granules by SGA components.
D. The size of the SGA components is set by the SGA_MAX_SIZE parameter.
E. The size of the SGA components is limited by the setting of SGA_MAX_SIZE
parameter.
Answer: B, C, E
Explanation:
The minimum SGA configuration is three granules. One is for fixed SGA, one for database
buffer, one for shared pool. Oracle9i has enhanced the nature of SGA parameters; they are
now dynamic. You can change the values of the shared pool and the buffer cache without
restarting the database instance. The Oracle9i dynamic SGA concept enables you to take
memory from one area of the SGA and allocate it to another area as needed while the database
instance is up and running. Additionally, the unit of memory allocation fr SGA is a granule in
Oracle9i. Oracle9i also introduces SGA_MAX_SIZE, a new static parameter that enables the
DBA to start with a smaller SGA and dynamically increase it to the maximum value specified
by SGA_MAX_SIZE. If you do not set SGA_MAX_SIZE or if you set it to a value less than
initial SGA size, you cannot increase the SGA size later.
Incorrect Answers
A: The size of a granule is 4 MB if the SGA at startup is less than 128 MB; it will be 16 MB
otherwise.
D: The size of the SGA components is not set by the SGA_MAX_SIZE parameter. This
parameter is just maximum limit for sum of the SGA components.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 16-17
Chapter 1: Oracle9i Database Administration and Management Features
QUESTION 4:
There is more than one way to set the server to detect and affect long running operations
automatically. What is the best choice of you want to reduce the impact of long running
operations on other users without aborting the long running operations?
A. Define user profiles and set the CPU_PER_CALL limit.
B. Define a SWITCH_TIME for a plan in the Resource Manager.
C. Create a batch job that checks V$SESSION_LONGOPS; the batch job alters the
session priority of the long running operations.
D. Create a user defined event in the Oracle Enterprise Manager, which monitors
V$SESSION_LONGOPS.
Answer: B
Testking 1z0-032
TK Questions&Answers(Q & As with Expert Explanations): 360 Q&A
Update: 14/11/2008
Free Down: Testking 1z0-032
Free Down: Pass4sure 1z0-032
Dowload PassGuide Practice Test Questions
6 Comments on “testking oracle 9i 1z0-032”