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 […]

Read More

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 […]

Read More

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

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

which component would require less memory?

You configured the large pool for Oracle backup and restore operations. As a result, whichcomponent would require less memory? A.streams pool B.shared pool C.log buffer D.keep buffer cache E.recycle buffer cache Show Answer

Read More

which component would require less memory?

You configured the large pool for Oracle backup and restore operations. As a result, whichcomponent would require less memory? A.streams pool B.shared pool C.log buffer D.keep buffer cache E.recycle buffer cache Show Answer

Read More

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 […]

Read More