ocp 053 exam c 60-90

62.you are querying v$backup_async_io determine which files are the bottleneck during rman backups.what columns should you use to identify cottlenecks?

d.divide log_waits by io_cout and look for a lkarge number

63.under what circumstances would you use transparent encryption for your tman abckups?

c.when you want to restore the backup to the same database and you are using a wallet

64.which of the following initialization parameters are specific to an asm instance?

a.asm_power_limit

d.asm_disk_limit

e.asm_diskgropups

65.which of the following clasuses are valid for the flashback table command

c.to timestamp

d.to before drop

67.you need to perform user-managed complete database recoverry.whst information do you need toi retrive from v$recovery_log?

b.the atrchived redo log files required for recovery

68.in rman ,you execute the command configure backup optimization on so that you can avoid backing up objects that are already backed up sufficientky within the retention 

policy how ever you want to make an addtional backup of the users tablespace to a remote disk for offsite storage

d,use the force option;backup forcre tablespace users';

69.you work as a database administator for veedol inc.your manager wants to run a job that updates the transation table every 30 minutws.to xhedual the job,you have to 

set the values of the intercal element.which of the following setting for ther repeat_intercal argument will archive the 

d.'freq=munutely ;intercal=30'
72.many rman setting help in automation or simplification using rman ,where are these setting stored?

each correct answer represents a complete solution

d.target database conteol file

d.recovery catalog

73.which of the following values of the statistics_level intialization parametr should be set to include plsn execution statistics in the awr

d/.all

75.the automatic database diagnostic monitor(DDM) stores its snapshots in the automatic workload repository .

in which of the following tablespade s the automatic wourlklaod repository resides?

c.sysaux

76.within a locally managed tablespace,you can have these two types of extents managemrnt,each corrdct answer represents a complete solution

b.automatic

d.uniform

80.which of the following dunamic performance views will you query to view the valid for nls paramewtrs 

nls_language,nls-sort，nls_territorry and.

d.v$nls_valid_values

82.which of the following file types are by defalut stored in the flash recovery ars.if the files have been defined?

a.archive redo log files

b.database falshback logs

drecovery manager backups

86.which of the following helps the dba to manage the tablespace as a single unit without taking into account the structure and size of the underlying datafiles?

d.bigfile tablespace

89.you work as a database administrotor for your company.the com[pany uses oacle as its database .yhr manager of 

the company want you to move the company's databases to another server.as the performance of the old server is now degraded,which of the following rman commands will you use to accomplish the task?

a.duplicate