2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (11-20)

Under which conditions would you use a backup control file during a recovery process? (Choose all that apply.)

A.    to recover a table that was dropped
B.    to recover a schema that was dropped
C.    to recover a tablespace that was dropped
D.    to recover the rows of a table that was truncated
E.    to undo erroneous transactions performed by users

Answer: C

View the Exhibit.
You configured the local naming method as the first naming method by using Oracle Net Configuration Assistant. As a result, which network configuration file will be updated?


A.    tnsnames.ora
B.    sqlnet.ora
C.    listener.ora
D.    names.ora

Answer: B

You observe that your senior database administrator is executing the following command using Recovery Manager (RMAN) in order to perform an incomplete recovery of the database:
The current sequence number is 189 and your database is running in ARCHIVELOG mode. What could be the objective of specifying the SET UNTIL SEQUENCE option in the RUN block of RMAN?

A.    to restore and recover the database from the sequence number specified until the current sequence number
B.    to reset the current sequence number for the database, and then to start restore and recovery processes
of the database
C.    to restore the database till the sequence number specified, and then recover the database until the current
sequence number
D.    to restore the database completely from the last available backup taken prior to the sequence 134, and then
recover it until the sequence number specified

Answer: D

On March 15, due to an application enhancement you made many structural changes in the database. The recovery catalog is used with RMAN and backups are performed on the last day of every month. The CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 7 days. What do you do to ensure that metadata in the recovery catalog is updated?

A.    reset the database by using the RESET DATABASE command
B.    update the recovery catalog by using the CROSSCHECK command
C.    initiate resynchronization by using the RESYNC CATALOG command
D.    register the database again by using the REGISTER DATABASE command

Answer: C

You are working in a dedicated server environment. You require the PMON process to register with a local listener, lsnr1, which does not use TCP/IP, port 1521. The protocol address of lsnr1 is available in the listener.ora file. What would you do?

A.    configure the LOCAL_LISTENER parameter in the initialization parameter file
B.    configure the SID_LIST_LSNR1 parameter in the listener.ora file
C.    execute the lsnrctl set command with the appropriate parameter to set the correct instance names
D.    no explicit action required because the protocol address of the listener is available in the listener.ora file

Answer: A

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’
On investigation, you find that the file system, u01, on the operating system is corrupted and you need to recover the data file to a new location. The database is running in ARCHIVELOG mode and the database was backed up on last Friday. You must ensure that the database is not accessible till the data file is recovered.
Which two tasks must you have accomplished before applying the archived redo log files? (Choose two.)

A.    update the control file by using the ALTER DATABASE RENAME FILE command
B.    restore the data file from the backup to the new location by using an operating system utility
C.    restore a backup control file and then issue the ALTER DATABASE RENAME FILE command
D.    drop the data file and re-create it by using the ALTER DATABASE CREATE DATAFILE command
E.    recreate the control file by using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
and then by modifying the file name in the script before running it

Answer: AB

You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is running in ARCHIVELOG mode. On Monday morning, you find that the media that contains the users.dbf data file, which belongs to the USERS tablespace, is corrupted and users are unable to access the USERS tablespace. After investigating further, you decide to restore the data file to a new location. Which option would you use to relocate the data file before restoring the data file to the new location?

A.    use the RMAN SET NEWNAME command
B.    use the RMAN RESTORE TABLESPACE command
C.    use the Transportable Tablespace option of Oracle Export and Import utility
D.    use the ALTER DATABASE RENAME FILE command for the data file users.dbf

Answer: A

There are three databases in your company: PDDB, QTDB, and SLDB. A single RMAN recovery catalog is used for all the three databases. In the recovery catalog you have a stored script, Level0Backup, created for performing a level 0 backup. For which database will the backup be performed when you execute this script?

A.    all the three databases
B.    depends on the channel allocation
C.    the target database to which RMAN is connected
D.    the database configured using the CONFIGURE command at the command line before calling the script

Answer: C

Which statement correctly describes the checkpoint position?

A.    This is the position of the checkpoint queue in the control file.
B.    This is the position in the data file where dirty blocks are written.
C.    This is the position in the redo log file from where archiving starts.
D.    This is the position in the redo log file from where the recovery process starts.
E.    This is the position in the data file header where the Redo Byte Address (RBA) is recorded.

Answer: D

Which two statements are correct regarding the request/response queues in an Oracle Shared Server environment? (Choose two.)

A.    The request queue is placed in the PGA.
B.    Each dispatcher has its own request queue.
C.    Each dispatcher has its own response queue in the SGA.
D.    The requests in the request queue are processed on a first-in, first-out (FIFO) basis.
E.    The listener picks up a response from the response queue and returns it to the appropriate user process.

Answer: CD

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



Comments are closed.