Examsoon 1z0-032 PDF.pdf

Loading ...
Global Do...
News & Politics
1z0-032 9i DBA Braindump 
ExamSoon 1z0-032 Exams
Oracle orcacle9l database:fundamentals ii
 
O rder : 1z0-032 Exam
Practice Exam: 1z0-032
Exam Number/Code: 1z0-032
Exam Name: orcacle9l database:fundamentals ii
Questions and Answers: 100 Q&As 
Free 1z0-032 Braindumps
  
  
Exam : Oracle 1z0-032
Title : Orcacle? 9l Database:Fundamentals II
1. You work on a database that is used for application development and operates in NOARCHIVELOG mode. The 
database has 10 tablespaces out of which two are read only. As a DBA, you know that database downtime can be 
tolerated and have designed a backup strategy containing a weekly closed database backup.
Which files can you exclude from the weekly user-managed backup? (Choose all that apply.)
A.control files
B.sqlnet.ora file
C.tnsnames.ora file
D.data files associated with read-only tablespaces
E.data files associated with read/write tablespaces
Answer: BCD
2. Which user-managed backup performed on your database can be labeled as consistent?
A.a backup performed when the database is open
B.a backup performed on a tablespace after putting the tablespace into backup mode
C.a backup performed when the database is closed by using the SHUTDOWN ABORT command
D.a backup performed when all data files and control files are checkpointed with respect to the same system change 
number (SCN)
Answer: D
3. Which two statements regarding backup sets are true? (Choose two.)
A.A backup set may contain both data files and control files.
B.Each file in a backup set must have the same Oracle block size.
C.A backup set may contain both data files and archived redo log files.
D.A backup set may contain both a control file and archived redo log files.
Answer: AB
4. Last Friday, you performed a closed database backup of your database that is running in NOARCHIVELOG mode. 
On Monday morning, you discover that the media that contains one of the data files is corrupted. Now, you need to 
recover your database.
Which two tasks would you perform before you start recovering the database? (Choose two.)
A.restore all data files
 
 

 
 
B.restore password files
C.restore the control files
D.restore the redo log files
E.restore the parameter file
F.restore the server parameter file
G.restore the corrupted data file only
Answer: AC
5. You have set the control file autobackup to ON by using the following command in the Recovery Manager (RMAN):
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Which two events would cause the control file to be backed up automatically? (Choose two.)
A.when a tablespace is added
B.when the database instance is restarted
C.when a successful backup is recorded in the RMAN repository
D.when the RMAN connection is disconnected from the target database
Answer: AC
6. You want to perform a backup of the control file by using the following command:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
In which situation would the command fail?
A.The database is in the MOUNT state.
B.The database is in the NOMOUNT state.
C.The database has multiplexed control files
D.The database is opened and is in read-only mode. 
Answer: B
7. You work on a database that is used for application development and operates in ARCHIVELOG mode. As a DBA, 
you know that database downtime can be tolerated and have designed a backup strategy containing a weekly closed 
database backup. The local naming method is used by clients to connect to the database.
Which files should you include in this weekly user-managed backup? (Choose all that apply.) 
A.control file
B.sqlnet.ora file
C.archived log files
D.tnsnames.ora file
E.listener configuration file
Answer: AC
8. While starting up the database on a Monday morning, you get the following error after the database is mounted:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file 
ORA-01110: data file 9: '/u01/oracle/app/oradata/orcl/users01.dbf' 
While investigating, you realize that a backup of the data file (users01.dbf) exists. Which data dictionary view would 
you use to locate the archived redo log files that are required for recovery?
A.V$ARCHIVED_LOG
B.V$RECOVERY_LOG
C.V$RECOVER_FILE
D.V$RECOVERY_STATUS
Answer: B
9. When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file 
autobackup in which three situations? (Choose three.)
A.at the end of every RUN block
B.after every SET CONTROLFILE AUTOBACKUP FORMAT command
C.after every BACKUP or COPY command issued at the RMAN prompt
D.at the end of every RUN block if the last command in the block was either BACKUP or COPY
 
 
 

 
 
E.whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP 
nor COPY
F.after every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE 
AUTOBACKUP FORMAT command
Answer: CDE
10. You started your database at 7:30 a.m. and you backed up three copies of all existing archived log files to tape at 
9:00 a.m. At 10:30 a.m., you executed the following command:
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 4;
At 1:00 p.m., you executed the following commands:
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> BACKUP DEVICE TYPE sbt COPIES 2 ARCHIVELOG ALL;
Other RMAN configuration parameters are set to their default values. Which statement is correct?
A.RMAN would back up the logs which do not have four copies until 1:00 p.m.
B.RMAN would back up all logs that were created between 7:30 a.m. and 1:00 p.m.
C.RMAN would back up all logs that were created between 10:30 a.m. and 1:00 p.m.
D.RMAN would back up all logs that were not backed up, with two copies for logs created before 1:00 p.m.
Answer: D
11. Which backups can be performed without shutting down the instance? (Choose all that apply.)
A.an image copy backup
B.a backup of the database running in NOARCHIVELOG mode
C.a backup of dictionary-managed tablespace if the database is in ARCHIVELOG mode. 
D.a backup of the database when all read/write datafiles and control files are checkpointed with respect to the same 
system change number (SCN).
Answer: AC
12. You plan to perform a backup of the control file in your database. Which two statements regarding the control file 
backup are true? (Choose two.)
A.You can back up the control file to a binary file.
B.You must bring the database to the NOMOUNT state to perform the control file backup.
C.You must store all types of control file backups in the location defined by USER_DUMP_DEST.
D.You can back up the control file by generating a script that can be used to re-create the control file. 
Answer: AD
13. Which three features are provided by Oracle Net Services? (Choose three.)
A.data encryption
B.user authentication
C.transparent data conversion
D.configuration and administration mechanisms
E.support for multiple network transport protocols
Answer: CDE
14. You are using Recovery Manager (RMAN) to maintain daily backups of your database, which is running in 
ARCHIVELOG mode. In which two scenarios would you perform an incomplete database recovery using UNTIL TIME 
from the backups that you maintain using RMAN? (Choose two.)
A.when a table is dropped
B.when a table is truncated
C.when the SYSTEM tablespace is corrupted
D.when the data block in a nonsystem tablespace is corrupted
E.when a data file that belongs to a nonsystem tablespace is corrupted
Answer: AB
15. SQL*Loader is a utility that can perform which two tasks? (Choose two.)
 
 
 

 
A.load data from a disk, tape, or named pipes
B.load data into an Oracle database using DML statements
C.extract, reorganize, and insert data within an Oracle database
D.load data from external files into tables in an Oracle database
E.load data into an Oracle database using operating system commands
F.load data directly from a non-Oracle database to an Oracle database 
Answer: AD
16. Which option must you specify in the sqlnet.ora file on the client machines to enable clients to use the host 
naming method?
A.names.addresses
B.names.default_domain
C.names.directory_path
D.names.preferred_servers
E.sqlnet.authentication_services
Answer: C
17. Because your business requirements do not permit you to shut down the database to perform backups, you 
decide to perform online backups. You use the ALTER TABLESPACE .. BEGIN BACKUP command to perform the 
backups. The command returns the following error:
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled 
What could be the reason for this error?
A.The database is in the MOUNT state.
B.The database is in NOARCHIVELOG mode.
C.The command was executed on the SYSTEM tablespace.
D.The command was executed on a temporary tablespace.
E.The command was executed on a read-only tablespace. 
Answer: B
18. In which scenario would you open the database with the RESETLOGS option after recovering the database in 
NOARCHIVELOG mode?
A.when the control file is corrupted
B.when the SYSTEM data file is corrupted
C.when a nonsystem data file is corrupted
D.when the redo log files were not backed up
E.when there are no backups available to be restored
Answer: D
19. You are using RMAN to perform a backup of your database. Which statement is true regarding image copy 
backups?
A.Image copy backups cannot be parallelized.
B.An image copy can be written only to tape.
C.An image copy backup is performed by using the RMAN BACKUP command.
D.During an image copy backup, blocks are checked to make sure that they are not corrupted.
Answer: D
20. Your database contains 10 tablespaces and is functioning in NOARCHIVELOG mode. You want to use Recovery 
Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being 
accessed by users? (Choose two.)
A.backup of offline tablespaces
B.backup of read-only tablespaces 
C.backup of system-critical tablespaces 
D.backup of online, locally managed tablespaces
 
  
 
 

 
  
 
 
E.backup of read/write, dictionary-managed tablespaces 
Answer: AB
More 1z0-032 Braindumps Information 
Exam Description
1. ExamSoon offer free update service for three month.
After you purchase our product, we will offer free update in time for three month. 
2. High quality and Value for the 1z0-032 Exam. 
ExamSoon Practice Exams for 1z0-032 are written to the highest standards of technical accuracy, provided by our 
certified subject matter experts and published authors for development.
3. 100% Guarantee to Pass Your 9i DBA exam and get your 9i DBA Certification.
We guarantee your success in the first attempt. If you do not pass the 9i DBA "1z0-032" (orcacle9l 
database:fundamentals ii on your first attempt, send us the official result. We will give you a FULLY REFUND of your 
purchasing fee and send you another same value product for free.
4. ExamSoon 9i DBA 1z0-032 Exam Downloadable. 
Our PDF or Testing Engine Preparation Material of 9i DBA 1z0-032 exam provides everything which you need to pass 
your exam. The 9i DBA Certification details are researched and produced by our Professional Certification Experts 
who are constantly using industry experience to produce precise, and logical. You may get "1z0-032 exam" questions 
from different websites or books, but logic is the key. Our Product will help you not only pass in the first orcacle9l 
database:fundamentals ii( 9i DBA ) exam try, but also save your valuable time.
Comprehensive questions with complete details about 1z0-032 exam.  
1z0-032 exam questions accompanied by exhibits. Verified Answers Researched by Industry Experts and almost 
100% correct. 
Drag and Drop questions as experienced in the Real 9i DBA exam. 1z0-032 exam questions updated on regular 
basis. 
Like actual 9i DBA Certification exams, 1z0-032 exam preparation is in multiple-choice questions (MCQs). Tested by 
many real 9i DBA exams before publishing. 
Try free 9i DBA exam demo before you decide to buy it in http://www.ExamSoon.com 
High quality and Valued for the 1z0-032 Exam: 100% Guarantee to Pass Your 1z0-032 exam and get your 9i DBA 
Certification. Come to http://www.ExamSoon.com The easiest and quickest way to get your 9i DBA Certification.
ExamSoon professional provides 9i DBA 1z0-032 the newest Q&A, completely covers 1z0-032 test original topic. 
With our completed 9i DBA resources, you will minimize your 9i DBA cost and be ready to pass your 1z0-032 test on 
Your First Try, 100% Money Back Guarantee included! 
1z0-032 Exam Study Guide 
1z0-032 exam is regarded as one of the most favourite 9i DBA Certifications. Many IT professionals prefer to add 
1z0-032 exam among their credentials. ExamSoon not only caters you all the information regarding the 1z0-032 exam 
but also provides you the excellent 1z0-032 study guide which makes the certification exam easy for you. 
ExamSoon Engine Features
Comprehensive questions and answers about 1z0-032 exam  
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 
Same type as the certification exams, 1z0-032 exam preparation is in multiple-choice questions (MCQs). 
Tested by multiple times before publishing
Try free 1z0-032 exam demo before you decide to buy it in ExamSoon.com 
ExamSoon Help You Pass Any IT Exam
ExamSoon.com offers incredib le career enhancing opportunities. We are a team of IT professionals that focus on providing 
our customers with the most up to date material for any IT certification exam. This material is so effective that we Guarantee 
you will pass the exam or your money back.
1z0-007  Introduction to Oracle9i: SQL  
1z0-032  orcacle9l database:fundamentals ii  
1z0-031  orcacle9i database:fundamentals i  
1z0-033  Oracle9i Database:Performance Tuning  
1z0-030  orcacle9i database:new features for administrators  
1z0-035  orcacle9i dba new features for oracle7.3 and oracle9 ocps  
Related 1z0-032 Exams
Other Oracle Exams
1z0-402 
1z0-050 
1z0-007 
1z0-204 
1z0-031 
1z0-311 
1Z0-055 
1z0-036 
1z0-221 
1z0-264 
1z0-226 
1z0-033 
1z0-209 
1Z0-041 
1z0-257 
1z0-046 
1z0-140 
1Z1-241 
1z0-271 
1z0-236