053 OCP 易混20题

QUESTION 83

You enable block change tracking.You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE;

The next day, you issue thefollowing command:

BACKUP INCREMENTAL LEVEL 1CUMULATIVE DATABASE;

Which statement about the use of thechange tracking file is true?

A.RMAN reads the block change tracking file only when it performs the incrementallevel 0 backup.

B.RMAN reads the block change tracking file when it performs both incrementalbackups.

C.RMAN reads the block change tracking file only when it performs the incrementallevel 1 backup.

D. RMAN does not read the blockchange tracking file when it performs either incremental backup.

 

Correct Answer: C

QUESTION 135

What happens when you run the SQLTuning Advisor with limited scope?

A.Access path analysis is not performed for SQL statements.

B.SQL structure analysis is not performed for SQL. statements.

C.SQL Profile recommendations are not generated for SQL statements.

D. Staleness and absence ofstatistics are not checked for the objects In the query supplied to the SQLTuning Advisor.

 

 

Correct Answer: C

QUESTION 137

You execute the following FLASHBACKTABLE command:

FLASHBACK TABLE emp TO TIMESTAMPTO_TIMESTAMP('2000-01-04 11:1:10:004,'YYYY-MM-DD HH24:HI:SS');

Which two statements are correct?(Choose two.)

A.The EMP table that was dropped by mistake earlier is restored

B.The FLASHBACK TABLE statement is executed as a single transaction

C.The FLASHBACK TABLE statement does not maintain existing indexes on the EMP,table.

D. The changes made to the EMP tablesince the specified time are undone if noconstraint is violated duringflashback

 

Correct Answer: BD Section:

QUESTION 147

Identify the scenarios in which theRMAN CROSSCHECK command Is useful. (Choose all that apply.)

A.to check that the obsolete backups are deleted from the repository records andfrom the disk

B.to update the RMAN repository if you delete archived redo logs with operatingsystem commands

C.to update outdated information about backups that disappeared from disk or tapeor became corrupted and inaccessible

D. to synchronize the actual fileson disk or in the media management catalog with the RMAN repository for whichthe backup was not taken using RMAN

 

 

Correct Answer: AC

QUESTION 157

The database is configured inARCHTVELOG mode. The database needs to be up 24 X 7. You want to performuser-managed backup for the data flies of the HR_DATA tablespace. To accomplishthe task, you issued the following command:

SQL> ALTER TABLESPACE hr_dataBEGIN BACKUP;

Which two statements are true inthis scenario? (Choose two.)

A.No transaction on the tablespace is allowed but you can perform queries.

B.The tablespace will automatically come out of backup mode when the file copy iscomplete.

C.The checkpoint change number is frozen in headers of the data files until thefile is removed from backup mode.

D. The database writes the beforeimage of an entire block to the redo stream before modifying a block for thefirst time.

 

Correct Answer: CD

QUESTION173

Youexecuted the following query:

SELECToldest_flashback_scn, oldest_flashback_time FROM VSFLASHBACK_DATABASE_LOG;Considering that all the redo logs are available, what Information can youderive from the output of the  precedingquery?

A. the time when the last flashback operation In yourdatabase was performed

B. the time when the first flashback operation in yourdatabase was performed

C. the approximate time and the lowest system changenumber (SCN) to which you can flash back your database

D.the system change number (SCN) and the time when the Flashback Database wasenabled in the database instance

 

Correct Answer:C