2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (41-50)
Using Recovery Manager (RMAN) you backed up your database on Friday evening. On Monday morning, you added a new tablespace to the database and backed up the newly added tablespace. Then, you executed the following command:
RMAN> CROSSCHECK BACKUPSET OF DATABASE;
Which task does this command accomplish?
A. It checks for synchronization of only the backup sets and not the backup pieces.
B. It checks for synchronization of the backup set that contains the newly added tablespace.
C. It checks for synchronization of the backup set that contains the SYSTEM tablespace only.
D. It checks for synchronization of all backup sets including the backup pieces and proxy copies.
E. It checks for synchronization of the backup set excluding the set that contains the SYSTEM tablespace.
The CONTROL_FILE_RECORD_KEEP_TIME parameter is set to the default value of seven days in your database. The control file is used as the RMAN repository. But the initial size of the control file is too small to store all the RMAN information for seven days. What will happen in this scenario?
A. The database crashes, displaying an error message stating that the parameter setting be changed.
B. The control file increases in size to store RMAN information if operating system permits.
C. The temporary tablespace is used to store RMAN information until free space is available in the control file.
D. The SYSTEM tablespace is used to store RMAN information until free space is available in the control file.
You back up your database, which is running in ARCHIVELOG mode, at regular intervals. On Monday morning, you find that one of the data files is corrupted and the database administrator is recovering the file by executing the following command after restoring the file from a backup:
SQL> RECOVER AUTOMATIC datafile 8;
What is the objective of using the AUTOMATIC option with the RECOVER command?
A. to apply all required archived log files without prompting for confirmation
B. to allow the recovery process to determine the optimal thread number to recover the data file
C. to apply all required archived log files after confirmation, and then automatically open the database
D. to allow the recovery process to determine the log sequence number from where the recovery process is
On Monday night, using the Oracle Export utility you exported your application tables by using the following command:
$ exp apps/apps tables=(ORDERS, CUSTOMERS, ITEMS, INVENTORY) \\ direct=Y \\
On Tuesday morning, you observe that the CUSTOMERS table has been dropped accidentally. You try to import it by executing the following command:
$ imp apps/apps tables=(CUSTOMERS) \\
But the command errors out, displaying LRM-00101: unknown parameter name error. Which parameter must you remove for the import to be successful?
Oracle Net is responsible for establishing and maintaining the connection between the client application and the server. On the client side, Oracle Net is responsible for which three connectivity issues? (Choose three.)
A. the location of the server
B. the Oracle user being connected
C. privileges and role information
D. protocol involved in the connection
E. how to handle exceptions and interrupts
Users in your production database complain that they are not able to access the data from the CUSTOMERS table. On investigation, you find that the table is truncated and you need to import the table using the Oracle Import utility. Which option must you use to suppress the object creation error while importing the table?
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.
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?
You are using Recovery Manager (RMAN) to back up your production database at regular intervals. On Monday morning, the database administrator asks you to execute the following set of commands:
RMAN> CROSSCHECK BACKUPSET OF DATABASE;
RMAN> DELETE NOPROMPT EXPIRED BACKUP;
What could be the reason to execute these commands?
A. to identify the backups that no longer exist in a media and remove them from the RMAN repository
B. to identify obsolete backup sets, mark them as EXPIRED and then remove them from the RMAN repository
C. to identify the backups that are no longer required for a recovery and remove them from the RMAN repository
D. to identify the backups of archived redo log files that have been used to recover a data file and remove them
from the RMAN repository
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
If you want to pass Oracle 1Z0-032 successfully, donot missing to read latest lead2pass Oracle 1Z0-032 practice tests.
If you can master all lead2pass questions you will able to pass 100% guaranteed.