1Z0-043 Exam Questions

While setting up the threshold for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be...

You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Wh...

You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario? (Choose two.)

View the Exhibit. You executed the following command to perform a backup of the USERS tablespace: RMAN>BACKUP TABLESPACE USERS; Which type of backup would this command perform?

You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?

View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting? (Choose two.)

The current time zone for one of the user sessions is set to the database local time zone. For one application, the user session requires the time zone to be set to the local opera...

You work as a database administrator at certkiller.com. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, whil...

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query Which statement is correct regarding the query output?

Consider the following configuration: /devices/D1 is a member of disk group dgroupA. /devices/D2 is a member of disk group dgroupA. /devices/D3 is a member of disk group dgroupA. Y...

You work as a database administrator at certkiller.com. In your production database there is a job, CALC_STAT, which has been scheduled to run every Friday at 5.00 p.m.CALC_STAT up...

Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases ini...

The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log grou...

You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?

You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2 with one device each. In the par...

An RMAN backup job fails, displaying the following error: ORA-19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions c...

Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m.as follows: SQL> DROP TA...

You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME '2004-08-05:12:10:03' 3 USING BACKUP CONTR...

While creating a job class using the DBMS_SCHEDULER package, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?

You are designing an application for certkiller.com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of cust...

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace t...

You want to configure the Flashback Database feature and retain flashback logs for three days. The steps used in this process are: (A) Set the retention target: SQL> ALTER SYSTEM S...

In which scenarios would you rebuild an index? (Choose all that apply.)

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE...

Which statement correctly describes the change tracking writer (CTWR) background process?

You work as a database administrator at certkiller.com. In your production database, you observe that users' transactions are consuming a lot of resource and you plan to impose res...

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the...

You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database: RAMN>REPORT NEED BACKUP days 3; What would be the output of this command?

Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived an...

In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command:...

While designing your database, you have created the EMPLOYEES table as an index-organized (IOT). You want to create a bitmap index on the JOD_ID column to make queries faster. Whic...

View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m.You noticed this at 11:00 a.m. and you want to perform...

You work as a database administrator at certkiller.com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk...

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn write...

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files fr...

In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being pe...

You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID'=*'; Which stateme...

View the Exhibit. A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts....

Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which tas...

Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work...

On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation,...

View the Exhibit and examine the Flashback Database architecture. Identify the missing component shown with a "?"= in the Flashback Database architecture.

Case 1: 1.Shut down the database and perform a backup. 2.Restore all the data files. 3.Mount the database. 4.Recover the database. 5.Without applying all the redo log files, open t...

For the V$SESSION_LONGOPS view, you find that some of the database users have long- running queries that consume a lot of CPU time. This causes performance problems for other users...

View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tables...

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use...

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state? (Choose two)

What purpose would you achieve by enabling the block change tracking feature?

You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?