1Z0-043 Exam Questions

You set the value for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter to 7. Which two records in the control file of the database are circularly reused for storage becau...

You executed the following command at the command prompt: $ rman TARGET sys/oracle@ad10g CATALOG rmanusr/rmanusr@as10g SCRIPT backup_whole Which three statements are true regarding...

You have configured and registered your target database in a recovery catalog. Because the application needs it, you created a new tablespace in the target database. Then you execu...

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two.)

In which two situations would you prefer to use a hash cluster? (Choose two.)

You have decided to perform a full database export to check the consistency of a database. Which two statements are true regarding the limitations of this method in detecting datab...

Examine the RMAN commands in a backup strategy implemented in your company: Day 1 - Sunday RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE; RMAN> RECO...

You issue the following command in your database: CREATE RESTORE POINT rec_load GUARANTEE FLASHBACK DATABASE; Which two statements are true regarding the REC_LOAD guaranteed restor...

Following are the parameters and their values set in your database instance: SGA_TARGET=8GB SGA_MAX_SIZE=10GB DB_KEEP_CACHE_SIZE=1GB You executed the following command to increase...

You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough...

View the Exhibit. In your production database, the total waits and the time waited for log file parallel write are significantly high. While investigating the reason, you find that...

One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creati...

You have set some of the initialization parameters as: DB_BLOCK_SIZE = 8KB SGA_MAX_SIZE = 2GB SGA_TARGET = 0 SHARED_POOL_SIZE = 120MB DB_CACHE_SIZE = 896MB STREAM_POOL_SIZE = 0 LAR...

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What wou...

View the Exhibit. You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up? (Choose t...

In which two conditions are resumable statements suspended? (Choose two.)

You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To...

You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this comman...

Identify four uses of the Oracle Scheduler. (Choose four.)

Your business has departmental reports that are generated every day. Each department must use the same set of queries, but access a different subset of data in the tables, dependin...

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indica...

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involv...

A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem...

You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE...

You work as a database administrator at certkiller.com. In your test database, you find that a user's session is executing a lot of SQL statements, resulting in the generation of a...

You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being sus...

You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the...

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advi...

The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two.)

There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?

You find that the execution time of reports in your data warehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in perfor...

You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives: Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLE...

A user executes a query on the EMP table, which contains thousands of rows, to get details about employees in one of the departments. The user receives the following error: SQL> SE...

You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?

View the Exhibit. Using Database Control, you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5:00 p.m.every Friday. When you exa...

The warning and critical threshold values have been set to 85% and 97%, respectively, for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning...

You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 D...

You work as a database administrator at certkiller.com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, h...

When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command? (Choose four.)

You were recently hired by certkiller.com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password prot...

These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT Name Null? Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASH...

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?

Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)

You want to create a consumer group,GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GRO...

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespac...

In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database...

Why would you use the following FLASHBACK TABLE command? FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi');

What effect should the loss of an index tablespace have on an Oracle instance that is running?

By using the transaction identifier provided by ______ for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction.

You work as a database administrator at certkiller.com. Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change...