You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?()A.Use the command PURGE BINARY LOGS and specify a binary log fil

题目
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?()

A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files

B.Execute the PURGE BINARY LOGE NOT USED command

C.Remove all of the binary log files that have a modification date earlier than today

D.Edit the .index file to remove the files you want to delete

E.Ensure that none of the attached slaves are using any of the binary logs you want to delete

相似考题

1.What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

2.Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance：LOG_ARCHIVE_DEST_1=’LOCATION=/disk1/arch’LOG_ARCHIVE_DEST_2=’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3=’LOACTION=/disk3/arch’LOG_ARCHIVE_DEST_4=’LOCATION=/disk4/archMANDATORY’Identifythestatementthatcorrectlydescribesthissetting.（）A.TheMANDATORYlocationmustbeaflashrecoveryarea.B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.

3.YouhaveconfiguredflashrecoveryareainyourdatabaseandyousetthefollowingInitializationparametersforyourdatabaseinstance：LOG_ARCHIVE_DEST1=，，LOCATION=/disk1/archMANDATORY’LOG_ARCHIEVE_DEST2=，，LOCATION=/disk2/arch’LOG_ARCHIVK_DEST_3=，，LOCATION=/diSk3/archLOG_ARCH1VK_DEST_4=’LOCATION=/disk4/arch’LOG_ARCHIVE_MIN-SUCCEED_DEST=2Whilethedatabaseinstanceisfunctional，yourealizedthatthedestinationsetbytheLOG_ARCHIVE_DEST_IparameterIsnotavailableforthearchivedredologfiletobecreatedin.Allredologgroupshavebeenused.Whathappensinaneventoflogswitch？（）

4.Merry Christmas, George! Here is a card for ________, with ________ best withes.A.you…yourB.you…ourC.us…ourD.us…your

参考答案和解析
参考答案：A, E
更多“You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?() ”相关问题

  • 第1题：

    Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles？（）

    A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1；

    B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1；

    C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2；

    D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2；

    E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3；

    F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3；


    参考答案：A, C

  • 第2题：

    To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()

    A. LOG_HISTORY

    B. JOB_LOG_RETENTION

    C. WINDOW_LOG_RETENTION

    D. WHICH_LOG

    E. LOG_NAME


    参考答案：A, D

  • 第3题：

    当启动一个Oracle实例时,初始化参数()指出为数据文件信息保留的SGA空间的数量。

    A.DB_FILES

    B.DB_DATAFILES

    C.DATABASE_FILES

    D.LOG_FILES


    参考答案：A

  • 第4题：

    Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask?()

    A.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，job_name=>’JOB1’）；

    B.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，job_name=>’JOB_LOG’）；

    C.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，which_log=>’JOB1’）；

    D.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=>5，which_log=>’JOB_LOG’）；


    参考答案：D

  • 第5题：

    You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = ‘LOCATION=/disk1/arch‘LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch‘LOG_ARCHIVE_DEST_3 = ‘LOACTION=/disk3/arch‘LOG_ARCHIVE_DEST_4 = ‘LOCATION=/disk4/arch MANDATORY‘Identify the statement that correctly describes this setting.（）

    A. The MANDATORY location must be a flash recovery area.

    B. The optional destinations may not use the flash recovery area.

    C. This setting is not allowed because the first destination is not set as MANDATORY.

    D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.


    参考答案：D

  • 第6题：

    （ ） – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A．your；my

    B．you；mine

    C．you；us

    D．your；us


    正确答案：D

相关内容