Category «1Z0-043»

What would you do in this scenario?

Every Sunday, consistent backups are performed on your database. Because of a usererror, you performed an incomplete recovery on Tuesday and opened the database with theRESETLOGS option. A user error occurs again on Thursday, which necessitates anincomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario? A.recovery cannot be …

Which two statements are correct?

You executed the following FLASHBACK TABLE command:FLASHBACK TABLE emp TO TIMESTAMP (’11:45′,’hh12:mi’); Which two statements arecorrect? (Choose two.) A.The FLASHBACK TABLE statement will not be written to the alert log file. B.The EMP table that was dropped by mistake from the database will be restored. C.The changes made to the EMP table since the specified …

Which two statements are correct regarding the Flashback Versions Query feature?

Which two statements are correct regarding the Flashback Versions Query feature? (Choosetwo.) A.You can use this feature to identify the committed versions of the rows, but not the uncommitted versions. B.You can use this feature to identify the versions of V$ views. C.You can use this feature to identify the inserts, deletes, and updates performed …

Which additional memory parameter(s) should be configured to perform a transportable tablespace import?

The database has the data block size set to 8 KB. You need to import a tablespace with a 4KB block size into the database. Which additional memory parameter(s) should beconfigured to perform a transportable tablespace import? A.DB_4K_CACHE_SIZE only B.DB_8K_CACHE_SIZE only C.DB_BLOCK_SIZE and DB_4K_CACHE_SIZE D.DB_BLOCK_SIZE and DB_8K_CACHE_SIZE E.SGA_TARGET and DB_4K_CACHE_SIZE F.DB_CACHE_SIZE only Show Answer

Which two statements are true?

You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A andCUST_JOB_1_B. Which two statements are true? (Choose two.) A.The member jobs would get dropped when the job class is dropped. B.Both the jobs would be executed concurrently. C.The member jobs would get disabled when the job class is dropped. D.The attributes defined at the …

Which two statements are true?

You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A andCUST_JOB_1_B. Which two statements are true? (Choose two.) A.The member jobs would get dropped when the job class is dropped. B.Both the jobs would be executed concurrently. C.The member jobs would get disabled when the job class is dropped. D.The attributes defined at the …

How would you instruct RMAN to use the block change tracking feature when performing incremental backups?

You are managing a database for which incremental backups can be very time consuming.In order to perform optimized incremental backups you enable the block change trackingfeature.How would you instruct RMAN to use the block change tracking feature when performingincremental backups? A.You need to mention it with every BACKUP command. B.The block change tracking feature is …

what point in time can the data be recovered?

You have only two redo log groups and these groups get overwritten several times in a day.Your database operates in NOARCHIVELOG mode and user-managedconsistent backups are performed every Sunday night. On Thursday morning, you find thatan important table has been dropped and purged. With reference to this scenario, up to whatpoint in time can the …