Category «1Z0-043»

What would be the impact of this setting?

You are using an Automatic Storage Management (ASM) instance to manage the files ofyour production database. You have two disk groups, DG1and DG2with one device each.In the parameter file of the production database, the following parameters have beenspecified:DB_CREATE_ONLINE_LOG_DEST_1 = ‘+dg1’DB_CREATE_ONLINE_LOG_DEST_2 = ‘+dg2’What would be the impact of this setting? A.When a new log group is …

Which two actions could you take to resolve the error and avoid this error in the future?

An RMAN backup job fails, displaying the following error:ORA-19809: limit exceeded for recovery filesYour analysis shows that the Flash Recovery area is full. Which two actions could you taketo resolve the error and avoid this error in the future? (Choose two.) A.takes the backup of the flash recovery area less frequently B.increase the value of …

which action should you take?

Your database operates inARCHIVELO Gmode. User-managed consistent backups are performed every Sunday night.On Tuesday, client A drops a table at 8:00A.m. as follows:SQL> DROP TABLE cust_ord PURGE;Table dropped.Client B executes a query at 9:00 A.m. on the same table as follows:SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord*ERROR at line 1:ORA-00942: table or view does …

which situation would the above recovery be required?

You performed an incomplete recovery on your Oracle Database 10g database using thefollowing command:SQL> RECOVER DATABASE2 UNTIL TIME ‘2004-08-05:12:10:03’3 USING BACKUP CONTROLFILE;In which situation would the above recovery be required? A.A user table was lost at the specified time. B.A redo log file was lost at the specified time. C.The backup control file is on …

What would be the impact of this setting?

While creating a job class using the DBMS_SCHEDULER package, you set the logging levelto LOGGING_RUNS. What would be the impact of this setting? A.Oracle Scheduler would write detailed information to the job log for each run of each job in the job class. B.Oracle Scheduler would write detailed information to the job log for the …

Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?

You are designing an application for Pass4sures.com and you have been asked to design adatabase table to facilitate monthly bill generation. The bill would include details of customercalls, listed in chronological order. Which method would you follow to achieve this objectivewithout increasing the overhead of sorting the rows? A.create a hash cluster to store the …

What can you do to skip backing up the TOOLS tablespace without changing the current backup optimization setti

You set the recovery window to seven days and the backup optimization to ONUsing the CONFIGURE command of Recovery Manager (RMAN). The most recent backupof the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is readonly.On February 21, when you execute a command to back up all the tablespaces to disk, …