1z0-032 Exam

- Covers the entire recommended syllabus
- Comprehensive questions and answers about 1z0-032 exam
- 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 Hiexam
- Technical support through Live Chat or Email

　
　
Exam : Oracle 1z0-032
Title : Orcacle? 9l Database:Fundamentals II


1. 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

2. 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

3. 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

4. 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

5. 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

http://www.Hiexam.com The safer.easier way to get 9i DBA Certification.