2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (21-30)
In your database server, you discovered that a data file that belongs to one of the users tablespaces is corrupted and, therefore, requires a recovery. To perform the recovery, which are the files that you may need to restore from the recent backup? (Choose all that apply.)
A. control file
B. parameter file
C. archivelog files
D. non-corrupted version of the data file
E. all the archivelog files since the database was created
You executed the following RMAN script to perform a backup:
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP DATAFILE 5,6,7;
Which statement regarding channel allocation is true?
A. Only one channel is active at any one time to perform a backup.
B. This type of channel allocation works only if the disk is used as a backup device.
C. This channel allocation works only if there are no automatic channels configured.
D. The three channels are concurrently active; each channel performs a backup of one data file.
In your test database, users complain that they are getting the following error while executing a query on the ORDERS table:
ERROR at line 1:
ORA-00942: table or view does not exist
While investigating the reason, you find that the table has been dropped accidentally. You do not have any logical backup of the ORDERS table, but you performed a closed database backup two days back and your database is running in ARCHIVELOG mode. Which type of recovery would you perform to recover the ORDERS table?
A. Open Database complete recovery
B. Closed Database complete recovery
C. Time-Based incomplete database recovery
D. Database recovery using backup control file
You have joined an organization as a DBA. While examining one of the databases you notice the following settings:
LOG_ARCHIVE_START = FALSE
LOG_ARCHIVE_MAX_PROCESS = 4
What do you understand from this settings?
A. Manual archiving is enabled and no archiver processes are started.
B. Archiving is not enabled, so the database is in NOARCHIVELOG mode.
C. Automatic archiving is enabled and four archiver processes will be started on demand.
D. Manual archiving is enabled and four archiver processes will be started for manual archiving.
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
Which two statements are correct regarding the listener process? (Choose two.)
A. Multiple listeners can listen on behalf of a single database.
B. The name of the listener should be unique per listener.ora file.
C. A listener can listen for a single database only and not multiple databases.
D. A listener can be configured to listen for a single protocol only and not multiple protocols.
E. The listener transfers the connection request to the Connection Manager in a Shared Server configuration.
Your database operates in NOARCHIVELOG mode. You performed the following steps to change the database to ARCHIVELOG mode:
A) Shut down the database.
B) Start the database in MOUNT state.
C) Set the database in ARCHIVELOG mode by using the ALTER DATABASE command.
D) Open the database.
What should you do after the database is open?
A. take a full backup of the database
B. manually perform log switch to initiate archiving
C. manually force a checkpoint to initiate archiving
D. restart the database so that changes take effect
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
Your database is operational and is in NOARCHIVELOG mode. You decided to start your database in ARCHIVELOG mode. Why would you do this?
A. You want to rename redo log files.
B. You want to add a new redo log group.
C. You do not want to maintain redo history.
D. You want to back up the database while it is online.
E. You want the database to reuse the redo log files immediately after a checkpoint takes place.
In your database, you executed an INSERT statement on the PRDTB table to insert a record. The tablespace does not have sufficient free space and resumable space allocation feature is not enabled. What would happen in this case?
A. The user session executing the INSERT statement gets terminated.
B. The INSERT statement fails and the statement is rolled back automatically.
C. The data file containing the PRDTB table segment gets corrupted and, therefore, needs recovery.
D. The least recently used (LRU) algorithm is used to get free space and a new record is inserted.
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.