2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (81-90)

QUESTION 81
A single SQL*Loader input data file might contain records in a variety of formats. Click the Exhibit button and examine the data shown, in which EMP and DEPT records are intermixed (DEPT records are indicated by 1 and EMP records are indicated by 2). Which two statements can you use to load the data shown in the Exhibit into the DEPT and EMP tables? (Choose two.)

image

A.    INTO TABLE dept
WHEN recid = 1
(recid FILLER POSITION(1:1) INTEGER EXTERNAL,
deptno POSITION(3:4) INTEGER EXTERNAL,
dname POSITION(8:21) CHAR)
INTO TABLE emp
WHEN recid <> 1
(recid FILLER POSITION(1:1) INTEGER EXTERNAL,
empno POSITION(3:6) INTEGER EXTERNAL,
ename POSITION(8:17) CHAR,
deptno POSITION(19:20) INTEGER EXTERNAL)
B.    INTO TABLE emp
(empno POSITION(1:4) INTEGER EXTERNAL,
ename POSITION(6:15) CHAR)
INTO TABLE dept
(empno POSITION(17:20) INTEGER EXTERNAL,
ename POSITION(21:30) CHAR)
C.    INTO TABLE dept
WHEN recid = 1
(recid FILLER INTEGER EXTERNAL TERMINATED BY WHITESPACE, deptno
INTEGER EXTERNAL TERMINATED BY WHITESPACE,
dname CHAR TERMINATED BY WHITESPACE)
INTO TABLE emp
WHEN recid <> 1
(recid FILLER POSITION(1) INTEGER EXTERNAL
TERMINATED BY ‘ ‘,
empno INTEGER EXTERNAL TERMINATED BY ‘ ‘
ename CHAR TERMINATED BY WHITESPACE,
deptno INTEGER EXTERNAL TERMINATED BY ‘ ‘)
D.    INTO TABLE emp
(empno INTEGER EXTERNAL TERMINATED BY ” “,
ename CHAR TERMINATED BY WHITESPACE)
INTO TABLE dept
(empno INTEGER EXTERNAL TERMINATED BY ” “,
ename CHAR) TERMINATED BY WHITESPACE)

Answer: AC

QUESTION 82
Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashes and you now want to use the backups from last night. What do you need to do?

A.    You need to perform the restore and recovery operations manually, because the backup was
made manually.
B.    First you need to resynchronize the catalog with the control file, and then you can use RMAN
to recover the database.
C.    First you need to add the backup to the catalog using the CATALOG command, and then you
can use RMAN to recover the database.
D.    You can just use RMAN and recover the database, because RMAN automatically updates the
catalog with the backup information.

Answer: C

QUESTION 83
Which statement describes the function of the database writer process (DBWn)?

A.    It writes only committed data to the data files.
B.    It is created when the first user session is established.
C.    It ensures that a sufficient number of free buffers are available in the database buffer cache.
D.    It synchronizes the headers of the data files and control files with the current redo log and checkpoint numbers.

Answer: C

QUESTION 84
Which two are characteristics of user-managed backup and recovery operations? (Choose two.)

A.    Recovery is initiated using SQL*Plus.
B.    Database files are backed up using SQL commands.
C.    Database files are backed up with Recovery Manager.
D.    Database files are restored using Recovery Manager.
E.    Database files are backed up using operating system commands.

Answer: AE

QUESTION 85
As a DBA, you need to design a backup strategy that conforms to the operational and business requirements of your organization. Which two cases prompt you to include consistent backups in your backup strategy? (Choose two.)

A.    database downtime is tolerated
B.    database is in NOARCHIVELOG mode
C.    database contains only locally managed tablespaces
D.    database contains only dictionary-managed tablespaces
E.    database does not have multiplexed control files and redo log files

Answer: AB

QUESTION 86
What action can you take to reduce the recovery time in case of instance failures?

A.    use an SPFILE
B.    multiplex the control files
C.    reduce the number of data files used by the database
D.    reduce the number of redo log members in each group
E.    configure database parameters to increase the frequency of checkpoints

Answer: E

QUESTION 87
You require a Web client to be able to make an HTTP connection to an Oracle9i database server while using an application Web server as middle tier. Where would you install Oracle Net or JavaNet?

A.    on the Web client only
B.    on the database server only
C.    on the Web client as well as the database server
D.    on the application Web server (acting as a client) as well as the database server

Answer: D

QUESTION 88
Your database is in ARCHIVELOG mode and four archive destinations are defined for your database. You notice that one of the disks mapped to an archive destination has become inaccessible. You are using the RMAN BACKUP command to perform a backup of the database including archived log files. What would happen if RMAN tries to back up the archived log files from this location?

A.    The backup operation fails with an error.
B.    The backup operation waits for your intervention.
C.    The backup completes without archived log files in it.
D.    The backup completes successfully as RMAN picks up archived logs from the other archive destinations.

Answer: D

QUESTION 89
Which statement regarding the RMAN repository stored in the control file is true?

A.    The repository never gets overwritten.
B.    The repository is used to store the RMAN scripts.
C.    The repository is used to store information about only one target database.
D.    The repository can be used to store information about backups from different incarnations of the database.

Answer: C

QUESTION 90
You need to insert rows into a table named ORDERS from the source table, ORDERS_C, which you received from your client. Because the number of rows is significantly high, you decide to use Parallel Direct Load to make the insert process faster. Which two options could you use to achieve this? (Choose two.)

A.    use DIRECT hint in the INSERT statement
B.    use PARALLEL hint in the INSERT statement
C.    use PQ_DISTRIBUTE option in the INSERT statement
D.    use PARALLEL_INDEX option in the INSERT statement
E.    alter the ORDERS table to specify the PARALLEL clause before inserting the rows

Answer: BE

If you want to pass Oracle 1Z0-032 successfully, donot missing to read latest lead2pass Oracle 1Z0-032 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-032.html

         

Comments are closed.