1Z0-043 Exam Questions

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

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? (Choose all that apply)

Consider the following command to add a new disk group called "tdgroupA" with two failover groups: CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK '/device...

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 execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN( SIMPLE_PLAN => 'pr...

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)

The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?

Which statement is true regarding the creation of nested plans using Resource Manager?

You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to...

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could...

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable t...

Consider the following scenario: You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following comm...

You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your quer...

You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m.the current log sequence number was 369. Also...

You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?

While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: (a) high availability of data (b) faster primary...

You are using Oracle Database 10g. The log LOG_ARCHIVE_FORMAT parameter is set to ' LOG%t_%_s_%r.dbf'. Why is %r used in the file name format?

View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the Flashback Versions Query, you find that the first two updates are not l...

View the Exhibit. You have more than one table in the recycle bin having the same original name, DEPT2. You do not have any table with the name DEPT2 in your schema. You executed t...

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?

In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which compone...

You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you not...

In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate...

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be...

You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE...

Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?

In your production database, you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct? (Choose two)

By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: (a) list o...

You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup? (Cho...

In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one o...

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the da...

You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback lo...

The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without...

You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLA...

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in t...

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for t...

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

What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery? (Choose two)

While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to re...

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD.The default format of which two data types would be affected by this setting? (C...

For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? (Choose four)

You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the databa...

Which statement is true while creating subplans using Resource Manager?

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

In your test database, you have created the ORDERS table as an index-organized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on th...

A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does...

Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREA...

You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash re...

Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?