1Z0-032 Exam Questions

You want to perform a backup of the control file by using the following command: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; In which situation would the command fail?

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

You want to insert rows into the ORDERS_HISTORY table from the ORDERS table on the last working day of every month. To accomplish this task, you execute the following command: INSE...

Using Recovery Manager (RMAN), you performed a closed database backup on Friday. The database is running in ARCHIVELOG mode. On Monday morning, you find that the media that contain...

Which two statements are true regarding the Recovery Manager (RMAN) CROSSCHECK command? (Choose two.)

You are using Recovery Manager (RMAN) to back up your database at regular intervals. On Monday morning, you realize that the data file, users.dbf, is corrupted. You need to restore...

You are performing an online backup of a data file. During the backup, the database writer is in the middle of updating a block when RMAN tries to read the same block. What would R...

Which statement is true regarding database writer process (DBWn)?

You are using Recovery Manager (RMAN) to back up your database at regular intervals. You are using recovery catalog to maintain the RMAN repository. On a Monday, while trying to ba...

You are working in an Oracle Shared Server environment. You added one more dispatcher to handle TCP requests. How would you verify that the dispatcher has been registered when the...

You are working on a database and instance failure has occurred due to a power outage. You want to bring the instance up. From what point in the redo log file does instance recover...

Which two statements regarding backup sets are true? (Choose two.)

You have set the control file autobackup to ON by using the following command in the Recovery Manager (RMAN): CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the...

The database writer (DBWn) uses the checkpoint queue to identify blocks while writing data from the database buffer cache to data files. What type of information is stored in each...

You are using operating system tools or utilities to back up your production database. Your organization decides to use Recovery Manager (RMAN) to back up the database starting fro...

Your database is configured for shared server. A particular client requires a dedicated server. Select two actions that you can perform to configure the client to use a dedicated s...

You receive the following error while connecting to an Oracle9i database instance: ORA-12523 TNS:listener could not find instance appropriate for the client connection Which action...

You work on a database that is used for application development and operates in ARCHIVELOG mode. As a DBA, you know that database downtime can be tolerated and have designed a back...

In your Oracle9i database, INSTANCE_NAME and SERVICE_NAMES parameters are set. Which statement is correct regarding the service registration with the default local listener?

You need to change your test database from NOARCHIVELOG mode to ARCHIVELOG mode. In the process you execute the ALTER DATABASE command to change the database to ARCHIVELOG mode. Wh...

You have configured the Oracle Shared Server. Which initialization parameter would you configure so that the shared pool is not used for the shared server-related User Global Area...

While using Oracle Import utility to import the ORDERS table, the CREATE TABLE command in the export dump file fails because the structure of the table already exists. What should...

Which option must you specify in the sqlnet.ora file on the client machines to enable clients to use the host naming method?

SQL*Loader is a utility that can perform which two tasks? (Choose two.)

Which two statements are true regarding Recovery Manager (RMAN) recovery? (Choose two.)

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

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

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

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

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

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

Your database is in ARCHIVELOG mode and four archive destinations are defined for your Oracle 1Z0-032 Exam database. You notice that one of the disks mapped to an archive destinati...

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

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

You are archiving to four destinations as shown below: LOG_ARCHIVE_DEST_1 = 'LOCATION = /DB01/u01/archive' MANDATORY LOG_ARCHIVE_DEST_2 = 'LOCATION = /DB01/u02/archive' LOG_ARCHIVE...

Which three statements are correct regarding the listener process? (Choose three.)

Which statement correctly describes RMAN backup and recovery?

Because your business requirements do not permit you to shut down the database to perform backups, you decide to perform online backups. You use the ALTER TABLESPACE .. BEGIN BACKU...

You are using RMAN for the backup and recovery of your database. You want the control file to be backed up and have configured control file autobackup to ON by using the CONFIGURE...

You are using Recovery Manager (RMAN) to back up your database at regular intervals. On Monday morning, you find that the media that has the users.dbf data file is corrupted. You u...

Because of some data loss, you have to perform a Time-Based incomplete recovery of your test database. After applying the required archived redo log files, what is the next step th...

Your database has 10 tablespaces. A few days ago, one of the tablespaces was made read only. In case of a media failure necessitating a tablespace recovery, which type of tablespac...

You plan to perform a backup of the control file in your database. Which two statements regarding the control file backup are true? (Choose two.)

You have joined an organization as a DBA. While examining one of the databases you notice the Oracle 1Z0-032 Exam following settings: LOG_ARCHIVE_START = FALSE LOG_ARCHIVE_MAX_PROC...

You require a backup of a database that operates in NOARCHIVELOG mode. You performed a backup of the entire set of data files and control files, but excluded online redo log files...

When starting up the test database, you encounter the following error after mounting the database: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online l...

You are working on the PDDB database. You find that a tablespace is full, so you add a data file Oracle 1Z0-032 Exam to the tablespace. You are using RMAN to perform backup and rec...

You observe that your senior database administrator is executing the following command, using Recovery Manager (RMAN), to perform an incomplete database recovery of the database at...

You need to change the name of a net service name without changing any domains. Which net configuration file would you edit?

You want to maintain the logical backup of all the application tables at regular intervals. Which option would you use to achieve this?